cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper II
Helper 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
Highlighted
Super User II
Super User II

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

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
Highlighted
Super User II
Super User II

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

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

Highlighted
Helper II
Helper II

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

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

Highlighted
Super User II
Super User II

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

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

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

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. 

Highlighted
Helper II
Helper II

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

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
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Watch Now

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 designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (5,032)