Answered

Populate users to People picker field

(0) Share

Report

Posted on by BenWip

Hi,

I am new to Power Apps. We have SP list1 with comma separated user emails in SLT field (User1@onmicrosoft.com;User2@onmicrosoft.com;User3@onmicrosoft.com; etc).

We need to populate the People picker field in SP list 2 with above users when user opens the Power App form.

Any idea on this. Thank-you

Categories:

Building Power Apps

All responses (4)

Answers (1)

Sort by

moritz0815 201 on at

Like
a
(0)

Report
Copy link

Link copied!

There you can find a great blog post, where you can see how your can patch data to complex columns in SP lists. There is also an example for the person column.
https://rezadorrani.com/index.php/2020/05/04/power-apps-patch-function-with-sharepoint/
BenWip 55 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @moritz0815 , Thank-you for the reply. Can you please explain how to loop through the comma separated values as mentioned above and populate it in People picker field.

Thank-you in advance.
moritz0815 201 on at

Like
a
(0)

Report
Copy link

Link copied!

You could do the following:
1. Load the semicolon separated values into a collection.
2. Use ForAll in combination with Patch to patch each of the unique values into the Person column.
Verified answer

moritz0815 201 on at

Like
a
(1)

Report
Copy link

Link copied!
You could do the following:
First Add Office365 User Connector
Then you make a collection from your string.

ForAll(Split(varString;";");Collect(colUsers;{User: Value}))

Then you create a second collection in which the data for the person picker column is kept.

ForAll(colUsers;Collect(colPatch;{ Claims: "i:0#.f|membership|" & User ; Department: ""; DisplayName: 'Office365-Benutzer'.UserProfile(User).DisplayName; Email: User; JobTitle: ""; Picture: "" }))

Rename 'Office365-Benutzer' what is the German name of the Office365 User Connector.
Finally, you patch the collection you just created.

Patch(YOUR LIST;THE RECORD YOU WANT TO PATCH;{'Person Column Name': colPatch})

Please note that I used German syntax. So you have to replaced ; with ,.

If that doesn't help, it would also be possible to create a PowerAutomate flow that is triggered when the app is opened. This should then fill out the Person Picker Column appropriately.