Skip to main content

Notifications

Power Apps - Building Power Apps
Answered

Creating a collection to get the display name from a People column - odd results

(0) ShareShare
ReportReport
Posted on by

Hi,

 

After some words of wisdom as can't see why this isn't working.  I have a very simple SharePoint list with two columns "Employee" and "Days".  The "Employee" column is a People column and the "Days" column is a number.

 

pa-1.png

 

What I am trying to do is grab the display name from the People coloum and create a new column within the collection with this data. 

 

pa-3.png

 

However when I look at the collection it hasn't created the columns and looks like this

 

pa-2.png

 

I am not sure what's going wrong here, any ideas gratefully received.

 

Thanks

Rob

 

 

  • Rob_CTL Profile Picture
    Rob_CTL on at
    Re: Creating a collection to get the display name from a People column - odd results

    Thanks @WarrenBelz

  • Verified answer
    WarrenBelz Profile Picture
    WarrenBelz 145,343 on at
    Re: Creating a collection to get the display name from a People column - odd results

    Hi @Rob_CTL ,

    You don't need the lat two references unless you want ShowColumns to restrict the collection like the below

    ClearCollect(colHoliday, 
     ShowColumns(
     AddColumns(
     Holidays, 
     "EmployeeName", 
     Employee.DisplayName
     ),
     "EmployeeName", 
     "Days",
     "Holidays"
     )
    )

     

    Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

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,343

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,703

Leaderboard