Alteryx Designer Desktop Discussions

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

Best way to update fields inside SharePoint list

Vineet003
7 - Meteor

I am new to alteryx so apologies if this is a stupid question. I have a workflow that daily deletes an entire sharepoint list and replaces it with new data from an excel file, i would like to copy data in ID column to another column ID3 - please note that here ID refers to the ID automatically generated by sharepoint. 

 

 

To do this currently i have two flows - the first flow dumps data from excel file to SharePoint List (finishes in 2-4 mins), the second flow adds the ID3 value - but this flow currently takes 20 mins to run only for 2000 rows :( and i am updating only 1 column of data

Vineet003_0-1681279722493.png

Flow 1

Vineet003_1-1681279731926.png

Flow 2

 

Is there a way to do both simultaneously ? and possibly faster

 

Many Thanks !

2 REPLIES 2
BS_THE_ANALYST
14 - Magnetar
14 - Magnetar

@Vineet003 Just to answer your question about doing them simultaneously workflow 1 and then workflow 2:
https://www.youtube.com/watch?v=9AiMdKp7wmk&ab_channel=DigiBytes 

There's a really cool macro used here. It will run workflows sequentially - conditionally infact, workflow 2 will only run if workflow 1 is successful. Hopefully that answers that part. If the macros aren't listed in the video, you can find them here: http://www.chaosreignswithin.com/p/macros.html 

All the best,
BS

 

All the best,
BS

LinkedIN

Bulien
In this video, Vaibhav Gupta is explaining the use of two Crew Macros of alteryx, namely - Runner & Conditional Runner Macros. He is covering both the scenarios of Failure & Success with simple examples. You can also learn more about alteryx by visiting following links: Alteryx Beginner Video: ...
Vineet003
7 - Meteor

Thank you ! this is very helpful for the first question. Do you have any suggestions on how i can make this flow faster and assign ID3 the same moment ID is being created ? here the main issue is since i deleteting the entire sharePoint list and readding data, it assigns new ID and i can't think of a way to pass this value to ID3 column

Labels
Top Solution Authors