web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps How to filter string s...

Power Apps

Unanswered

How to filter string seperated by comma with multiselect combobox value

(0) Share

Report

Report

Posted on by Community Power Pla... Microsoft Employee

Hi all,

I have gallery which I am filtering based on multiple dates and combobox values.

One of the column I need to filter is Servicr Type which has comma seperated values. I have to get the record if any of the values in Service Type is equal to any of the selected item in combobox.

Service Type column used have only single value before so I added filter condition like this:

Service Type in ForAll(combobox. SelectedItems, Name)

How can I modify this expression when I have multiple value with comma seperated in Service Type column.

Thank you.

Categories:

Building Power Apps

All responses Img

All responses (2)

Answers Img

Answers (0)

Sort by

cdwhite 1,069 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Anonymous ,

I've tried replicating my side, here are my steps.

I have a combo box called 'cmbItems', I've selected 4 random items:

I've a gallery listing out all items:

I've updated the Items property of the gallery with the following formula, which joins the Combo Box selections together to then use as the basis:

Filter( colItems, Value in Concat( cmbItems.SelectedItems, Value1 & "," ) )

The result:

Not sure if that's exactly what you're after, do let me know 😊
------------------------------------------------------------------------------------------------------------------------------
If I've answered your question, please mark your post as Solved. You can accept more than one post as a solution.

If my response was a good one, please give it a Thumbs Up!

Visit my blog: https://platformsofpower.net
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @cdwhite . Thank you for the reply.

What do you have in "Value" variable in your filter?
I don't think this is what I am trying to do.

Let me explain my scenario.

I have gallery with multiple columns in a tabular format. And my column Service Type has values like below.
Date Service Type Last Name
20/10/2023 Item1, Item4, Item6 Name
20/10/2023 Item2 Name
20/10/2023 Item3, Item5, Item7 Name

And My Combobox is connected to one of the tables in Dataverse, and the value selected will be like below:

My Combobox
Item4 Item2

Expected Result:
Date Service Type Last Name
20/10/2023 Item1, Item4, Item6 Name
20/10/2023 Item2 Name

To give you more context, I have 3 tables.

Table: JOIN
Service ID Request ID
Service 1 Request 1
Service 2 Request 1
Service 3 Request 2
Service 2 Request 2
Service 5 Request 3

Table: Service
Service ID Service Name
Service 1 Item 1
Service 2 Item 2
Service 3 Item 3
Service 2 Item 4
Service 5 Item 5

Table: Request
Request ID Name
Request 1 1
Request 2 2
Request 3 3

I am using Join table as the source to my Gallery. I am grouping the records with same request Id in the Join table and concatenating the values present in Service Id.Service Name with comma separation. So, the Service Type is a column I added using AddColumns which concats the Service Name from Service table for the same Request ID. I followed this thread Solved: Combine multiple rows into a single row based on a... - Power Platform Community (microsoft.com) to achieve this.

Now I want to know how to filter this column with the combo box selected values.

Thank you.

Join the conversation