Multiperson field as Choices in dropdown

(0) Share

Report

Posted on by vish3027

434

Hello All,

I have SharePoint list with Title and Multiperson field... master list we can say

I have second list with Approver as person field

I want choices in approver person field should be from one of the row of master list... if its single value person field i can work but master list has multiple value in Person field and each user i wanted in approver choices as individual user and i will select 1

@RandyHayes @WarrenBelz Please

Thanks in Advance

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (0)

RandyHayes 76,299 Super User 2024 Season 1 on at

Like (1)

Report
Copy link

Link copied!

@vish3027

Please clarify - you are wanting to have all the persons from the master list Multiperson column to be displayed in a dropdown so that one can be chosen for the approver column of the second list?

If so, then your Items property of the dropdown can simply be the multiperson column from the lookup into the first list.

I hope this is helpful for you.

Was this reply helpful? Yes No
vish3027 434 on at

Like (0)

Report
Copy link

Link copied!

@RandyHayes , Yes this works with LookUp but giving issue with Filter not allowing to select display name, I wanted it to work with filter as well because if 2 rows are matching then it should have people from row1+row2 person field

Just addition to that.

if i have 3 approvers...
Approver 1:
Approver 2:
Approver 3:

All 3 getting dat from master list row with LookUp.
Approver 1... got 6 people.... remaining 5 people
then my approver 2 .... should not consider that approver selected in Approver 1 from list of 6.... it should have 5 options only....
Approver 3.... 4options only...

Sorry making it complex🙂

Was this reply helpful? Yes No
RandyHayes 76,299 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@vish3027

Yes, I understand, but you have some issues to consider. You can cascade down like that, but what do you expect to happen if the user goes back to Approver 1 and changes the selection to include one of the others in another approver...or more importantly, If John Doe is selected in approver #3, would you be expecting that in Approver #1 would NOT have John Doe as a selection, or can a user go back to #1 and change to John Doe, even though that was selected in #3??

Was this reply helpful? Yes No
vish3027 434 on at

Like (0)

Report
Copy link

Link copied!

@RandyHayes If any of the approver selected in any of the approver field that option wont be available for other approver fields.
Here John Doe is selected in Approver#3 then it should not be available in approver #1.

Was this reply helpful? Yes No
RandyHayes 76,299 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@vish3027

This is a more limiting scenario. You can't do it directly with the controls and the formula for the Items as it will result in a circular reference. You need to do this with a series of variables and utilizing the OnChange actions of the dropdown.

So, considering just 3 dropdowns, here is what you would have:

Insert a button on the screen (you can set the visible to false).

Set the OnSelect action to:

UpdateContext({lclApp1: app1DropdownName.Selected.DisplayName,

lclApp2: app2DropdownName.Selected.DisplayName,

lclApp3: app3DropdownName.Selected.DisplayName})

Approver1 dropdown:

OnChange action :  Select(theButtonInsertedAbove)

Items Property:

  Filter(yourMultiPersonTable, !(DisplayName in lclApp2 & ";" & lclApp3))

Dropdown Value set to DisplayName

Approver2 dropdown:

OnChange action :  Select(theButtonInsertedAbove)

Items Property:

  Filter(yourMultiPersonTable, !(DisplayName in lclApp1 & ";" & lclApp3))

Dropdown Value set to DisplayName

Approver3 dropdown:

OnChange action :  Select(theButtonInsertedAbove)

Items Property:

  Filter(yourMultiPersonTable, !(DisplayName in lclApp1 & ";" & lclApp2))

Dropdown Value set to DisplayName

You might want to consider a clearer on the OnVisible of the screen or some other action:

UpdateContext({lclApp1:Blank(), lclApp2:Blank(), lclApp3:Blank()})

This should give you what you are looking for.

Was this reply helpful? Yes No