Power Platform CommunityForums Power Apps - Power Apps Pro Dev & ISV Delegation problem

Delegation problem

(1) Share

Report

Posted on by ERIKA22

Hello everyone
I have an application that shows records made in a table on a screen. Using filters, I can see the activity that was assigned to each employee.
The database is in a SharePoint list.
Now I'm having a delegation problem with in and &&. I tried a few other ways and couldn't solve the problem.
Can you help me?

Categories:

Power Platform Build Tools

Power Apps component framework

Captura de tela 2...

All responses (1)

Answers (0)

Suggested answer

Michael E. Gernaey 44,770 Super User 2025 Season 1 on at

Like (1)

Report

Delegation problem

Hi

I would need to be on your machine to really do more but try this

Let's first filter by dates, then filter by the rest. The question is, will the Dates bring back more than 2000 or not?

With(

{DateFilteredRecords: Filter(BDxxxx, then your date filters) }, // this should not cause a delegation issue

Filter(DateFilteredRecords, Add in your IN filters)

);

// now if the number of date records won't exceed 2000, then you won't care about the delegation issues from the subfilter

// I notice that your second in is not giving a delegation warning. its possible you you may need to do 3 tier

With(

{DateFilteredRecords: Filter(BDxxxx, then your date filters) }, // this should not cause a delegation issue

With(

{ ResposavelFilterOnly: Filter(DateFilteredRecords, 'Your Combob 1_1 filter') },

// now you have records

Filter(ResposavelFilterOnly, Combobox1 filter)

);

);