Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.
Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Updating Sharepoint through Alteryx

Kallis
8 - Asteroid

Hello Everyone

 

I have a process that updates both a shared folder and a directory in Sharepoint. This was working well until there wasn't anything to write. I mean, if there isn't any record to write into Sharepoint, the WF goes into an indefinite loop. It just does not stop. Is there a way to not to write into Sharepoint if there are no records?

 

Thanks in advance 

Bobji

3 REPLIES 3
binuacs
21 - Polaris

@Kallis you can check the record count using the "Count Record" tool then add a filter and pass the records only if the count is greater than 1 else don't process. you can connect the sharepoint output to the true anchor of the filter tool

Kallis
8 - Asteroid

Hi @binuacs 

I thought about that but I was confused how to go about it.

Count Records will return a number and it will be stored in the [Count] variable.

In the Filter Tool, how to form the statement? 

 

I mean, if [Count] > 0 and then? Where to pass the data? Is it possible to control the True anchor of the Filter tool? 

binuacs
21 - Polaris

@Kallis Sample attached

image.png

Labels
Top Solution Authors