Answered

Filter Gallery by SharePoint List Person

(0) Share

Report

Posted on by duncant

278

I have created a Gallery, from a SharePoint List, that will list all courses associated to the currrent user sign in using Office365 Users Connection. I have setup a input box to allow users to search the users DiplayName, Email, or Department. I attempt to use the following formula:

Filter(SharePointList, Instructor.Email = User().Email)

It does not seem to be working. I am running into the following error:

Invalid argument Type. Cannot user table values in this context.

What is the proper way of comparing a user from a list to the current user?

Categories:

Building Power Apps

I have the same question (0)

All responses (8)

Answers (1)

Sort by

mdevaney 29,991 Moderator on at

Like (0)

Report
Copy link

Link copied!
@duncant

Where did you put this code? Which control & property?

Filter(SharePointList, Instructor.Email = User().Email)

Was this reply helpful? Yes No
duncant 278 on at

Like (0)

Report
Copy link

Link copied!

Gallery Items

Was this reply helpful? Yes No
Verified answer

v-yutliu-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @duncant ,

Do you want to filter items based on current user?

Could you tell me

1)the data type of Instructor field?

2)whether Instructor field allow multiple person?

If Instructor field is a person field and allows multiple person, you could set the gallery's Items:

Filter(SharePointList, User().Email in Instructor.Email)

Because if Instructor field allow multiple person, then "Instructor.Email" represents a table, not a value. You need to use "in"

to compare.

Best regards,

Was this reply helpful? Yes No
mdevaney 29,991 Moderator on at

Like (0)

Report
Copy link

Link copied!

@duncant

You did not say which property of the gallery you put this code in.

Was this reply helpful? Yes No
duncant 278 on at

Like (0)

Report
Copy link

Link copied!

Instructor field is person type that allows multiple.

Was this reply helpful? Yes No
mdevaney 29,991 Moderator on at

Like (0)

Report
Copy link

Link copied!

@duncant

No. I am asking "what property of the gallery did you put your code into"?

Was this reply helpful? Yes No
ilton 194 on at

Like (0)

Report
Copy link

Link copied!
Hi @duncant
You should have something like
Filter(SharepointList, email = User().Email)
instead of
Filter(SharepointList, Instructor.Email = User().Email)

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @duncant ,

Have set up a Sharepoint list with a multiple person selection column and tested, seems to be working with the following in the Items property of the gallery:

Filter(SharepointList, User().Email in Instructor.Email)

Hope this helps 🙂

Was this reply helpful? Yes No