web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Filter not working - g...

Power Apps

Answered

Filter not working - getting Invalid argument type. Cannot use Table values in this context.

(0) Share

Report

Report

Posted on by Mr0bb0

33

Hi I have an issue where my filter doesn't seem to be able to identify the correct value to filter on:

Filter(colDistinctMembers,displayName.displayName in "Username")

Obviously username is a proper username.

The colDistinctMembers collection has 2 levels.
displayName which is a table
and userPrincipleName which is a column.

The table underneath displayName also has a displayName column which is the column I want to filter on.

I'm not sure why my filter query above is giving me a table value error.

Any ideas?

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (1)

Verified answer

v-siky-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

Hi @Mr0bb0 ,

Please modify formula as below:
Filter(colDistinctMembers, "Username" in displayName.displayName )
Best regards,
Sik

Was this reply helpful? Yes No

Join the conversation