Power Platform Community Forum Thread Details

I have this formula for my Gallery item.

Switch(
User().Email,
"bienvenidoiii.tumamao@emerson.com", Filter('MSOL Analytics Tracker', ThisRecord.Name.Value = "Bien"),
"jun.menoza@emerson.com",Filter('MSOL Analytics Tracker',ThisRecord.Name.Value = "Jun"),
"zionemanuel.cruz@emerson.com",Filter('MSOL Analytics Tracker',ThisRecord.Name.Value = "Zion"),
"ghiafrancia.ballener@emerson.com",Filter('MSOL Analytics Tracker',ThisRecord.Name.Value = "Ghia"),
"airamejoy.bernardo@emerson.com",Filter('MSOL Analytics Tracker',ThisRecord.Name.Value = "Airame"),
"mayennnera.carpio@emerson.com",Filter('MSOL Analytics Tracker',ThisRecord.Name.Value = "Mayenn"),
"nolan.caprecho@emerson.com",Filter('MSOL Analytics Tracker',ThisRecord.Name.Value = "Nolan"),
"marialourdes.calma@emerson.com",'MSOL Analytics Tracker',

Filter('MSOL Analytics Tracker',
Or(IsBlank(Dropdown4.Selected), Name.Value = Dropdown4.Selected.Value),
Or( IsBlank(Dropdown4_1.Selected), PD.Value = Dropdown4_1.Selected.Value),
Or(IsBlank(Dropdown4_2.Selected), FY.Value = Dropdown4_2.Selected.Value)
)
)

The switch part is not working in OnVisible (dont know why) so i put them together

Initially it was just those dropdowns

How do I make these two formulas work together?
First part is working in Item gallery but the dropdowns, no after combining with the switch formula

Categories:

Building Power Apps

Hi @Nolan0716

Maybe try it with a nested if statement:

If(
 User().Email = "bienvenidoiii.tumamao@emerson.com", 
 Filter('MSOL Analytics Tracker', ThisRecord.Name.Value = "Bien"),
 User().Email = "jun.menoza@emerson.com",
 Filter('MSOL Analytics Tracker',ThisRecord.Name.Value = "Jun"),
 ... // finish the code 
 Filter('MSOL Analytics Tracker', // default condition if none of the above match
 Or(IsBlank(Dropdown4.Selected), Name.Value = Dropdown4.Selected.Value),
 Or(IsBlank(Dropdown4_1.Selected), PD.Value = Dropdown4_1.Selected.Value),
 Or(IsBlank(Dropdown4_2.Selected), FY.Value = Dropdown4_2.Selected.Value)
 )
)

If you have any questions or feedback, please let me know. Have a great day! 😊

-----------------------
PowerYsa Power Platform Enthusiast [LinkedIn] | [Youtube]

I love to share my knowledge and learn from others. If you find my posts helpful, please give them a thumbs up 👍 or mark them as a solution ✔️. You can also check out my [@PowerYSA] for some cool solutions and insights. Feel free to connect with me on any of the platforms above. Cheers! 🍻