cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ovis2018
Helper I
Helper I

Flow doesn't work when using dynamic content of "People/Group" from SharePoint column

Hello - trying to resolve an issue I seem to be having with MS Flow where any reference to or use of the dynamic content of a People/Group column from SharePoint sends the entire flow into havoc.  There's a few instances where using this column type doesn't seem to work that I'd love to have some assistance with. 

(1) When sending an email to the individual of the People/Group column -- what happens when I add in the dynamic content field into the To: of a "Send an Email" action, MS Flow automatically adds an "Apply to each" action and inserts that dynamic content into the Apply to each action.  It also does this when I insert the dynamic content of the people/group into the email body.  

While it's not a big deal if that the Apply to each is added, but once it is added no emails send even though testing the workflow shows no errors and appears as though all conditions and workflow steps worked correctly.

Flow 11.PNG

 

 

(2) When I create an HTML table to insert into an email and include a dynamic content of people/group, it doesn't display right - see image below

flow 12.PNG Thanks for the aid!

2 REPLIES 2
ScottShearer
Super User
Super User

@ovis2018 :

 

The Flow is automatically creating a loop when you reference the person or group column because the column is configured to allow for more than one person or group to be selected.

 

The emails are not being sent because you have not provided it the email addresses.  You need to select the entry in Dynamic properties that is the person or group column name followed by "Email".  If you do so, an individual email will be sent to every person or group listed.

 

The email text is not formatted properly because you need to click on Advanced properties in the email screen and set "Is HTML" to Yes.

 

In my screen shot below, I have a person or group column called PG which allows for multiple names to be selected.

MulitPG.jpg

MulitPG1.jpg

 

If this solves your issue, 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

Ngā mihi nui Scott! 

(Thank you very much)

 

I was having the same problem (struggling to send to an email address which is an Active Directory Person using Dynamic Content).

 

Your worked example highlighted that I needed to reference the column object 'Manager; in 'Select an output from previous steps' in order to use a field from it 'Manager Email'. 

 

My solution now works 👍

 

JSimmons_0-1642043238382.png

 

 

 

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

May UG Leader Call Carousel 768x460.png

June User Group Leader Call

Join us on June 28 for our monthly User Group leader call!

MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

Power Automate Designer Feedback_carousel.jpg

Help make Flow Design easier

Are you new to designing flows? What is your biggest struggle with Power Automate Designer? Help us make it more user friendly!

Top Solution Authors
Users online (1,403)