Update Multi Person Field in a Form | Get E-Mail from Default Selected Persons

(0) Share

Report

Posted on by alexaso

Hi Community,

I'm stuck on a problem and I'm sure you have an idea.

I have a person multiple selection field in SharePoint, which can be stored via the Power Apps form via UserSearchV2. Everything is saved correctly here.

However, if you open the app again on the SharePoint element, the default SelectedItems does not contain any e-mail information that I could pass to the update property.

{DisplayName:"";Claims:DataCardValue4.Selected.Mail;Department:"";Email:"";JobTitle:"";Picture:""}

Do you have a simple idea how I can get the email information?

Or do I have to create a collection with ForAll + UserSearch based on the user names?

Greetings,

Alex

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

AldenKnibbs 107 on at

Like (0)

Report
Copy link

Link copied!
One approach to get the email information is indeed to create a collection that includes the necessary user details. Here's a simplified version of how you could achieve this using the ForAll function along with Office365Users.SearchUser() to get the user details:
First, make sure you have added the Office 365 Users connection to your app.
Use the OnVisible property of the screen or the OnStart property of the app to populate a collection with user details. You can use something like this:
ClearCollect( ColUserDetails, ForAll( YourPersonField.SelectedItems, { DisplayName: DisplayName, Email: Office365Users.UserProfileV2(UserPrincipalName).mail, Department: Department, JobTitle: JobTitle, Picture: Picture } ) )
Replace YourPersonField with the actual name of your person multiple selection field.
Bind the Items property of the people picker to ColUserDetails to use it as the default selection:
Items = ColUserDetails
Please note that this approach may be subject to delegation warnings if you have a large number of items due to the way the ForAll and Office365Users.UserProfileV2() functions work. It's also making a call for each user to the Office 365 Users profile, which could be slow if you have many users.

Was this reply helpful? Yes No
alexaso 39 on at

Like (0)

Report
Copy link

Link copied!

I want still use the people picker in the office search. So my Item-Bind still

Office365Users.SearchUser({searchTerm:DataCardValue4.SearchText;top:5})

Unfortunately I do not get a UserPricipalName from the default values

ClearCollect( ColUserDetails, ForAll( YourPersonField.SelectedItems, { DisplayName: DisplayName, Email: Office365Users.UserProfileV2(UserPrincipalName).mail, Department: Department, JobTitle: JobTitle, Picture: Picture } ) )

See DatacardValue4.SelectedItems, in the People Picket I choose a random employee and get the information.

Was this reply helpful? Yes No
alexaso 39 on at

Like (0)

Report
Copy link

Link copied!

With following Code on the Save Button it worked:

ClearCollect(
ColTeilnehmer;
ForAll(
DataCardValue4.SelectedItems;
{
DisplayName: DisplayName;
Claims: First(Office365Users.SearchUser({searchTerm:DisplayName})).Mail;
Department: "";
Email: "";
JobTitle: "";
Picture: ""
}
)
);;

Its based on DisplayName. So there is a small chance that the wrong user will be drawn for double names.

Was this reply helpful? Yes No