Switch Filter not working

(0) Share

Report

Posted on by Dorinda

1,512

For some reason my brain is drawing a blank on this.

I have this code

If(Filter('Asset Photos*DO NOT USE',Substation.Value = Gallery4_23.Selected.Substation && AssetClass = "Circuit Switcher" && AssetPosition= Gallery4_23.Selected.'Asset Location')

However, that only works great if I have one Asset Class to reference. In my case I have 3 I need to have switch between.

Switch(
 Subtitle2_213.Text,
 "CT",
 Filter('Asset Photos*DO NOT USE',Substation.Value = Gallery4_23.Selected.Substation && AssetPosition= Gallery4_23.Selected.'Asset Location'),
 "PT",
 Filter('Asset Photos*DO NOT USE',Substation.Value = Gallery4_23.Selected.Substation && AssetPosition= Gallery4_23.Selected.'Asset Location'),
 "CCVT",
 Filter('Asset Photos*DO NOT USE',Substation.Value = Gallery4_23.Selected.Substation && AssetPosition= Gallery4_23.Selected.'Asset Location')
 
 )

I know this code is not correct for the most part because it is not recognizing the Substation or the Asset Class, I am missing something.

I always struggle with the syntax with a Switch.

Thanks in advance for the assistance.

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Sort by

Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi,

From your code snippet it looks like you are filtering based on the selected gallery record. Are you selecting a new gallery record when your switch condition (Subtitle2_213) changes? If you don't select a new gallery record it will filter by the same criteria every time.

Thanks,
Theodore

Was this reply helpful? Yes No
TheRobRush 11,128 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
Your switch formula contains the same result for every outcome listed in it, if that is the case you would not need a switch at all. What errors do you receive if you put only this

Filter( 'Asset Photos*DO NOT USE', Substation.Value = Gallery4_23.Selected.Substation && AssetPosition= Gallery4_23.Selected.'Asset Location')

Maybe upload a screenshot so I can get a better idea what is going on

Was this reply helpful? Yes No
Dorinda 1,512 on at

Like
a
(0)

Report
Copy link

Link copied!

I don't get any error what I get is too much information back it is not recognizing the I only want CCVT and not Transformers

See image below this is showing too many items.

Compared to what is supposed to be showing

Was this reply helpful? Yes No
Verified answer

Dorinda 1,512 on at

Like
a
(1)

Report
Copy link

Link copied!
I got this working Thanks @TheRobRush for the push in the right direction.

Filter('Asset Photos*DO NOT USE',Substation.Value = Gallery4_23.Selected.Substation && AssetClass = Gallery4_23.Selected.'Asset Class' && AssetPosition= Gallery4_23.Selected.'Asset Location')

Was this reply helpful? Yes No