Gallerz filter based on multiple Dataverse entities

(0) Share

Report

Posted on by Oliver89

Hi All,

I'm having some troubles with sorting out a powerapp concept.

Use Case:

One Canvas App built on Dataverse Tables. Basically I'm having people (contacts) with various subgrids (connected entities/Tables).

The attached screen shows what is the result that i would like to achieve in the Canvas App:

In the bottom part there is a gallery, which if i don't select anything i would like to see a list of all people.

Meanwhile is is select 1-1 parameter let's say one education and 2 languages, i would like to see in the gallery Only the ones who fit both of the parameters.

Preferably i would like to achieve this step by step filtering on each drop down interaction, hence, if i have 3 filters and 20 people i want to see the 20 people, and if i add 1 more filter and all of them disappears basically i'll know that that last parameter is the one which isn't available for any of them. (the buttons below the dropdowns are there only for testing/dev purposes)

From the gallery list as a next stepp I'll select one person and go to another screen.

I hope it wasn't too messy 🙂 🙂 🙂

Every Idea is more than welcome (I'm starting to lose my remaining hair on this 😄 )
Thx in advance,

Oliver

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (0)

Sort by

HenriDesmet59 295 on at

Like (0)

Report
Copy link

Link copied!
Hello @Oliver89 ,

So you want to filter a Datasource with all the dropdown you showed in the screen ?

In order to do that, you can write your filter like this :

Filter( DataSource; IsBlank(FirstCombo.SelectedItems.Value) || IsEmpty(FirstCombo.SelectedItems) || FirstCombo.Selected.Value in FirstColumn.Value; IsBlank(SecondCombo.SelectedItems.Value) || IsEmpty(SecondCombo.SelectedItems) || SecondCombo.Selected.Value in SecondColumn.Value; IsBlank(ThirdCombo.SelectedItems.Value) || IsEmpty(ThirdCombo.SelectedItems) || ThirdCombo.Selected.Value in ThirdColumn.Value; ...... )

For each combobox, you check if It's blank or empty. If not, then you check if the column of the item contain the selecteds values of the combobox.

Tell me if I understand your needs !
And sorry I'm French, so my english can be messy too, and if you use my code replace the ";" by ",".

Was this reply helpful? Yes No
Oliver89 20 on at

Like (0)

Report
Copy link

Link copied!

Hello Henri,

Unfortunately this is not working 😕 I'm trying now a PowerBI report build, which afterwards I'll embed in the powerapps or i'll have some kind of deeplinking.

Thx though

Was this reply helpful? Yes No