cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
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
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
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.
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
New Badges

New Solution Badges!

Check out our new profile badges recognizing authored solutions!

New Power Super Users

Congratulations!

We are excited to announce the Power Apps Super Users!

Power Apps Community Call

Power Apps Community Call: February

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

Microsoft Ignite

Microsoft Ignite

Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!

Top Solution Authors
Top Kudoed Authors
Users online (20,406)