Assign person in PowerApps to appear in SharePoint list

[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!! 

[ANB]

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

[PolaCB]

Hi. No  I just have a table 

[ANB]

@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

[ivan_apps]

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.

[PolaCB]

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. 

[ivan_apps · Accepted solution]

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.

[PolaCB]

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?

[ivan_apps · Accepted solution]

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