Answered

in operator inside Filter not working properly

(0) Share

Report

Posted on by uiit3155

124

I am writing below code in DefaultSelectedItems property of combobox. But it is only returning one record. How can i show all the users which are stored in SharePoint "Approvers" people picker field?

Filter( Office365Users.SearchUser({}), Mail in ForAll(LookUp(CustomerList,ID=44).Approvers,ThisRecord.Email))

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

Sort by

v-qiaqi@microsoft.com Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @uiit3155,

Do you want the people picker to display all the approvers from the 44th record of CustomerList?

If so, please set the DefaultSelectedItems as:

Ungroup(Filter( CustomerList, ID=44).Approvers,"Approvers")

Was this reply helpful? Yes No
uiit3155 124 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @v-qiaqi-msft
Below error i am getting while writing the above expression. A column named 'Email' already exists.
Below is the screenshot of source to ungroup:

Regards
@uiit3155

Was this reply helpful? Yes No
v-qiaqi@microsoft.com Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @uiit3155,

This is my testing result, and Owner is a Person column allowing multi select in my list.

Confused...

Not sure how you configure your list, cannot tell anything useful.😂

You refer to Approver column in your original column, what is this endor... column?

This Approver column should be a Person column allowing multi select.

Was this reply helpful? Yes No
uiit3155 124 on at

Like
a
(0)

Report
Copy link

Link copied!
@v-qiaqi-msft

I used Approver column instead of EndorsementRequestCCTo to explain the query easily. EndorsementRequestCCTo is the person and group column with multiselect as per below screenshot.

Ungroup(Filter( CustMastRequestCMIR, ID=44).EndorsementRequestCCTo,"EndorsementRequestCCTo")

Was this reply helpful? Yes No
Verified answer

v-qiaqi@microsoft.com Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @uiit3155,

Check my above formula and see if there is difference with your settings.

The formula is correct.

Further, the error indicates that your column name may exist, which may cause that you could not refer to the real person column.

Try to create a new person column and apply to the formula.

Was this reply helpful? Yes No