web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Auto fill data using c...
Power Apps
Unanswered

Auto fill data using condition based on SharePoint list

(0) ShareShare
ReportReport
Posted on by

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;

  1. OU(drop down list)
  2. 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:
I have the same question (0)

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 324 Most Valuable Professional

#2
11manish Profile Picture

11manish 193

#3
Valantis Profile Picture

Valantis 138

Last 30 days Overall leaderboard