Unanswered

How can I lookup multiple records in a list to the multi-person column in another power apps form?

(1) Share

Report

Posted on by AdrianChang

There is a multi-person column in my power apps form. I want to set default that lookup the records in another list 'Approver List'.

Approver List:

Type PIC (person select field)

A Adrian

A Ben

A Candy

B Debbie

In the power apps form, there is a multi-person select column.
I would like to lookup all PIC when Type = A. [In this case it should be Adrian, Ben & Candy]

How can I set the DefaultSelectedItems of this column?

Categories:

Experimental features

I have the same question (0)

All responses (3)

Answers (0)

Mira Ghaly 11,413 Moderator on at

Like (0)

Report

I assume this is sharepoint / Microsoft List is that correct @AdrianChang?

Was this reply helpful? Yes No
AdrianChang 53 on at

Like (0)

Report

@Mira Ghaly Yes, all are SharePoint Lists

Was this reply helpful? Yes No
Suggested answer

Mira Ghaly 11,413 Moderator on at

Like (0)

Report
I have done a test on my end and you can do the below on the App -> On Start or according to your logic on specific event

ForAll(Filter('Approval List',ApprovalType.Value="A"),Collect(Y,Approver))

Now Y should be holding your default approval list and you will need to set it on your Multiperson card default value

Was this reply helpful? Yes No