Don't get "DisplayName" from my people column of my sharepoint list displayed in HTML table

(0) Share

Report

Posted on by MaxF

Hallo,

my problem is that I don't get the "DisplayName" from my people column of my sharepoint list displayed in a HTML table.

I create my tables like this. First 'Get items' -> 'Select'-> 'Create HTML table'

I already tried this in the select operatin for the HTML column "worker":

item()?['PeopleColumn']?['DisplayName'] (It didn't work but I have seen it has worked for certain people)

In addition, I do not get displayed in the dynamic content, the "PeopleColumn DisplayName", which I have now also seen several times

I also tried diffrent Expression to filter the "DisplayName" but without success.

I know I can extract it with a 'Parse Jason' operation but if I add the people column as content it automatically creates me an 'Apply to each'. So I can't use the extracted "DisplayName" in my 'Select' operation. This must not end in an 'Apply to each' because I am merging several HTML tables to create a PDF.

If somone has a solution I would be very happy, thanks.

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (0)

Ellis Karim 11,691 Super User 2025 Season 2 on at

Like (1)

Report

The DisplayName of your Person field should be available as dynamic content. In my demo list below, Owner is a Person only type column:
In the Select action I map Owner to the Owner DisplayName using dynamic content:
And here is the output of the flow, which uses the Create HTML table action. The table showing the Display Name:
Ellis

Was this reply helpful? Yes No
MaxF 22 on at

Like (0)

Report

Hallo Ellis,
thank you for your answer
I think the problem is that allow multiple selection is on yes. Because when I changed it to no, it worked.
But I need that multiple selection for Power Apps. Or is there another way to select multiple people in powerapps and then store them as individual items in the sharepoint list?

Max

Was this reply helpful? Yes No
Ellis Karim 11,691 Super User 2025 Season 2 on at

Like (1)

Report
I'm not clear on the question, but seems to be at least two options:
(1) Update the multi-person SharePoint column from within Power Apps
PATCH A SharePoint Person Column With Multiple People In Power Apps - Matthew Devaney

(2) Extract the Display Names from the multi-person SharePoint column into an array or string variable. Then save to another SharePoint column or return the values back to Power Apps:
The Owner field is an array of JSON objects:

"Owner": [ { "@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser", "Claims": "i:0#.f|membership|alexw@MS365.com", "DisplayName": "Alex Wilber", "Email": "AlexW@MS365.com", "Department": "Marketing", "JobTitle": "Marketing Assistant" }, { "@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser", "Claims": "i:0#.f|membership|meganb@MS365.com", "DisplayName": "Megan Bowen", "Email": "MeganB@meganb@MS365.com", "Department": "Marketing", "JobTitle": "Marketing Manager" }, { "@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser", "Claims": "i:0#.f|membership|meganb@MS365.com", "DisplayName": "Isaiah Langer", "Email": "meganb@MS365.comm", "Department": "Sales", "JobTitle": "Sales Rep" } ]

A flow to extract the Owner display names:
Ellis

Was this reply helpful? Yes No
Ellis Karim 11,691 Super User 2025 Season 2 on at

Like (0)

Report

See also this related post for selecting multiple people a SharePoint Person field using an array variable.
https://powerusers.microsoft.com/t5/Building-Flows/RE-Import-excel-to-SharePoint-list-create-item-Issue-with/m-p/1295680#M147352

Ellis

____________________________________
If I have answered your question, please mark the post as Solved.
If you like my response, please give it a Thumbs Up.

Was this reply helpful? Yes No