Best way to update fields inside SharePoint list
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
Flow 1
Flow 2
Is there a way to do both simultaneously ? and possibly faster
Many Thanks !
- Labels:
- Sharepoint
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
