Answered

Table problems

(0) Share

Report

Posted on by russrimm1

Hi all,

I have a collection called "intuneapps" that has a column called "Category" which has a table in each row called "displayName".

I've created a collection named "cats" of all the distinct displayNames using ForAll(intuneapps,Collect(cats,Distinct(Category,displayName).Result))

So "cats" is a collection with a single column "Result" with each unique displayName.

Now, I want my combobox showing the distinct displayNames to filter my gallery showing "intuneapps" based on the apps that have the selected displayName in their "Category" column's "displayName" table.

Something like "Filter(intuneapps,Category.displayName in ComboBox5.SelectedItems.Result).displayName" but that doesn't work because Category.displayName is a table. So I think I need a many to many comparison of some sort but struggling to figure it out.

Categories:

Building Power Apps

All responses (2)

Answers (1)

Sort by

PowerRanger 3,458 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@russrimm1 Hey. I guess the table "displayName" always has only one row, right?

I haven't tried it myself, but you could try something like this

"Filter(intuneapps,First(Category.displayName).displayName in ComboBox5.SelectedItems.Result).displayName"

If this is not what you are looking for please show me an example of your collection.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.
Verified answer

WarrenBelz 156,720 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @russrimm1 ,

Your problem is that you have a many-to-many relationship there and need another collection

ForAll( ComboBox5.SelectedItems, Collect( colNames, Filter( intuneapps, Result in Category.displayName ).displayname ) )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps