I have a flow which generates a .csv file from sharepoint list items and emails it to requester, just like export excel function in sharepoint list. I have people picker field with multiple selections allowed, the names dont display correctly if I use that field directly. I have a apply to each loop on that people picker field and using get user profile(v2) to get each display name and appending it to a string variable and then using a append for array variable to generate csv using the data operation generate csv table action.
Until Sept 16th the flow was running fine and took no more than 30 minutes to export a list of 400 items. Now its taking 2- 5 days for a flow run to complete. The data did not change and the flow did not change. The apply to each loop where I am getting the user names and appending them to variable is taking too long now.
Anybody can provide insights on what could be the reason ?
Apply to each 5 is where i get all the list items, apply to each 6 is where loop into the people picker field with multiple selection enabled. append all names into a string variable which is then appended to a array variable to be used to create .csv file.
Could you confirm if the premium license has solved your issue?
You could use the new analytics feature to check your Flows usage:
Or you could check on a individual Flow basis, by clicking 'Analytics' inside the Flow portal
Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!
Many congratulations to the Season 1 2021 Flownaut Crew!
Check out our new profile badges recognizing authored solutions!
Check out the community blog page where you can find valuable learning material from community and product team members!