Answered

List values of person or group field with multiple people in body of email

(0) Share

Report

Posted on by ScottRMeredith

141

I have a SharePoint List with a person or group field that allows for multiple selections to be created. I am trying to get the display names of the values into the body of an email that is sent to the assigned person (different field). I have tried multiple different options but cannot get a WF to run successfully.

WF Error.PNG

Categories:

General topics

I have the same question (0)

All responses (7)

Answers (1)

ScottRMeredith 141 on at

Like (0)

Report
Copy link

Link copied!

Here is the WF as built.... The Create HTML Table Columns is set to automatic.

Was this reply helpful? Yes No
ScottRMeredith 141 on at

Like (0)

Report
Copy link

Link copied!

So I finally got a WF to run successfully, but not getting the desired formatting. Here is the flow....

And here is how it looks in my email....

Obviously I want the names only listed once, preferably without the quotations and brackets.

Thank you in advance.

Was this reply helpful? Yes No
Verified answer

efialttes 14,756 on at

Like (0)

Report
Copy link

Link copied!

Hi!

Please check the following screenshots, in my List the multiperson column is called 'Users'

My flow design is the following:

Flow execution results:

Hope this helps

Was this reply helpful? Yes No
ScottRMeredith 141 on at

Like (0)

Report
Copy link

Link copied!

I tried to setup my WF to match yours, but each time I add the employee field (your users field) it automatically adds a for each loop. If this is how it has to be, then when I try to add the new html table to the email body, I don't have any options to get the new html table.

Was this reply helpful? Yes No
ScottRMeredith 141 on at

Like (0)

Report
Copy link

Link copied!

I got it to work thanks. The difference was to add the get item action after the WF triggered. I didn't think I needed it since it was triggered off the creation of a new item, but that did it. Thanks.

Was this reply helpful? Yes No
cgreenmzr 53 on at

Like (0)

Report
Copy link

Link copied!

I got this to work up to the point of generating the body I needed (see below), however when I use the output in either an email body or 'Compose', it displays with the HTML tags. Anyway to get around that?

Was this reply helpful? Yes No
ChadVKealey 1,393 on at

Like (0)

Report
Copy link

Link copied!

If you want the display names in a string (e.g.: Person1, Person2, Person3, etc.) rather than a table, you can use a select action and join (see https://youtu.be/fjYNT0EgzAU).

As far as getting the HTML to work in your email, make sure that you're using an email action that supports HTML and that it's enabled (might be under Advanced settings).

Was this reply helpful? Yes No