In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

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