I have built a flow that is an approval for hires if they are over budget. This seems to work pretty well, except i have ran into the issue that when there are multiple approvals, if one of the people in the chain is slow to approve then the approval will duplicate and be sent to the person who has already approved/rejected it when the scheduled recurrence kicks off again (runs every 30 minutes). To "fix" this I added a column in my excel sheet (where this data is all coming from) and added an "Update Row" flow in this, so that once the flow runs, it puts "In progress" in that column, which there is an IF statement in the Excel column that acts as filter to determine if the person is over budget and in progress or not.
The Update Row works, but it only updates the first row that meets the criteria, it doesn't update multiple. I cant find an "Update Rows" flow or something, so i didn't know if there was another way i can update multiple excel rows at once.
Very cool use-case, thanks for sharing! A couple of questions:
Keep us posted.
If this reply has answered your question or resolved your challenge, please consider marking it as a Solution. This helps other users find it more easily via search.
Hi @Anonymous ,
Flow doesn’t have an action Update rows. If you want to update multiple rows at a time, please try to turn on Concurrency Control of Apply to each. Please go to Settings> Concurrency Control, turn it on and set the degree of parallelism.
Besides, your flow is triggered by Recurrence, it will be triggered every 30 minutes. So even though the previous approval request has not been approved, the next run will be kicked off again.