cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Mr0bb0
Level: Powered On

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

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?

1 ACCEPTED SOLUTION

Accepted Solutions
Microsoft v-siky-msft
Microsoft

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

Hi @Mr0bb0 ,

 

Please modify formula as below:

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

Best regards,

Sik

View solution in original post

1 REPLY 1
Microsoft v-siky-msft
Microsoft

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

Hi @Mr0bb0 ,

 

Please modify formula as below:

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

Best regards,

Sik

View solution in original post

Helpful resources

Announcements
thirdimage

Coming Soon: T-Shirt Design Contest

Keep your eyes open for our upcoming T-shirt design contest!

thirdimage

Power Apps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

Top Solution Authors
Top Kudoed Authors
Users online (6,866)