Assign person in PowerApps to appear in SharePoint list

(1) Share

Report

Posted on by PolaCB

Hello.

I have a form in PowerApps where I want to assign a person from a list.

In the dropdown items, I added names of the people. In SharePoint, I created a column of type Person or Group, and I want the selected person from the app to appear in this SharePoint list.

This is connected with a flow, so it needs to be set up as a Person for Power Automate to read it as an email.

I am not sure why it stopped working. Previously, it was functioning correctly, but now, when I select a person in the app, the column in SharePoint remains empty.

Thanks for help!!

Categories:

Building Power Apps

I have the same question (0)

All responses (8)

Answers (2)

ANB 7,223 Super User 2025 Season 2 on at

Like (1)

Report

HI @PolaCB , Please share more on the code side with some screenshot. When you say added names of people does that means you have hard code in items property of dropdown?

Thanks,
ANB

Was this reply helpful? Yes No
PolaCB 68 on at

Like (1)

Report

Hi. No I just have a table

Was this reply helpful? Yes No
ANB 7,223 Super User 2025 Season 2 on at

Like (1)

Report

@PolaCB This is just have the name, which is hardcoded. I dont see emails. And what about flow? Please share complete information. We cannot see your screen so you have to give all the details.

Thanks,

ANB

Was this reply helpful? Yes No
ivan_apps 2,187 Moderator on at

Like (0)

Report

Formula:: fxUserProfile = Office365Users.MyProfileV2();

you can use fxUserProfile if you wish, the bare minimum you need to put to SharePoint people columns is the following:
{
Claims: $"i:0#.f|membership|{fxUserProfile.userPrincipalName}",
DisplayName: fxUserProfile.displayName,
Email: fxUserProfile.mail
}

What you have is not sufficient for SharePoint to determine who the person is based on unique criteria.

Was this reply helpful? Yes No
PolaCB 68 on at

Like (1)

Report

So, now I connected my Office365Users and I can see all users in dropdown list, and when I am selecting user from this list, it appears in SharePoint.
However, I want just few users to be on that list, not all. How I can restrict the list to only 5 ?
I tried in property Items to add Filter but didnt work.

Was this reply helpful? Yes No
Verified answer

ivan_apps 2,187 Moderator on at

Like (2)

Report

Your method of adding a table should work just fine with some modifications.

instead of creating a table with the objects being { Value: “display name” }
Make this be the object for each of your people and substitute the equivalent SharePoint profile data for them.

{
Claims: $"i:0#.f|membership|{fxUserProfile.userPrincipalName}",
DisplayName: fxUserProfile.displayName,
Email: fxUserProfile.mail
}

you can do a search based on email address too, using the Office365Users connector and it will return a similar object for you searched user.

Was this reply helpful? Yes No
PolaCB 68 on at

Like (2)

Report

Oh my gosh, it's working! Thank you so much!
I have another question. Do you know how it was connected? In the dropdown list, I saw all users. Was it reading them because the SharePoint column was set up as a "Person" field, or because I added a connection to PowerApp with Office 365 users?

Was this reply helpful? Yes No
Verified answer

ivan_apps 2,187 Moderator on at

Like (1)

Report

Yea the Person column is connected to Azure AD/Entra ID users so that’s why you would see all users on that column. Office365Users connector does the same link

Was this reply helpful? Yes No