Unanswered

Do until function

(0) Share

Report

Posted on by Community Power Pla...

Hello,

I've created a flow: sending email when a new cell "Yes" is added in excel and then to update each cell "Yes" with "No", just to stop the flow.

The flow works somehow -> it sends e-mail, it changes my cells from "Yes" to "No", but still, my run history is always red, due to failures at "do until" function.
The flow looks like this:

"Do until" function looks like this:

I suppose the problem is with "Current Iteration Index", but without it my flow doesn't loop, until all the cells became "No".

Do you know what could be the problem with my "do until" function?

Thank you!

Categories:

Building flows

I have the same question (0)

All responses (7)

Answers (0)

ScottShearer 25,270 Most Valuable Professional on at

Like (0)

Report

@Anonymous

Can you post a screen shot of the error?

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Yes, of course.

Error Details: Excel table already has a row with id '0No'.
clientRequestId: 74f3bdce-07a9-467c-98b3-df66cf9477fb

So, even if the flow found another "No" cells, it updates my "Yes" cells to "No".
But still, my flow failes.

Was this reply helpful? Yes No
v-litu-msft on at

Like (0)

Report

Hi @Anonymous,

Did the structure of the Do until action ever loop? After analyzing the logical structure of your Flow, I think it doesn't seem to loop, I hope I am wrong.

Could you please show the detail of the Variable for text No? According to your description, it seems like an array.

What's the function of variable empty for cells?

Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Hello @v-litu-msft,

Yes, it seems it loop, cause it updates all my values from "YES" to "NO".

Screen with variable for text NO:

Variable "Empty text" I've created to the second condition, so now it is deleted.

My question is "Do until" function should have an end or no?
I mean the loop shouldn't be endless. Isn't that?

Thank you!

Was this reply helpful? Yes No
v-litu-msft on at

Like (0)

Report

Hi @Anonymous,

I am confused with your requirements that whether you want to update all rows in the table to "No" or update the single row which is Yes.

If you want to update all rows to "No", you can create List rows present in a table and Apply to each actions to update all rows in the excel file. It can update all the rows and won't be a loop.

And the error you met is conflict about the column value, it isn't a good way to get rows with "New task?" is Yes. You can use the Filter query to get rows with "New task?" is Yes.

Best Regards,

Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Hello, @v-litu-msft and thank you for your reply.

I will test your solution and will return to you with my feedback.

Thank you!

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Thank you, @v-litu-msft.

I've tried your solution, but, unfortunatelly, it still doesn't work.

In order to recap, I would to like to build a flow that:
1) Deppending on reccurence, will search information in my Shared Excel File (Column "New Task")
2) And when will find one or more cells with text "Yes" in Column "New Task" will send one email per finded text "Yes" and when will find nothing/empty cells in Column "New Task" to do nothing.
3) After sending emails, Flow should update each finded cell with text "Yes" in Column "New Task" with text "No".

Here is my current flow structure:

Any update will be helpful.

Thank you!

Was this reply helpful? Yes No