Filter Gallery1 based on Distinct Value Gallery2

(0) Share

Report

Posted on by barbossa_94

Hi all,

i have the following starting situation (all Dataverse tables):

Table 1: Person Table with Name and further fields

Table 2: Expertise table with Category (multiples) and Expertise fields

E.g.

Category | Expertise

Sofware | AutoCAD

Software | Maptek

Software | PowerApps

Other | Design

Other | FlowChart

Processing | Planning

Processing | Automation

The tables have a many to many relationship.

In the app i have a gallery1 displaying the person table and a gallery2 displaying the distinct values of the expertise table:

Distinct(Expertise,Category)

I want the gallery1 to show all names that have some expertise in this category when the user selects the category in gallery2.

e.g. user selects Software then i want all names to be shown, regardless if they have autocad or maptek expertise.

Would be great if someone has an idea on how to manage this. many to many relationships are tricky for me since its hard to address this virtual table that is inbetween them.

Thanks

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

Sort by

renatopc84_ch 228 on at

Like (0)

Report
Copy link

Link copied!

Hi @barbossa_94
You can do it with a modify on the Filter of the first gallery.
example: Filter(source, current conditions, gallery2.selected.namefield.text)

Was this reply helpful? Yes No
barbossa_94 51 on at

Like (0)

Report
Copy link

Link copied!

@renatopc84_ch
this is not really helpful. The distinct gallery has only "value" as a property. I assume it has to be something like a filter like Filter(PersonTable, Gallery2.Selected.Value in Name.Category) however I cant find the right solution.
Could you clarify your approach with the example I provided?

Was this reply helpful? Yes No
renatopc84_ch 228 on at

Like (0)

Report
Copy link

Link copied!

Hi @barbossa_94
I'm missing one point, how is stored on the person the "link" to the Category | Expertise?
I don't have experience with Dataverse, so maybe someone else will be able to help you.

Working with a Sharepoint List, I would create in the Table Person a Lookup Field connected to a Table where I have one additional column where Category and Expertise are one only value (example: "Sofware | AutoCAD" as Text).
Then you can store with patch function the title and value of the Lookup.

After that I would make all my analysis splitting the Text value for the separator that you are already using "|".

I hope this help, and maybe someone else come with a better solution 🙂

Was this reply helpful? Yes No