Answered

Filter Gallery by Gallery on Previous Screen and 2 Dropdown lists with 'ALL'

(0) Share

Report

Posted on by forengland

Hi all,

I'm trying to filter a gallery on a screen by another screen's gallery selection AND 2 dropdown lists with 'ALL' I can get one or the other working, but not both together. Not sure how to stitch together:

(1) Filter gallery by another gallery selection:

Filter(Risks, ProjectName.Value = gal_ProjectList.Selected.ProjectName)

(2) Filter gallery by multiple drop down boxes:

If(
//This is for all and all
ddRiskStatus.Selected.Result ="All" And ddRiskSeverity.Selected.Result = "All",
Risks,
//This is for all Status and selected Severity
ddRiskStatus.Selected.Result = "All" And ddRiskSeverity.Selected.Result <> "All",
Filter(Risks, RiskSeverity.Value = ddRiskSeverity.Selected.Result),
//This is for selected Status and All Severity
ddRiskStatus.Selected.Result <> "All" And ddRiskSeverity.Selected.Result = "All",
Filter(Risks, RiskStatus.Value=ddRiskStatus.Selected.Result),
//This is for selected Status and selected Severity
ddRiskStatus.Selected.Result <> "All" And ddRiskSeverity.Selected.Result <> "All",
Filter(Risks, RiskStatus.Value=ddRiskStatus.Selected.Result And RiskSeverity.Value = ddRiskSeverity.Selected.Result))

Categories:

Building Power Apps

All responses (2)

Answers (1)

Sort by

Verified answer

WarrenBelz 156,576 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @forengland ,
I am not sure I got this exactly correct, but I am sure you will get the idea of the syntax required.
If( ddRiskStatus.Selected.Result ="All" && ddRiskSeverity.Selected.Result = "All", Risks, ddRiskStatus.Selected.Result = "All" && ddRiskSeverity.Selected.Result <> "All", Filter( Risks, RiskSeverity.Value = ddRiskSeverity.Selected.Result && ProjectName.Value = gal_ProjectList.Selected.ProjectName ), ddRiskStatus.Selected.Result <> "All" && ddRiskSeverity.Selected.Result = "All", Filter( Risks, RiskStatus.Value=ddRiskStatus.Selected.Result && ProjectName.Value = gal_ProjectList.Selected.ProjectName ), ddRiskStatus.Selected.Result <> "All" && ddRiskSeverity.Selected.Result <> "All", Filter( Risks, RiskStatus.Value=ddRiskStatus.Selected.Result && RiskSeverity.Value = ddRiskSeverity.Selected.Result && ProjectName.Value = gal_ProjectList.Selected.ProjectName ) )

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.
forengland 11 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks WarrenBelz,

I've been fighting with this for days!! You were really close:

If(
ddRiskStatus.Selected.Result ="All" &&
ddRiskSeverity.Selected.Result = "All",
Filter(Risks,ProjectName.Value=gal_ProjectList.Selected.ProjectName),
ddRiskStatus.Selected.Result = "All" &&
ddRiskSeverity.Selected.Result <> "All",
Filter(Risks, RiskSeverity.Value = ddRiskSeverity.Selected.Result && ProjectName.Value = gal_ProjectList.Selected.ProjectName),

ddRiskStatus.Selected.Result <> "All" &&
ddRiskSeverity.Selected.Result = "All",
Filter(Risks, RiskStatus.Value=ddRiskStatus.Selected.Result && ProjectName.Value = gal_ProjectList.Selected.ProjectName),

ddRiskStatus.Selected.Result <> "All" && ddRiskSeverity.Selected.Result <> "All",
Filter(Risks, RiskStatus.Value=ddRiskStatus.Selected.Result && RiskSeverity.Value = ddRiskSeverity.Selected.Result &&
ProjectName.Value = gal_ProjectList.Selected.ProjectName
)
)