Hi all,
I am stuck with using if condition in canvas app. I have SharePoint list called ‘User Data’ and it’s contain below fields.
- User name(People)
- Email(single line)
- OU(single line)
- OU Head(people)
- Division(single line)
- Division Head(people)
In canvas app I have columns like;
- OU(drop down list)
- Approver(drop down list but view only)
What I need is, when User equals to current user, then automatically fill the the ‘OU’ column. and then, based on that auto fill the ‘Approver’ column based on below condition.
- Current user = OU Head, then Approver will be Division Head
- Current user = Division Head, then Approver will be specific user
- by default, Approver will be OU Head
I am stuck with auto populate Approver name by using above condition. Anyone can help me to get this clear, please.

Report
All responses (
Answers (