Unanswered

Passing a list into a people picker control

(1) Share

Report

Posted on by LeonMc76

Hello, I am using a people picker control which I would like to populate with existing email addresses taken from a text control on a form. I can pass one email address to the control and when invoked it will automatically display. Now I am trying to pass more than one address from a collection to the control and cannot seem to get the syntax correct. Am I barking up the right tree here?

Collect( PeopleSelected, Split( dcRequestorMail.Text, "; " ) ); ForAll( PeopleSelected, With( SearchPeople, LookUp( Office365Users.SearchUser({searchTerm: PeopleSelected, top: 100}), AccountEnabled = true ) ); If( Not(SearchPeople.UserPrincipalName in MyPeople.UserPrincipalName), Collect( MyPeople, SearchPeople ) ) )

My aim is to allow the user to amend or change the emails populated in the people picker and pass them back to the forms text control.

Categories:

Building Power Apps

I have the same question (0)

All responses (12)

Answers (0)

Sort by

KeithAtherton 3,709 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @LeonMc76,

The approach looks good. Part of the code has this:

{searchTerm: PeopleSelected, top: 100}

However, that's referring to the name of the collection but we may need a value - for example, something similar to the following:

{searchTerm: Email, top: 100}

Also, bear in mind that there is also a new version of the search function, named SearchUserV2().

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.
Follow me online.

Was this reply helpful? Yes No
LeonMc76 32 on at

Like
a
(1)

Report
Copy link

Link copied!
Hello Keith,
Thanks for replying. Substituting 'Value' for the collection name has sorted the syntax out in the code and it will run, however the picker control doesn't display anything. It's very frustrating. The V2 issue is next on my list. 😊

Clear(PeopleSelected); Collect( PeopleSelected, Split( dcRequestorMail.Text, "; " ) ); ForAll( PeopleSelected, With( SearchPeople, LookUp( Office365Users.SearchUser({searchTerm: Value, top: 100}), AccountEnabled=true) ); If( Not(SearchPeople.UserPrincipalName in MyPeople.UserPrincipalName), Collect( MyPeople, SearchPeople ) ) )

EDIT: Weird. This code will accept one email address e.g. abc123@hotmail.com, and the people picker will display the profile, however as soon as you include more email in the string with the delimiter e.g. abc123@hotmail.com; abc456@hotmail.com; abc789@hotmail.com it glitches out.

Was this reply helpful? Yes No
KeithAtherton 3,709 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!

My pleasure! Well done, that's a good step forward.

If you select MyPeople in the formula bar to view the data it holds, can you see records as expected?

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.
Follow me online.

Was this reply helpful? Yes No
LeonMc76 32 on at

Like
a
(1)

Report
Copy link

Link copied!

When there is one email address in the text box the code will pass it through, add it to the MyPeople collection and it does display the data in the formula bar, however when there is more than one email address with the delimiters it fails, doesn't pass anything through to the MyPeople collection and no data appears in the formula bar...? I'm baffled...

Was this reply helpful? Yes No
KeithAtherton 3,709 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!

Strange one. If you view the PeopleSelected collection, does that display records as expected?

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.
Follow me online.

Was this reply helpful? Yes No
LeonMc76 32 on at

Like
a
(1)

Report
Copy link

Link copied!

Indeed it is and yes it does. The Collect and Split is working fine and the PeopleSelected collection is displaying its data as it should. 🤔

Was this reply helpful? Yes No
KeithAtherton 3,709 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!
To isolate if the issue is when the user is searched for, try running the following code manually (say, in App.OnStart) but hard-code the "Value" field to some of the users and confirm that results are being returned to the gblDebug variable:

Set(gblDebug, Office365Users.SearchUser({searchTerm: "Value", top: 100}));

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.
Follow me online.

Was this reply helpful? Yes No
LeonMc76 32 on at

Like
a
(1)

Report
Copy link

Link copied!

Confirmed that data is being passed to the gblDebug variable.

~~I'll try more than one address, hang fire.~~ No I won't because it won't work.

Was this reply helpful? Yes No
KeithAtherton 3,709 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!

Great, that's confirmed then. For next steps, I suggest building up that manual "debug" code towards the full people picker control code step-by-step to see where the results show unexpectedly.

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.
Follow me online.

Was this reply helpful? Yes No
LeonMc76 32 on at

Like
a
(1)

Report
Copy link

Link copied!

OK, will endeavour to get that done.
Thanks Keith, appreciate your time.
Will keep the thread updated with the process.

Was this reply helpful? Yes No