Help me!

(0) Share

Report

Posted on by dylandavis09

438

How I get two if value match? I do correctly?

If(LookUp('Maintenance Window', ID = 1).Status.Value = "Turn Off", 'DHS Homepage','DHS Maintenance Window')&If(LookUp('Maintenance Window', ID = 2).Status.Value = "Turn Off", 'DHS Homepage','DHS Maintenance Window (Summer Break)')

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (0)

charlessexton 21 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!
If(LookUp('Maintenance Window', ID = 1).Status.Value = "Turn Off", 'DHS Homepage','DHS Maintenance Window')&If(LookUp('Maintenance Window', ID = 2).Status.Value = "Turn Off", 'DHS Homepage','DHS Maintenance Window (Summer Break)')
What do you want the code to do? If the ID is either 1 or 2 then display "DHS Homepage"? Otherwise display "DHS Maintenance Window"?

Also, where are you putting this code?

Was this reply helpful? Yes No
dylandavis09 438 on at

Like (0)

Report
Copy link

Link copied!

Yes, I want to do that. I am using the 'App' in the 'startscreen' property.

The screen always starts on the DHS Homepage. When I turn on a specific value, it transitions to the maintenance window or the maintenance window for summer break 'startscreen'.

Was this reply helpful? Yes No
charlessexton 21 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!
How about this?
If( LookUp('Maintenance Window', ID = 1).Status.Value = "Turn Off" Or LookUp('Maintenance Window', ID = 2).Status.Value = "Turn Off", 'DHS Homepage', 'DHS Maintenance Window' )

The confusing bit for me is why you have a 'DHS Maintenance Window' and a 'DHS Maintenance Window (Summer Break)'. Are both needed?

Was this reply helpful? Yes No
dylandavis09 438 on at

Like (0)

Report
Copy link

Link copied!

Well, we need two different types of maintenance windows for our screens.

The first Maintenance Window is for updates and security, and it is blocked during school hours due to testing or other reasons.

The second Maintenance Window, specifically for Summer Break, is intended for students who have gone home for the summer break. This means students can't access it until they return next fall.

Was this reply helpful? Yes No
charlessexton 21 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

You'll want to have another bit of logic in there related to that then. Just another check in your If() function.

Was this reply helpful? Yes No
timl 36,733 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!
@dylandavis09

Nesting the If statements will take you closer to what you want to achieve.

Note that with your current data structure, it's possible to "Turn On" both 'DHS Maintenance Window' and 'DHS Maintenance Window (Summer Break)'. In that case, which screen do you want to display?

If(LookUp('Maintenance Window', ID = 1).Status.Value = "Turn Off" && LookUp('Maintenance Window', ID = 2).Status.Value = "Turn Off", 'DHS Homepage', If(LookUp('Maintenance Window', ID = 1).Status.Value = "Turn Off" && LookUp('Maintenance Window', ID = 2).Status.Value <> "Turn Off", 'DHS Maintenance Window', 'DHS Maintenance Window (Summer Break)' ) )

Was this reply helpful? Yes No