Unanswered

Trying to get mails from my sharepoint list - person or group colunm

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi Guys,

I have a fild that my users can set the responsible of the demand, it could be one or N people, the user is picked from my AD list.

now I have to pick the mails to send a report for this users, but i don't know how to do it.

i have to pick this e-mails and put in a string to use it as argument on my send mail function.

voul you help me please?

Categories:

Building Power Apps

All responses (5)

Answers (0)

Sort by

BCBuizer 22,899 Super User 2026 Season 2 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Anonymous,

You can use the Concat function to convert the records to a semicolon separated string, for instance:

Office365Outlook.SendEmailV2( Concat( First(Test).PersonMS.Email, ";" ), "Subject", "Body" )

In the above example I'm referring to the first recorde in my Test data source to retrieve the table from the PersonMS column (Person, multiselect). Then I select the Email column and concat them with a semicolon as separator, resulting in something like the below:

"user1@email.com; user2@email.com"

This can be used in combination with the SendEmailV2 function of the Office365Outlook connector.
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @BCBuizer maybe I explained it wrong.

Look i have an object, this object have a list of users (the responsibles of this item). to store this information I choosed the colunm type "Person or Group" on sharepoint.

Now I develop a new function to send an email to this guys, but how I collect their mails?

my object is maneged by a variable, how I can do to collect all the mails from this object to transform using your suggestion?
BCBuizer 22,899 Super User 2026 Season 2 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Anonymous ,

If the required item is saved in a variable, you can use that:

Office365Outlook.SendEmailV2( Concat( Variable.ResponsiblePersons.Email, ";" ), "Subject", "Body" )

In the above example I assumed the name of the variable is "Variable" and the name of the persons column is "ResponsiblePersons".
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

@BCBuizer dont work.

look this is my sharepoint list
this itens maarked are my responsible users, this collunm type is "Person or Group",when I store my data, the reponsible person goes together (I know we have the field "Created by", but my collunm Responsible accepts multiple options).

in the end of my workflow i have to send an email for all users setted on Responsible field.
But i dont know why i can do it.
I don't find any information about the properties of this type of field. So i don't know how to get this information or how this information are stored. is it an object? string? class? IDK.

I tried to get like you said, but Responsible.Email dont bring a string, and i dont know what type of data it brings.
BCBuizer 22,899 Super User 2026 Season 2 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Anonymous,

For each of the items in your sharepoint list, a table is stored in the 'Responsible' column. Therefore, if you have a single record saved in your variable, this is what the Person (multiple select) column looks like:

With the above example, the below code will send a mail to two people that are selected in the PersonMS column of the record that is saved in the variable:

Office365Outlook.SendEmailV2( Concat( Variable.PersonMS.Email, ";" ), "Subject", "Body" )