Requirement: Display Cascading drop down values
Step 1: Create a SharePoint list “GroupUsers“, Add two fields-
- GroupName– Single line of text
- User– Person or Group column
Step 2: Here Approvers and On-Call Approvers are the two items in GroupName field and on User filed add the user exists in Organization
Step 3: To get the Cascading drop down values create Canvas app and add the controls to the screen.
Step 4: Add the below functionality to the Combo Box
Approvers: Items Property-
Distinct(LookUp(GroupUsers,GroupName="Approvers").User,DisplayName)
On-Call Approvers: Items Property-
Distinct(LookUp(GroupUsers,GroupName="On-Call Approvers").User,DisplayName)
Step 5: Using the above formulas will display the cascading dropdown values and after completion once Preview and see the result.