In case you missed the announcement: The Alteryx One Fall Release is here! Learn more about the new features and capabilities here
ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests Early 2026. Make sure to check your account preferences in my.alteryx.com to make sure you have filled out your security questions. Learn more here
Start Free Trial

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
15 - Aurora
15 - Aurora

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