People Picker with email and multi select

(0) Share

Report

Posted on by MS_Gonzo

Hi guys,

I am working on an issue, which eludes me.

I have an App which is connected to a sharepoint list (mylist). All columns of this list are formated to single line of text.

In this App I want a user to be able to select a person responsible for a task and to have the email adress for the selected user stored in a column in mylist. I have realized this by a combobox with Items property: Combobox1_1 Items = 'Office365-User'.SearchUser({searchTerm:ComboBox1_1.SearchText;top:10})

Additionally I use a textbox with Update property: ComboBox1_1.Selected.Mail. Subsequently I use a Power Automate Flow to notify the repsonsible person about the task.

This works well and just as intended. However, I was asked to include multiple selections for the responsible person, so that the notification is sent to an entire team.

I have tried a lot. Especially with Concat function but nothing seemed to work. Does anyone have any ideas?

BR,
Gonzo

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Sort by

zmorek 3,272 on at

Like (0)

Report
Copy link

Link copied!
If you've got AllowMultipleSelections set to true, you're already most of the way there.

Your Concat() should look like:

Concat( ComboBox1_1.SelectedItems; Mail & "; " )

Was this reply helpful? Yes No
MS_Gonzo 70 on at

Like (0)

Report
Copy link

Link copied!
Thank you very much for your reply. I have already set multiple select to true. However, my textbox looks like this with
Concat( ComboBox1_1.SelectedItems; Mail & "; " )
Do you have any idea why it is displayed like this?

Was this reply helpful? Yes No
MS_Gonzo 70 on at

Like (0)

Report
Copy link

Link copied!
Hey guys,

so I have noticed, when I change the above formula to
Concat( ComboBox1_1.SelectedItems; Email & "; " )
I get some very strange symbols in the text box (See picture). However, when I submit the form, just one of the selected people is written to to corresponding column in my sharepoint list AND instead of those strange symbols, the sharepoint list just shows again three semicolons.

Was this reply helpful? Yes No
Verified answer

MS_Gonzo 70 on at

Like (0)

Report
Copy link

Link copied!

For everyone interessted I figured it out. Literally the only thing missing was multiple; true at the end.
'Office365-Benutzer'.SearchUser({searchTerm:ComboBox1_1.SearchText; top:10; multiple:true})

Was this reply helpful? Yes No