Multi select people picker in Powerapps for Dataverse

(0) Share

Report

Posted on by Dronzer10

Hello,

I am building Powerapps form based on Dataverse. I have used text column and the used combobox for people picker.

items property: ShowColumns(Office365Users.SearchUser({top:999, searchTerm:Self.SearchText}),"Mail", "DisplayName")

defaultselected items: {Mail: ThisItem.Team, DisplayName: ThisItem.Team}

Update property : Concat(ComboBox1.SelectedItems,Mail,",")

This works fine but now when someone saves and later comeback to this field they find all the names concatenated. Inturn if they want to remove any name from this they are compelled to remove all the name and readd once again.

How we can solve this issue?

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Sort by

Verified answer

v-qiaqi@microsoft.com Microsoft Employee on at

Like (2)

Report
Copy link

Link copied!
Hi @Dronzer10,

Yes, this is caused by the formula you set for the DefaultSelectedItems property of the Combo Box. You set it as a concatenated string, which is a totally different data format with it in the Office365 table.

Modify the DefaultSelectedItems property of the Combo Box as below:

Ungroup(ForAll(Split(ThisItem.Team,","),Office365Users.SearchUser({searchTerm:Result})),"Value")

Was this reply helpful? Yes No
Dronzer10 51 on at

Like (0)

Report
Copy link

Link copied!

Wow!!

Was this reply helpful? Yes No
shaley68 2 on at

Like (0)

Report
Copy link

Link copied!

I have this exact setup (field name is different) and cant get this to work for me. What is Result referring to?

Here is my error message:

Was this reply helpful? Yes No
wrizk Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

the only correct solution out there!

Was this reply helpful? Yes No