People Picker Field Based on choice column, from 2 different SP List

(0) Share

Report

Posted on by vivekravi

241

Hello,

I am trying to narrow down the approvers based on the selected departments in the modern form control.

I have 2 list, Vacation request and Approvers.

When an employee creates a new vacation request, I want them to be able to choose their supervisors based on the department they select.

Following is the Vacation request List where the Requestor & SupervisorName are people field and department, reason, status are choice fields.

Approvers list has 2 columns, departments- choice and SupervisorsName-people.

So my requirement is if I choose 'HR' in the departments field of the modern form control, it should automatically give me the dropdown of all the people (in the SupervisorName field of the form) who are mentioned as HR (in the departments column) in the approvers SPlist.

It should also update the same supervisor name in the vacation request list, along with other details.

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (2)

Sort by

Verified answer

vivekravi 241 on at

Like (0)

Report
Copy link

Link copied!
I figured out a way and posting if someone else would require in future.

On the SupervisorName Drop down, type the following

LookUp( Filter( Approvers, Departments.Value = DataCardValue38.Selected.Value ), Departments.Value = DataCardValue38.Selected.Value, SupervisorsName )
Here the DataCardValue38 is the dropdown of Departments Data Card.

Was this reply helpful? Yes No
Verified answer

vivekravi 241 on at

Like (0)

Report
Copy link

Link copied!
The above solution works only if you have one supervisor per department. If you have more than one supervisor per department, then On the SupervisorName Drop down, type the following

ForAll( Filter( WoodstockApprovers, Departments.Value = DataCardValue38.Selected.Value ), SupervisorsName )

Was this reply helpful? Yes No