web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps No Delegation warning ...

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:

Building Power Apps

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

Verified answer

LaurensM 12,516 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!
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!

Was this reply helpful? Yes No
LoopinG2023 59 on at

Like
a
(0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No

Join the conversation