cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
LuisGuzman98
Advocate II
Advocate II

This Item. Combo Box values doesn't work, what's is the right way?

Hi, 

 

I Have this gallery where I select items from a  sharepoint list and the values of each column are then showed of on another gallery. 

 

Everything is working ok with all the columns, but I have one value which comes from a combo box, which means multiple values are stored on that column. 

 

Actually using the formula: 

 

 

ThisItem.'Additional Resources'.Value

 

 

Which works with the other values... How could I display all the values present in this field?

 

image.png

 

Thanks 

1 ACCEPTED SOLUTION

Accepted Solutions
Jeff_Thorpe
Super User
Super User

If you are displaying the combo box values in a text field then you need to convert it to a string like the example below or you could change you display field to list box or gallery which can display a record table.

 

Example: Concat(ThisItem.'Additional Resources', 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

5 REPLIES 5
Jeff_Thorpe
Super User
Super User

If you are displaying the combo box values in a text field then you need to convert it to a string like the example below or you could change you display field to list box or gallery which can display a record table.

 

Example: Concat(ThisItem.'Additional Resources', 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

Hey @Jeff_Thorpe , 

 

Just tried what you suggested but not quite sure if I did it right. 

 

Obviously it's not this way but that's sort of what I understand:

 

Concat(ThisItem.'Additional Resources',ThisItem.'Additional Resources'.Value, ";")

 

I did this in flow, I have to create a loop for gathering all the values that are contained in the field into one string. I need to get this done into power apps. 

 

Thanks

What happen when you tried my example without any changes to it (assuming I had the field names correct)?



--------------------------------------------------------------------------------
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.
rebeccas
Super User
Super User

What is making the values show in the second gallery...are you creating a collection?

 

If the second gallery has the same data source (not a collection) then you can just select the item in the first gallery and then filter for it in the second gallery without having to carry over any values manually. 

Hi @rebeccas

 

No I'm not using any collection. 

 

I'm using two gallerys and calling each item manually. But actually the method of @Jeff_Thorpe is correct and it worked fine for my purpose, I was just doing it incorrectly when I tried. 

 

The concat funtion expects a table, a value and a separator. I was confused because I didn't realize that the value I was calling was actually a table data type. 

 

I call it on the gallery just like you said @Jeff_Thorpe  and it works perfectly. 

 

image.png

 

 Thanks you both!

Helpful resources

Announcements
PA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

Power Apps Community Call

Monthly Power Apps Community Call

Did you miss the call?? Check out the Power Apps Community Call here!

secondImage

Experience what’s next for Power Apps

See the latest Power Apps innovations, updates, and demos from the Microsoft Business Applications Launch Event.

Power Platform ISV STudio

Power Platform ISV Studio

ISV Studio is the go-to Power Platform destination for ISV’s to monitor & manage applications post-AppSource publish.

Top Solution Authors
Top Kudoed Authors
Users online (48,888)