Glitch prevention and mitigation

(0) Share

Report

Posted on by LR-10091113-0

I have a simple flow that checks a excel sheet every 30 minutes. It filters the worksheet down to 1 column, and if it sees a particular word in that column, it will pull the data from that row and send an email with the extracted data. I have an issue where if after a week of it operating, it will change the flow by itself if I open the flow at all to look at it. It keeps adding "For Each" inside a "Apply to each" loop causing every email on the worksheet to receive a email. I need to find a way to prevent this because now I need to go back into the flow and delete everything in the loop and rewrite it. Before someone says "you can just edit the expressions removing the "for each," I have done that and it will fail unless I completely delete it and remake it.

Any advice will help.

Categories:

Process Advisor

Screenshot 2025-0...

I have the same question (0)

All responses (4)

Answers (0)

LR-10091113-0 4 on at

Like (0)

Report

Glitch prevention and mitigation

I use item()?['EMAIL']. I'll send you an email to get more in depth with you!

Was this reply helpful? Yes No
Building with Why 321 Super User 2025 Season 2 on at

Like (0)

Report

Glitch prevention and mitigation

@LR-10091113-0 Please share the email address statement you are using. It sounds like the email address is coming from the Excel Spreadsheet. If you use the template for the email address as: items('Apply_to_each)?['ColumnName'] Substitute the email address column name for ColumnName.

If you need additional assistance check out my YouTube video https://youtu.be/NLnwxa5mt9M?si=e508tFk1JKJCxivH or send me an email at nextsteplowcodelabs@gmail.com

1 people found this reply helpful.

Was this reply helpful? Yes No
LR-10091113-0 4 on at

Like (0)

Report

Glitch prevention and mitigation

The input is that after it gathers the Excel data, filters down to just look at the STATUS column, it looks for the words RECEIVED, FULFILLED, SHIPPED, DELIVERED. If and when it sees those words in the column, it will apply the same action to each row it sees a word. When For Each creates itself, it will do the same thing but instead of just sending an email from the row the word was found on, it will send it to every email it sees.

Was this reply helpful? Yes No
Suggested answer

Building with Why 321 Super User 2025 Season 2 on at

Like (0)

Report

Glitch prevention and mitigation

Can you share screenshots of one of the inputs to the Email/Excel steps.

My guess is that the inputs for the Email and Excel update are using values from the List Rows from the spreadsheet while the Apply to each is referencing the body of the Filter Array.

To fix this, and ensure you don't get the same problem again, you will need to reference the Filter array instead of the List Rows.

Use this format for your inputs to the Email and update Excel steps.

items('Apply_to_each)?['ColumnName']

If this helps, please mark as answered and like.

Taking the Next Step

Was this reply helpful? Yes No