Answered

Stuck when emailing and displaying multiple users in a SPO persona field

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi,

I have a SPO field in my canvas app which allows multiple person values to be selected. I wanted to email each user but I have a flow sending the email as I need to also send a PDF of the data to the recipients. It all worked fine, until I added another variable to my flow to capture the multi person values and now it doesn't work.

I added a a variable to my floe, capturing the data as string

I have a HTML text box in my canvas app which displays all the data but when it comes to displaying the data from the muti select person field I cannot get it to display any values in Power Apps.

I tried things like

Concat(PIEmailccValues.SelectedItems.Email,";")

Concat(PIEmailccValues.SelectedItems.Email,",")

But all I see is semicolon or comma in the HTML box in PowerApps.

Can anyone help me.

Thanks

Categories:

Building Power Apps

All responses (3)

Answers (1)

Sort by

Verified answer

RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!
@Anonymous

Please consider changing your Formula to the following:

Concat(PIEmailccValues.SelectedItems, Email & ";")

I hope this is helpful for you.
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Perfect Thanks, I was close
Thanks for your help
RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!
@Anonymous

Yes you were close!

The Concat function expects the first parameter to be a table of records. The second argument is the string format (including references to the column in the first parameter records) that you want.

Technically, you could have used your formula with a little more modification:

Concat(PIEmailccValues.SelectedItems.Email, Email & ";")

Because...when you specified the .Email on the Table (SelectedItems) it would have produced a table with a single column of Email. You just needed to reference that in the string format part like it is above.