Skip to main content

Notifications

Power Apps - Building Power Apps
Answered

Assign person in PowerApps to appear in SharePoint list

(1) ShareShare
ReportReport
Posted on by 68

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

  • Verified answer
    ivan_apps Profile Picture
    ivan_apps 2,187 on at
    Re: Assign person in PowerApps to appear in SharePoint list

    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

  • PolaCB Profile Picture
    PolaCB 68 on at
    Re: Assign person in PowerApps to appear in SharePoint list

    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?

  • Verified answer
    ivan_apps Profile Picture
    ivan_apps 2,187 on at
    Re: Assign person in PowerApps to appear in SharePoint list

    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 Profile Picture
    PolaCB 68 on at
    Re: Assign person in PowerApps to appear in SharePoint list

    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. 

    PolaCB_0-1720907115393.png

     

  • ivan_apps Profile Picture
    ivan_apps 2,187 on at
    Re: Assign person in PowerApps to appear in SharePoint list
     
    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.
  • ANB Profile Picture
    ANB 7,060 on at
    Re: Assign person in PowerApps to appear in SharePoint list

    @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

  • PolaCB Profile Picture
    PolaCB 68 on at
    Re: Assign person in PowerApps to appear in SharePoint list

    Hi. No  I just have a table 

    PolaCB_0-1720793415901.png

     

     

  • ANB Profile Picture
    ANB 7,060 on at
    Re: Assign person in PowerApps to appear in SharePoint list

    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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,495

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,822

Leaderboard