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

(0) Share

Report

Posted on by Rob_CTL

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.

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.

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

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

Thanks

Rob

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

WarrenBelz 153,026 Most Valuable Professional on at

Like (1)

Report
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.

Was this reply helpful? Yes No
Rob_CTL on at

Like (0)

Report

Thanks @WarrenBelz

Was this reply helpful? Yes No