Unanswered

PowerApps 'in' operator returning all records from a table, not just records where value is present.

(0) Share

Report

Posted on by zachp

I am trying to use the 'in' operator within a Filter condition, to just return the records that feature the word "Project Executive". As you can see in the output table, PowerApps is returning every record in the table (approx. 100 records).

Have I misunderstood how 'in' is used, does it just check if the value is present in the table and if so return the entire table. From what I've read in the documentation and online this does not appear to be the case.

I am experiencing this behaviour no matter what column I search against or what value I use 'in' with. In my actual code I am using a more complex value that is derived from a function. I have changed it here to just searching for "Project Executive" to simplify matters.

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

Sort by

SpongYe 5,909 Super User 2026 Season 2 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @zachp

Remove the datasource front of the column name.
Because the first parameter of the filter already identify the datasource.

Try this:

Filter( lst_RoleList, "Project Executive" in Lower(Role) // use the columnname instead of adding the datasource in front )

If you have any questions or feedback, please let me know. Have a great day! 😊

-----------------------
PowerYsa Power Platform Enthusiast [LinkedIn] | [Youtube]

I love to share my knowledge and learn from others. If you find my posts helpful, please give them a thumbs up 👍 or mark them as a solution ✔️. You can also check out my [@PowerYSA] for some cool solutions and insights. Feel free to connect with me on any of the platforms above. Cheers! 🍻

Was this reply helpful? Yes No
zachp 6 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @SpongYe - thank you so much for your reply.

Removing the data source from the column name has resolved this. However the reason I added the column source in the first place is due to other errors. See below:

image 1: If I try to use this table (created using a Filter function) within another Filter function it states it expects a one column table?
image 2: If I qualify the column names to return then I can't use any other column names within that data source.

Any thoughts?

Was this reply helpful? Yes No
SpongYe 5,909 Super User 2026 Season 2 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @zachp

Try using a With() function for what your trying to achieve:
With( { _lst_Projects_Master: Filter(lst_Projects_Master, Status = "Live"), _lst_RoleList: Filter(lst_RoleList, Email = User().Email) }, Sort( Filter(_lst_Projects_Master, ProjectID in _lst_RoleList), Project_Name ) )

If you have any questions or feedback, please let me know. Have a great day! 😊

-----------------------
PowerYsa Power Platform Enthusiast [LinkedIn] | [Youtube]

I love to share my knowledge and learn from others. If you find my posts helpful, please give them a thumbs up 👍 or mark them as a solution ✔️. You can also check out my [@PowerYSA] for some cool solutions and insights. Feel free to connect with me on any of the platforms above. Cheers! 🍻

Was this reply helpful? Yes No