cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
rgbrasel
Level: Powered On

Flow Automatically Creates Foreach Loop

I'm attempting to create a simple notification Flow. It waits for a SharePoint list item to be changed and for a field to equal "Completed." In the Yes branch, I'm attempting to fire off three emails whose body text is based on information collected in the list. The fields are choices and text. For some reason, when I add one of my text fields in the body text of the 3rd email, Flow decides that my email step needs to be encapsulated in a Foreach loop.

 

The wisdom of having software make automatic decisions on the logical structure of a workflow notwithstanding, does anyone know how to prevent this? Or am I going to have to create another workflow to send this email?

 

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: Flow Automatically Creates Foreach Loop

@rgbrasel:

 

If you reference a column that can have multiple values, Flow will automatically put you into a loop.  That's why it loops when you reference your choice column - check boxes mean you can select multiple values.  I don't know why this would happen for a text column - it should not.

 

One work around is to loop through the choice column and append each value to a string variable.  Then, reference the variable in the email.  The email should obviously be outside and after the loop.

 

If this answers your question, please mark your post as solved.

 

Scott

 

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Scott
7 REPLIES 7
Super User
Super User

Re: Flow Automatically Creates Foreach Loop

@rgbrasel:

 

Can you post a screen shot of your Flow?  That will make it easier to assist.

 

Scott

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Scott
rgbrasel
Level: Powered On

Re: Flow Automatically Creates Foreach Loop

The foreach loop is automatically generated when I add the Technology Information Value to the Body Text. That column is a choice type that allows multiple selections.

tempsnip.pngScreenshot

rgbrasel
Level: Powered On

Re: Flow Automatically Creates Foreach Loop

If it helps, this is part of the Yes branch following a Condition.

rgbrasel
Level: Powered On

Re: Flow Automatically Creates Foreach Loop

The choice field is set up to display checkboxes and allow fill-in choices. I also just attempted to set a string variable based on that field, and the moment I tried to set the variable, it applied another foreach loop.

 

Super User
Super User

Re: Flow Automatically Creates Foreach Loop

@rgbrasel:

 

If you reference a column that can have multiple values, Flow will automatically put you into a loop.  That's why it loops when you reference your choice column - check boxes mean you can select multiple values.  I don't know why this would happen for a text column - it should not.

 

One work around is to loop through the choice column and append each value to a string variable.  Then, reference the variable in the email.  The email should obviously be outside and after the loop.

 

If this answers your question, please mark your post as solved.

 

Scott

 

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Scott
Highlighted
rgbrasel
Level: Powered On

Re: Flow Automatically Creates Foreach Loop

Ah! That makes sense now. I'm going to attempt that and post the results. Tomorrow--my brain is getting a little tired.

Community Support Team
Community Support Team

Re: Flow Automatically Creates Foreach Loop

Hi @rgbrasel,

 

Have you had an opportunity to apply Scott’s workaround to adapt your Flow?

If your problem have been solved, please go ahead and mark your post as solved by clicking “Accept as Solution” so that this thread will be marked for other users to easily identify!

If you need further assistance, please feel free let me know.

 

Best Regards,

Barry

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

Helpful resources

Announcements
firstImage

Microsoft Business Applications Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

firstImage

Watch Sessions On Demand!

Continue your learning in our online communities.

Power Platform 2019 Release Wave 2 Plan

Power Platform 2019 Release Wave 2 Plan

Features releasing from October 2019 through March 2020

thirdimage

Flow Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

fifthimage

Microsoft Learn

Learn how to build the business apps that you need

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Flow Community Video Gallery!

Users Online
Currently online: 204 members 2,293 guests
Please welcome our newest community members: