Share
ReportI have:
1. Power Apps Screens
2. An SP Member list
3. The Member list has columns like 'UnqID'(Text), UserName(Text), Hierarchy(Text)
4. An SP Member Training List
5. The SP Member Training List has specific information about the member (including the UnqID) and has columns that mimic those in the Member list
4. Several Screens have Dropdowns, Combo Boxes, Galleries, and Forms
I need a multiple condition formula that I can paste into various 'default', 'item', etc. properties in such a way that whoever the User is the system can identify them and apply appropriate levels of access through the Dropdowns/Combo Boxes, and display only specific data in Galleries based on the Member hierarchy designation.
The Member List Hierarchy column can contain 'Employee', 'Park', 'Region', and 'National' designations.
What I need is a multiple condition or multiple variables that can placed in various places in the App that recognize the User and their Hierarchy designation (as determined by the Hierarchy column in the Member List), and apply the appropriate access to Dropdowns, Combo Boxes, and display only specific data based on said Hierarchy designation.
I currently have a 'Park' Dropdown that has the following:
In Default: blank (no content)
In DefaultSelectedItems: Filter(SortByColumns(ParkListCollection.Park, "Title", Ascending), Title = ParkDD.Selected.Park)
In Items: ParkListCollection
In DisplayMode: If(varIsNational,DisplayMode.Edit,DisplayMode.Disabled)
My varIsNational variable is:
Set(varIsNational,If(User().FullName=" ",true,User().FullName=" ", true,,User().FullName=" ",true,false));
I did the above for eight names. There are now too many names to work a reliable variable this way. How can I create a variable that looks to the Member List Hierarchy column and asks 'if Member hierarchy is...', then...whatever access the Member needs/should have should be enforced.
All responses (
Answers (
62
