cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
enswitzer
Helper II
Helper II

Table Build with Select - Display Name

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.

 

enswitzer_0-1614278164451.png

 

Error:

enswitzer_1-1614278356577.png

 

 

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

enswitzer_2-1614278711551.png

 

 

 

 

 

1 ACCEPTED SOLUTION

Accepted Solutions

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.

View solution in original post

4 REPLIES 4
DamoBird365
Community Champion
Community Champion

@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
Helper II
Helper II

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

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.

View solution in original post

enswitzer
Helper II
Helper II

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

Helpful resources

Announcements
MPA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

V3_PVA CAmpaign Carousel.png

Community Challenge - Giveaways!

Participate in the Power Virtual Agents Community Challenge

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

PowerPlatform 768x460.png

Microsoft Learn

Check out our new Discover Your Career Path blog post series and get all the details.

Top Solution Authors
Users online (2,312)