Answered

filtering a gallery with mulitple dropdowns (cascade)

(0) Share

Report

Posted on by Community Power Pla...

i want to filter a gallery based on three dropdowns.

1.The first dropdown is month as a text.

2.The second dropdown are projectnames but they are not in the same table like the others, because the projectname come from external table called Projects. But every description in the collection has a description which is based on a Projectname.

3.The third are the descriptions of the projects ?

ort(
 If(IsBlank(Dropdown3.Selected.DateMonthYear) && IsBlank(Dropdown4.Selected.Arbeitspaket); 
 Filter(colF; Mitarbeiter = User().Email); 
 If(IsBlank(Dropdown3.Selected.DateMonthYear);
 Filter(colF;Mitarbeiter = User().Email && Arbeitspaket = Dropdown4.Selected.Arbeitspaket);Filter(colF; Mitarbeiter = User().Email && Monat = Dropdown3.Selected.DateMonthYear)
 )
 ); 
 "Monat"; 
 SortOrder.Descending
)

hope someone can help me 😞

Categories:

Building Power Apps

I have the same question (0)

All responses (7)

Answers (1)

AndrewR1 1,572 Moderator on at

Like (0)

Report
Hi @Anonymous can you try structuring the code like so:
Sort( If( IsBlank(Dropdown3.Selected.DateMonthYear) && IsBlank(Dropdown4.Selected.Arbeitspaket); Filter( colF; Mitarbeiter = User().Email ); If( IsBlank(Dropdown3.Selected.DateMonthYear); Filter( colF; Mitarbeiter = User().Email ; Arbeitspaket = Dropdown4.Selected.Arbeitspaket ); Filter( colF; Mitarbeiter = User().Email; Monat = Dropdown3.Selected.DateMonthYear ) ) ); "Monat"; SortOrder.Descending )

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. Remember, you can accept more than one post as a solution.

If the content was useful in other ways, please consider giving it Thumbs Up.

Thanks
Andrew

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

there is no bug but it do not work !
The gallery is not filtered based on these both columns !

Was this reply helpful? Yes No
AndrewR1 1,572 Moderator on at

Like (0)

Report
Hi @Anonymous if you wish to have them both filter when they are not blank we needed to add the other filter to the else part of the last IF my apologies:
Sort( If( IsBlank(Dropdown3.Selected.DateMonthYear) && IsBlank(Dropdown4.Selected.Arbeitspaket); Filter( colF; Mitarbeiter = User().Email ); If( IsBlank(Dropdown3.Selected.DateMonthYear); Filter( colF; Mitarbeiter = User().Email ; Arbeitspaket = Dropdown4.Selected.Arbeitspaket ); Filter( colF; Mitarbeiter = User().Email; Monat = Dropdown3.Selected.DateMonthYear, Arbeitspaket = Dropdown4.Selected.Arbeitspaket ) ) ); "Monat"; SortOrder.Descending )

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. Remember, you can accept more than one post as a solution.

If the content was useful in other ways, please consider giving it Thumbs Up.

Thanks
Andrew

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

the problem is now that it does not filter the date alone anymore!

Was this reply helpful? Yes No
AndrewR1 1,572 Moderator on at

Like (0)

Report
Hi @Anonymous
Sort( If( IsBlank(Dropdown3.Selected.DateMonthYear) && IsBlank(Dropdown4.Selected.Arbeitspaket); Filter( colF; Mitarbeiter = User().Email ); If( IsBlank(Dropdown3.Selected.DateMonthYear); Filter( colF; Mitarbeiter = User().Email ; Arbeitspaket = Dropdown4.Selected.Arbeitspaket ); If( IsBlank(Dropdown4.Selected.Arbeitspaket); Filter( colF; Mitarbeiter = User().Email ; Monat = Dropdown3.Selected.DateMonthYear ); Filter( colF; Mitarbeiter = User().Email; Monat = Dropdown3.Selected.DateMonthYear; Arbeitspaket = Dropdown4.Selected.Arbeitspaket ) ) ) ); "Monat"; SortOrder.Descending )

You would just add another if to check if each of them are blank and then the final if neither of them are blank then filter by both
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. Remember, you can accept more than one post as a solution.

If the content was useful in other ways, please consider giving it Thumbs Up.

Thanks
Andrew

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

thx but why the gallery is not filtered based on the date ?
the date there is a text type

Was this reply helpful? Yes No
Verified answer

AndrewR1 1,572 Moderator on at

Like (0)

Report
Hi @Anonymous I don't know for sure as you haven't shared with me any of the data for the:
Dropdown3.Selected.DateMonthYear
But I would say you need to make sure the format of the text is correct for both the Monat field which I can see is yyyy/MM:
so your dropdown would also need to have the month in numeric and the year to be able to have a successful match.
You could also try adding in the Not operator to make sure that each field is running the correct if:
Sort( If( IsBlank(Dropdown3.Selected.DateMonthYear) && IsBlank(Dropdown4.Selected.Arbeitspaket); Filter( colF; Mitarbeiter = User().Email ); If( IsBlank(Dropdown3.Selected.DateMonthYear)&&!IsBlank(Dropdown4.Selected.Arbeitspaket); Filter( colF; Mitarbeiter = User().Email ; Arbeitspaket = Dropdown4.Selected.Arbeitspaket ); If( IsBlank(Dropdown4.Selected.Arbeitspaket)&&!IsBlank(Dropdown3.Selected.DateMonthYear); Filter( colF; Mitarbeiter = User().Email ; Monat = Dropdown3.Selected.DateMonthYear ); Filter( colF; Mitarbeiter = User().Email; Monat = Dropdown3.Selected.DateMonthYear; Arbeitspaket = Dropdown4.Selected.Arbeitspaket ) ) ) ); "Monat"; SortOrder.Descending )

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. Remember, you can accept more than one post as a solution.

If the content was useful in other ways, please consider giving it Thumbs Up.

Thanks
Andrew

Was this reply helpful? Yes No