web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / SharePoint columns of ...
Power Apps
Answered

SharePoint columns of 'person or group' not showing up in my PowerApp

(0) ShareShare
ReportReport
Posted on by 257

Hi everyone, 

 

I've been banging my head against my desk for a while with this. 

 

My SharePoint list has two columns (Primary/Secondary Resource Assigned) with 'person or group' as the data type but neither one of these shows up in my PowerApp (see screenshots below) when I want to add these Data fields. I can see the 'Modified by' column which is also a 'person or group' type but not the ones I need. 

 

I see a similar post that says this was fixed but it's not working for me.  What's more puzzling is that when I created a new SharePoint list with a column with 'person or group' type and add an item, I do see this field on a test canvas. 

 

Can someone provide some guidance as to why these complex data fields don't show in PowerApps? 

 

In advance, your help is much appreciated!

 

 

 

SP_Person_or_group.jpg
Categories:
I have the same question (0)
  • JayMagness Profile Picture
    1,663 on at

    Hi,

     

    Lets get on a teams session and see if I can help you.

     

    Send a note to me jay@research-nest.com and I will send a teams pointer

     

    jay

  • Verified answer
    v-yutliu-msft Profile Picture
    Microsoft Employee on at

    Hi @F_Quint ,

    Do you want to display person field in powerapps?

    Could you tell me

    1)whether this person field allows multiple value?

    2)where do you want to display person field? A label?

     

    Firstly, let me explain where's your problem:

    1)please notice the structure of person field:
    not allow multiple value:    //a record

    { Department:"",
     DisplayName:"....",
     Email:".....",
     JobTitle:"",
     Picture:""
     }

    allow multiple value:    //a table

    Table({ Department:"",
     DisplayName:"....",
     Email:".....",
     JobTitle:"",
     Picture:""
     }
    )

     2)you need to set a label's Text to a text value, not record or table value.

    If you want to display it in data table, it only display simple data type by default. You need to use AddColumns function to add a column with the displayname value of the person field which is text type.

     

    Back to your issue, I list some possibilities for your reference:

    1)if the person field not allow multiple value and display in  a label

    You should set the label's Text:

    ThisItem.personfield.DisplayName

    2)if the person field allow multiple value and display in  a label

    You should set the label's Text:

     

    Concat((ThisItem.personfield),DisplayName&" ")

     

     

     

    3)if the person field not allow multiple value and display in  a data table

    You should set the data table's Items:

    AddColumns(table,"personvalue",personfield.DisplayName)

    4)if the person field allow multiple value and display in  a data table

    You should set the data table's Items:

     

    AddColumns(table,"personvalue",Concat(personfield,DisplayName&" "))

     

     

    Best regards,

     

     

  • m_anees Profile Picture
    3 on at

    Super reply 

    Thanks 

  • ClipperSun Profile Picture
    90 on at

    Thank you very much. Your explanation has been of great help. Have a great day.

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 401 Most Valuable Professional

#2
11manish Profile Picture

11manish 201 Super User 2026 Season 2

#3
MS.Ragavendar Profile Picture

MS.Ragavendar 128 Super User 2026 Season 2

Last 30 days Overall leaderboard