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
20 - Arcturus

@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
20 - Arcturus

@Kallis Sample attached

image.png

Labels