Best way to update fields inside SharePoint list

Question

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 !

Vineet003 · Answer

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

BS_THE_ANALYST · Answer

@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