Hi Community!
I built a flow to grab all the data from a sharepoint tasklist and insert it into an excel file in a sharepoint folder, every week at a specific time adding the new data.
At the moment I have 1095 rows in the tasklist and it takes 45 minutes to run and complete.
Is there any other, faster, more elegant way to do this? Later on I need to grab this for PowerBI automatically.
(.csv might be an option for weekly and then combine them somehow but I did not venture that far, I would like to automate this as much as possible)
My current flow:
Any input is appreciated.
Br,
Miklós