web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Filter not working - g...
Power Apps
Answered

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

(0) ShareShare
ReportReport
Posted on by 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:
I have the same question (0)
  • Verified answer
    v-siky-msft Profile Picture
    on at

    Hi @Mr0bb0 ,

     

    Please modify formula as below:

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

    Best regards,

    Sik

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 765 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 343 Super User 2025 Season 2

#3
Power Platform 1919 Profile Picture

Power Platform 1919 272

Last 30 days Overall leaderboard