Answered

Filter with "in" operator and And condition returns

(2) Share

Report

Posted on by Thomas.m1988

243

 
Hi all,
 
I'm trying to count rows from ListA where RequestedBy matches a set of TeamLeads pulled from ListB (filtered by a dropdown selection), combined with a status check.
CountRows(Filter(ListA, ColumnX in (Filter(ListB, TeamLead = Dropdown1.Selected.TeamLead).TeamLead) And Status.Value = "Pending Approval"))
This returns 0/blank. Tried splitting into nested Filters and checking Selected.Result vs Selected.TeamLead, still no luck.
 
What's the right pattern for combining in with other conditions on a SharePoint source, and are there delegation issues here I should watch for?
 
Thanks!

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Verified answer

Vish WR 3,748 on at

Like
a
(4)

Report
Copy link

Link copied!

@Thomas.m1988

You could try
CountRows(Filter(Filter(ListA, Status.Value = "Pending Approval"), ColumnX in (Filter(ListB, TeamLead = Dropdown1.Selected.TeamLead).TeamLead)))

There's a similar thread on this simliar issue combining Filter with in and And against a SharePoint source. The fix that worked there was splitting it into two nested Filter calls instead of one combined condition:
https://community.powerplatform.com/forums/thread/details/?threadid=f9c969fa-762d-42d4-8db1-2e6fa41e7989
Worth checking the dropdown field reference too (Selected.Result vs Selected.TeamLead) since that tripped people up in that thread as well.

Vishnu WR

LinkedIn - My Tech Space

Please ✅ Does this answer your question if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider answering Yes to Was this reply helpful? or give it a Like ♥

Was this reply helpful? Yes No
Thomas.m1988 243 on at

Like
a
(2)

Report
Copy link

Link copied!

Thanks for the quick response

Was this reply helpful? Yes No
Vish WR 3,748 on at

Like
a
(2)

Report
Copy link

Link copied!

welcome , glad it worked

Was this reply helpful? Yes No