Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
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