LOOKUP() to SP List with Multi-Person field

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

I'll try to keep this short and simple:

I have a Gallery2 where items = PowerBIIntegration.Data

Gallery2 contains a list that builds Collection1 as items are checked using a checkbox.

As the checkbox are marked, a field is calculated in Collection1 to find the email of the manager from 'Approvers' sharepoint list.

The formula worked fine when the 'Approvers' list was just a single name in the person field. I recently had to change the column to allow for multiple selections, and update the items to have 2 or more names per item.

my original formula to find the email of the manager:

LookUp('Approvers','Approver Role'.Value= "Manager" ,'Approver Name'.Email)

Now the formula is broken with the following error message:
Invalid argument type (Text). Expecting a Table value instead.

Is it possible to bring in the emails of a multi-person column without having to bring in the data as text and parse out the information?

Categories:

Building Power Apps

I have the same question (0)

All responses (1)

Answers (1)

Verified answer

v-qiaqi@microsoft.com Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Anonymous，

Could you please tell me tell which control you want to set with this LookUp() formula?

How to modify your original formula depends on which data type the control expects.

You should make sure that you have refresh the data source to apply the changes, and then use the Filter() instead because it returns table value.

Was this reply helpful? Yes No