Table Build with Select - Display Name

[enswitzer]

I am trying to display only the display name of the Product Manager/Project Lead/Sponsor. If I use what comes out of the table, I get the FULL odata claims information. I seem to be having success using

Item().ProjectLead.DisplayName

but when I do the same for executive sponsor - it errors out on me.

Error:

I think this is the section of the output that I would need to pull from if that helps:

[DamoBird365]

@enswitzer 

I think you are just missing the ?'s.

item()?['ExecutiveSponsor']?['DisplayName']

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Cheers,
Damien

P.S. take a look at my new blog here

[enswitzer]

😞 DIdn't work... same message  - display name cannot be selected...

I wonder if it is because both of those fields allow for multiple inputs and project lead does not

Still not sure how to solve it - but that's all I can come up with.

[DamoBird365 · Accepted solution]

In which case you need an apply to each to retrieve each element or you can call the first item using something like

item()?['ExecutiveSponsor']?[0]?['DisplayName'] - depends on what you are trying to achieve.

[enswitzer]

Thank you SO MUCH! This will save me so much time and effort!