Updating Sharepoint through Alteryx

Question

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

binu_acs · Answer

@Kallis Sample attached

REcordCount_sample_16082024.yxmd

Kallis · Answer

Hi @binu_acs

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?

binu_acs · Answer

@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