Power Platform Community Forum Thread Details

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.

Categories:

Building Power Apps

Community site session details

Auto fill data using condition based on SharePoint list

Helpful resources

News and Announcements

Quick Links

Forum hierarchy changes are complete!

Ajay Kumar Gannamaneni – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Leaderboard > Power Apps

Featured topics

Product updates