cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Skilled Sharer
Skilled Sharer

Lookup field Display in Gallery -Error

Hi, I have a lookup field which is having mulitple selection, I want to display in galley, but it returns error. I`ve tried to seacrh but not able to find solution. Does anybody have an idea how to do that.

 

lookupfielderror.png

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Super User
Super User

Re: Lookup field Display in Gallery -Error

The field in the gallery card is expecting text and the lookup field is returning a table since it allow multiple values to be selected. You add a field to the gallery card like list box or another gallery to display the table results or you can create a string from the values in the table and display in the gallery field.

 

Here is an example of how to convert the select values into a string that can be displayed in a text field or label.

 

Concat(ThisItem.AllSubTeams , Value & ";")



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

View solution in original post

2 REPLIES 2
Highlighted
Super User
Super User

Re: Lookup field Display in Gallery -Error

The field in the gallery card is expecting text and the lookup field is returning a table since it allow multiple values to be selected. You add a field to the gallery card like list box or another gallery to display the table results or you can create a string from the values in the table and display in the gallery field.

 

Here is an example of how to convert the select values into a string that can be displayed in a text field or label.

 

Concat(ThisItem.AllSubTeams , Value & ";")



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

View solution in original post

Highlighted
Skilled Sharer
Skilled Sharer

Re: Lookup field Display in Gallery -Error

Thank you very much @Jeff_Thorpe

Helpful resources

Announcements
secondImage

Demo-Extravaganza 2020

Check out these cool Power Apps & vote on your favorite!

secondImage

Robotic Process Automation

Let's talk about the solution provided by Microsoft for Robotic Process Automation (RPA)

secondImage

Community Highlights

Check out whats happening in Power Apps

secondImage

Community User Group Member Badges

FIll out a quick form to claim your community user group member badge today!

Top Solution Authors
Top Kudoed Authors
Users online (7,286)