Filtering gallery based on multiple selections from different screens

(0) Share

Report

Posted on by Lach

I currently have 3 screens and My current navigation goes: Risk Area > Risk Factors > Risks

I want to filter A gallery on my final screen (Risks) based on the selections made on two previous screens.

I can successfully filter based on one screen or the other but not both using a Switch function. I can't figure out how to merge the following:

Switch('Gallery risk areas'.Selected.ID,
1,Filter('Risk Assessment Master','Risk Area'="Money Laundering",
2,Filter('Risk Assessment Master','Risk Area'.Value ="Terrorist Financing"),
3,Filter('Risk Assessment Master','Risk Area'.Value ="Sanctions"),
4,Filter('Risk Assessment Master','Risk Area'.Value ="Compliance")
)

Switch('Gallery Risk Factor'.Selected.ID,
1,Filter('Risk Assessment Master','Risk Factor'.Value ="Customer"),
2,Filter('Risk Assessment Master','Risk Factor'.Value ="Transactions"),
3,Filter('Risk Assessment Master','Risk Factor'.Value ="Product"),
4,Filter('Risk Assessment Master','Risk Factor'.Value ="Channels"),
5,Filter('Risk Assessment Master','Risk Factor'.Value ="Geography")

Many Thanks

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

v-xiaochen-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Lach ,

Please try this:

Switch('Gallery Risk Factor'.Selected.ID, 1,Filter(Switch('Gallery risk areas'.Selected.ID, 1,Filter('Risk Assessment Master','Risk Area'="Money Laundering", 2,Filter('Risk Assessment Master','Risk Area'.Value ="Terrorist Financing"), 3,Filter('Risk Assessment Master','Risk Area'.Value ="Sanctions"), 4,Filter('Risk Assessment Master','Risk Area'.Value ="Compliance") ),'Risk Factor'.Value ="Customer"), 2,Filter(Switch('Gallery risk areas'.Selected.ID, 1,Filter('Risk Assessment Master','Risk Area'="Money Laundering", 2,Filter('Risk Assessment Master','Risk Area'.Value ="Terrorist Financing"), 3,Filter('Risk Assessment Master','Risk Area'.Value ="Sanctions"), 4,Filter('Risk Assessment Master','Risk Area'.Value ="Compliance") ),'Risk Factor'.Value ="Transactions"), 3,Filter(Switch('Gallery risk areas'.Selected.ID, 1,Filter('Risk Assessment Master','Risk Area'="Money Laundering", 2,Filter('Risk Assessment Master','Risk Area'.Value ="Terrorist Financing"), 3,Filter('Risk Assessment Master','Risk Area'.Value ="Sanctions"), 4,Filter('Risk Assessment Master','Risk Area'.Value ="Compliance") ),'Risk Factor'.Value ="Product"), 4,Filter(Switch('Gallery risk areas'.Selected.ID, 1,Filter('Risk Assessment Master','Risk Area'="Money Laundering", 2,Filter('Risk Assessment Master','Risk Area'.Value ="Terrorist Financing"), 3,Filter('Risk Assessment Master','Risk Area'.Value ="Sanctions"), 4,Filter('Risk Assessment Master','Risk Area'.Value ="Compliance") ),'Risk Factor'.Value ="Channels"), 5,Filter(Switch('Gallery risk areas'.Selected.ID, 1,Filter('Risk Assessment Master','Risk Area'="Money Laundering", 2,Filter('Risk Assessment Master','Risk Area'.Value ="Terrorist Financing"), 3,Filter('Risk Assessment Master','Risk Area'.Value ="Sanctions"), 4,Filter('Risk Assessment Master','Risk Area'.Value ="Compliance") ),'Risk Factor'.Value ="Geography") )

Best Regards,

Wearsky

Was this reply helpful? Yes No
Lach 4 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Wearsky,

I actually managed to achieve what I wanted with an alternate method which seems more flexible:

Filter('Risk Assessment Master',
('Risk Factor'.Value = Text('Gallery Risk Factor'.Selected.'Title- risk Factor'))

&&

('Risk Area'.Value =Text('Gallery risk areas'.Selected.Title))

Thank you for showing how the Switch variation would have worked however

Was this reply helpful? Yes No