Hello,
I'm trying to get a flow to insert a row into a table, but it won't do it if the spreadsheet was recently opened. What I want to do is for the flow to attempt to insert the row but if the spreadsheet is locked, wait a few minutes and then try again. I've tried to use the Do Until to make this work but I haven't been able to get the syntax right.
Here is a graphic representation of what I'm trying to do:
https://preview.ibb.co/mJO1fH/Flowrepeat.png
Hi @ jasa88,
Do you want to create a flow to insert a row in the excel, and if the excel is locked, the flow would wait for a few minutes and would insert the row to the excel again until the row is inserted in the excel.
I have made a test on my side, and try to use "Do until" to realize your needs, but I couldn't manage to realize your needs currently, I would try again in the later, if I could accomplish your needs in the flow, I would reply here.
Regards,
Alice Zhang
Hi Alice,
Yes that's exactly what I'm trying to do. I tried to use a do until and set the condition to be when row_id is equal to row_id (in other words, once the row has been inserted into the spreadsheet and is assigned a row_id), insert the row, but if it fails, wait 5 minutes and loop again. The problem is that it keeps saying that the flow was successful after waiting 5 minutes and it doesn't loop around.
Did you ever solve this?
Hi Jasa, I gave up on writing to Excel and switched to storing in sharepoint list instead.
I did find a great post that helped me with "Do Until" https://powerusers.microsoft.com/t5/Building-Flows/do-until/td-p/95974
Clearing the count made my Do Until work for me.
Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.
Watch Nick Doelman's session from the 2020 Power Platform Community Conference on demand!
User | Count |
---|---|
41 | |
40 | |
37 | |
34 | |
30 |
User | Count |
---|---|
52 | |
38 | |
35 | |
32 | |
24 |