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

Invalid argument type. Cannot use Table in this context when using filter

Hi my filter is this:

 

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

 

 

Where the collection contains displayName which is a table and another column.

Clicking into the displayName table there is another column displayName.

This is the column I am attempting to filter on.

I can return it OK in a label 

 

Concat(colDistinctMembers.displayName, Concat(displayName,displayName))

 

 

But I get  Invalid argument type. Cannot use Table in this context when using filter when I try to use it in a filter.

 

Any ideas what I'm doing wrong?

 

BTW I'm putting the filter query into a gallery.

1 ACCEPTED SOLUTION

Accepted Solutions
Dual Super User
Dual Super User

Re: Invalid argument type. Cannot use Table in this context when using filter

Hey @Mr0bb0 

 

Can you try to update the configurations as:
Filter(colDistinctMembers,"Username" in displayName.displayName)

You can use the below expression on the Items property of the Gallery as:

Filter(colDistinctMembers, displayName.displayName = "Value to search")

If this differs, please share more details so that we might be able to help you better.

 

Hope this Helps!

 

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

View solution in original post

3 REPLIES 3
Dual Super User
Dual Super User

Re: Invalid argument type. Cannot use Table in this context when using filter

Hey @Mr0bb0 

 

Can you try to update the configurations as:
Filter(colDistinctMembers,"Username" in displayName.displayName)

You can use the below expression on the Items property of the Gallery as:

Filter(colDistinctMembers, displayName.displayName = "Value to search")

If this differs, please share more details so that we might be able to help you better.

 

Hope this Helps!

 

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

View solution in original post

Mr0bb0
Level: Powered On

Re: Invalid argument type. Cannot use Table in this context when using filter

Thanks @yashag2255 

 

Filter(colDistinctMembers,"Username" in displayName.displayName) worked fine, I feel rather dumb now! 😉

 

I'm still not sure why the above worked and the below didn't? 

 

Filter(colDistinctMembers, displayName.displayName = "Value to search")

 

Thanks again

Dual Super User
Dual Super User

Re: Invalid argument type. Cannot use Table in this context when using filter

Hi @Mr0bb0 

 

The first one didn't work because displayName.displayName returns a one column table of all the values inside this column.

 

Hope this Helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

Helpful resources

Announcements
thirdimage

Power Apps Super User Class of 2020

Check it out!

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

SecondImage

Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Top Solution Authors
Top Kudoed Authors (Last 30 Days)
Users online (5,009)