Showing results for 
Search instead for 
Did you mean: 
Not applicable

Creating Multiple Conditional Variables

I have a Member list. The members are allowed access, view, edit and other rights to the database based on their 'hierarchy' designation in the Member list "HierarchyColumn'. A Member can be either 'National', 'Region', 'Local' or 'Employee'.


My original configuration looks like the below. I can do this with the National and Region because of the limited number of names. However, the bulk of the Members (more than 500) have a hierarchy of 'Local' or 'Employee' on the Member list


How can I create a variable that when applied to any dropdown, comb box, or Gallery will consider the Member hierarchy, and if 'National' - provided Full Access, if 'Region' - Show 'only' all items associated with the Region they are assigned to as indicated on the Member list 'RegionColumn' in the Member list, If 'Local' - Show 'only' all items associated with the Location they are assigned to as indicated in the Member list 'LocationColumn', and if the hierarchy is  'Employee' - Show 'only' items associated with that employee (using the UnqIDColumn).


I'm currently using the following to separate for 'National' and 'Region'. Can I create one that considers the below and incorporated the above?



'Set(varIsNational,If(User().FullName="Joe Schmoe",true,User().FullName="Jane Doe", true,User().FullName="Moon Mullins",true,false));


Set(varIsRegion,If(User().FullName="Jack Sprat",true,User().FullName="Johnny Rotten", true,User().FullName="Hubba Bubba",true,false));

Resident Rockstar
Resident Rockstar

Hi @Anonymous ,

You can use the gallery to DIsplay all the Records.

In Items Properties you can use the Condition Based on User Privilege

//Same goes Like that

Like - above

Not applicable

I believe I understand.

It looks like one condition per incident, yes?


Is there a way to may a multiple statement Condition, that I can apply to any Gallery, Dropdown, Comb Box with such a need?

I am pulling the employee UserName/Email from the active directory, and storing it in a Member list.


Can there be one condition with multiple statements that can read the UserName pulled (as displayed on screen in the User interface), compare it to the UserNames on the Member list and the 'HierarchyColumn' and automatically allow or forbid National, Region, Local, Employee access? 


If not, will this do the same thing...



1. and another one for Local

2. and another one for Employee


...and place them all together in the items property of whatever Gallery, Dropdown or Comb Box where it is needed; this will solve my problem?


Not applicable

Even better...can a multiple statement condition be created and placed Screen 1; App Start.


I think that would make it a global condition that would work on all screens, yes?


Just spit balling. I don't really know much.

Helpful resources

UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Solution Authors
Top Kudoed Authors
Users online (1,590)