cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
bbsin
Post Prodigy
Post Prodigy

person field in SP not showing in label in Gallery

Hi

 

I put a label in gallery and want to display the SP list - multi Person field but its not showing the data?  Please advise thanks.

 

label in Gallery

 

1.PNG

 

SP list

 

1.PNG

1 ACCEPTED SOLUTION

Accepted Solutions
RezaDorrani
Dual Super User
Dual Super User

Hi @bbsin ,

 

Multi person will return a Table

If you need the first value then use First(ThisItem.ActionAssignTo).DisplayName

 

If you need full list use the Concat function

Concat(ThisItem.ActionAssignTo,DisplayName,",")

 

--------------------------------------------------------------------------------
If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.

Thanks,
Reza Dorrani, MVP
YouTube
Twitter

 

--------------------------------------------------------------------------------
If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.

Thanks,
Reza Dorrani, MVP
YouTube
Twitter

View solution in original post

4 REPLIES 4
RezaDorrani
Dual Super User
Dual Super User

Hi @bbsin ,

 

Multi person will return a Table

If you need the first value then use First(ThisItem.ActionAssignTo).DisplayName

 

If you need full list use the Concat function

Concat(ThisItem.ActionAssignTo,DisplayName,",")

 

--------------------------------------------------------------------------------
If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.

Thanks,
Reza Dorrani, MVP
YouTube
Twitter

 

--------------------------------------------------------------------------------
If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.

Thanks,
Reza Dorrani, MVP
YouTube
Twitter

Hi Reza

 

Great to hear from you.  I was watching your youtube tutorial.

 

Thank you for your advise.

 

Cheers 🙂

Thank You for following my channel.

 

--------------------------------------------------------------------------------
If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.

Thanks,
Reza Dorrani, MVP
YouTube
Twitter

Hello Reza - 

 

Using this function worked perfectly, Concat(ThisItem.ActionAssignTo,DisplayName,",") however, what if we want to display another property other than the DisplayName?  I have tried using GivenName, and the formula breaks.

Helpful resources

Announcements
Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (4,731)