Answered

Handling Delegation - Work Around

(1) Share

Report

Posted on by sankhlay

187

Hello All - I have this formula that filters gallery based on various drop down filters I have and along with that, I would like to filter the data so that data for current month is only displayed after 11th of the month. For the underlined data, I get a delegation.

Award Month is a Calculated Column and Month(Created) is also heading into delegation. My database will be crossing 2000 records in 2 months. Is there a work around

2) Since I will start a new fiscal year, Can I start my filter based on FY25 and then the others so that the delegation can be handled?

SortByColumns( Filter( 'SPLIST', (StartsWith( 'Employee Name', SearchAssociateID_Name.Text ) || StartsWith( 'EEID', SearchEEID_Name.Text )) && (('Name of SLT'.Value = DrpDwnSLT.Selected.Value) || (DrpDwnSLT.Selected.Value = Blank())) && (('Award Name'.Value = DrpAwardName.Selected.Value) || DrpAwardName.Selected.Value = Blank()) && (('Name Of Manager' = DrpDwnNameofManager.Selected.Value) || (DrpDwnNameofManager.Selected.Value = Blank())) && (('Fiscal Year'.Value = DrpFY.Selected.Value) || (DrpFY.Selected.Value = Blank())) && ((('Award Month') = DrpAwardMonth.Selected.Value) || (DrpAwardMonth.Selected.Value = Blank()) && (Month(Created) <> Month(Today()) || Day(Today()) >=11 && Day(Today()) <= 31))) , "Created", SortOrder.Descending )

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Verified answer

Sam_Fawzi 873 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!
Hey @sankhlay ,

Lets simplify the code a bit,

First, lets do a collection of the filtered data ( add it to all filters - on change property)
ClearCollect( colData, Filter( 'SPLIST', (('Name of SLT'.Value = DrpDwnSLT.Selected.Value) || (DrpDwnSLT.Selected.Value = Blank())) && (('Award Name'.Value = DrpAwardName.Selected.Value) || DrpAwardName.Selected.Value = Blank()) && (('Name Of Manager' = DrpDwnNameofManager.Selected.Value) || (DrpDwnNameofManager.Selected.Value = Blank())) && (('Fiscal Year'.Value = DrpFY.Selected.Value) || (DrpFY.Selected.Value = Blank())) ) ); //Filter Data for Current Month After the 11th Day: //Apply additional filters on the collected data. ClearCollect( colFilteredData, Filter( colData, (StartsWith('Employee Name', SearchAssociateID_Name.Text) || StartsWith('EEID', SearchEEID_Name.Text)) && (('Award Month' = DrpAwardMonth.Selected.Value) || (DrpAwardMonth.Selected.Value = Blank())) && (Month(Created) <> Month(Today()) || Day(Today()) >= 11 && Day(Today()) <= 31) ) );

Set the Items property of the gallery to the filtered collection.
SortByColumns( colFilteredData, "Created", SortOrder.Descending )

hope this will help!
Cheers,

Was this reply helpful? Yes No
sankhlay 187 on at

Like (2)

Report
Copy link

Link copied!

This was super fast and best. Thank you so much @samfawzi_acml for the simplification.

Was this reply helpful? Yes No
sankhlay 187 on at

Like (1)

Report
Copy link

Link copied!

I have gone into one situation - I am guessing the delegation is impacting the gallery data. I see only 500 records are showing up when I see the gallery. Once I change the data limit to 2000, things are working fine; however I am guessing once the data crosses 2000, this code may not work. Kindly let me know if I am thinking differently.

Was this reply helpful? Yes No
Sam_Fawzi 873 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Hey @sankhlay ,

If your data is going to hit 2000 records soon, it might not load correctly due to delegation limits. One solution is to load the data on start into a local collection, which you can then use across the app using Power Automate. This might introduce a slight delay when the app starts, but if your data set isn’t excessively large, it shouldn’t significantly slow down the app.
Another option is to use a grouping approach. For example, you could group the data by Fiscal Year (assuming you will not exceed 2000 records per Fiscal Year). Once the data is grouped, you can apply filters to the grouped data. This method allows you to stay within delegation limits while still being able to filter and manipulate large datasets.
If you're comfortable using Power Automate, let me know, and I can send you the detailed steps to set this up.
Cheers,

Was this reply helpful? Yes No