News and Announcements icon

Power Platform CommunityForums Power Apps - Building Power Apps No Delegation warning ...

Power Apps - Building Power Apps

Answered

No Delegation warning but will not retrieve over 2000

(0) Share

Report

Report

Posted on by LoopinG2023

59

Hey,

Am using DataVerse with PowerApps. I have a table called "TerritoriesSaps", and applying a two filters, here is the code:

With(
 {
 Pre_filter_Brand: Filter(
 TerritoriesSaps,
 "SEPHORA" = AccountName
 )
 },
 
 Filter(
 Pre_filter_Brand,
 "IDC" in Brand,
 DoorName
 )
 )

it only retrieve 38, but their more over 200.

The first filter retrieve 7212, then re-filter but only 38,

what am i doing wrong??

Categories:

General Questions

All responses Img

All responses (2)

Answers Img

Answers (1)

LoopinG2023 59 on at

Like (0)

Report

Re: No Delegation warning but will not retrieve over 2000

Say what now!! it worked powerapps is confusing at some point
Verified answer

LaurensM 12,510 Super User 2025 Season 1 on at

Like (1)

Report
Re: No Delegation warning but will not retrieve over 2000

Hi @LoopinG2023,

The second filter will only be applied to the first 2000 records that match the pre_filtered_brand filter condition returns.
If Brand is a text field, you could get away with combining both conditions in one statement:

Filter( Pre_filter_Brand, "IDC" in Brand && AccountName = "Sephora", DoorName )

If this solves your question, would you be so kind as to accept it as a solution.
Thanks!