Answered

Drop Image Column from Multi-select Person SharePoint Field

(2) Share

Report

Posted on by Louis Joyce

Hello,

I have a Canvas App with a multi-select person field from a SharePoint list where I need to check for the users' email addresses but I'm having trouble as PowerApps shows the below error:

The field in the question has the below settings:

I have the below Named Formulas to retrieve the logged in user's Office 365 Profile and their Direct Reports

fxUser = Office365Users.MyProfileV2();
fxReports = Office365Users.DirectReportsV2(fxUser.id).value;
 

I have tried the following in PowerApps in the onVisible of the relevant screen:

//Collect SharePoint List
ClearCollect(colList, 'SharePoint Source');
 
It may be worth noting the above is also set to run in the onVisible of the startscreen of the app, it's run again here to ensure any changes are captured.

//Collect Responsible Parties

ClearCollect(colRP, ShowColumns(colList,'Responsible Parties'));

//Collect Email from RP
Collect(colRPEmail, Filter(colRP,fxReports.mail in ResponsibleParty.Email))
 
The last step is where the "Can't Convert this data type" error appears, looking at the colRP collection I can see it collects as a one column table where each row is it's own table like below:
 
When selecting one of these records it shows the following:
 
I would imagine the issue is that the Picture field is being retrieved when the original collection is created, is there any way to prevent this?
I would've thought given that in the SharePoint List it's not using the profile image it wouldn't be necessary to retrieve it.
 
I am looking to use this to filter a gallery based on whether the email addresses in fxReports are present in the Responsible Parties field.
 
PowerApps authoring version is 3.26041.15 if it's relevant.

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Verified answer

Vish WR 3,748 on at

Like
a
(4)

Report
Copy link

Link copied!

@Louis Joyce

A multi-select Person column in SharePoint is returned as a Table, not a string. Comparing a table directly to a text value (Email) triggers the "Can't convert Table to Text" error.

You must "reach into" the nested table to perform the comparison.

Use a nested Filter with IsEmpty for your Gallery:

Filter(colList, !IsEmpty(Filter('Responsible Parties', Email in fxReports.mail)))

Vishnu WR

LinkedIn - My Tech Space

Please ✅ Does this answer your question if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider answering Yes to Was this reply helpful? or give it a Like ♥

Was this reply helpful? Yes No
Louis Joyce 45 on at

Like
a
(3)

Report
Copy link

Link copied!

That worked, thank you very much!

Was this reply helpful? Yes No
Vish WR 3,748 on at

Like
a
(2)

Report
Copy link

Link copied!

@Louis Joyce

Thanks for the update, Glad it fixed the issues.

Happy coding :)

Vish

wrvishnu.com | LinkedIn

Was this reply helpful? Yes No