Multiple Condition DisplayMode Formula

(0) Share

Report

Posted on by Phineas

5,331 Moderator

Trying to check my logic.

I have a Location, a Member, and a Hierarchy.

I have a Location Combo Box (Combo Box 1) and a Member Full Name Combo Box (Combo Box 2).

If the Location chosen in in Combo Box 1 is equal to "UNAS" and the Hierarchy of the Member in Combo Box 2 is equal to "One" then Combo Box 2 DisplayMode should default to 'Edit' else 'Disabled'.

If the above is not true then...

If the Location chosen in Combo Box 1 is equal to any other Location initiate:

If(varHierarchy="One" Or varHierarchy="Two" Or varHierarchy="Three"=true,DisplayMode.Edit,DisplayMode.Disabled)

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

Sort by

RandyHayes 76,299 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!
@Phineas

Please consider changing your Formula to the following:

If( ComboBox1.Seleected.Location = "UNAS" && (varHierarchy="One" || varHierarchy="Two" Or varHierarchy="Three"), DisplayMode.Edit, DisplayMode.Disabled )

The Location column on the Combobox1 in the above formula will be dependent on your Items property of that control, so adjust as needed.

I hope this is helpful for you.

Was this reply helpful? Yes No
RandyHayes 76,299 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@Phineas

Were you able to work through your issue or do you still need help?

Was this reply helpful? Yes No
Phineas 5,331 Moderator on at

Like (0)

Report
Copy link

Link copied!

All good for now. Thanks for checking.

Was this reply helpful? Yes No