Answered

Delegation warning

(0) Share

Report

Posted on by Big_S

494

Hi Guys,
Does anyone know how to fix this delegation warning, I have 8K plus records and I wanted to display them in the gallery. here's my code.

With({wreq: Sort(
 Filter(
 '[dbo].[Request]', Status = 1,
 ApprovalStatus = Dropdown3.SelectedText.Value,
 Requester=_myProfile.UserPrincipalName
 ), Descending
 ), 
 condition1: RequestDates_1.SelectedDate=Blank() && RequestDates.SelectedDate =Blank(), 
 condition2: RequestDates.SelectedDate = Blank()
 }, 
 
 If(
 condition1, Filter(wreq, TransactionDate >= RequestDates.SelectedDate), 
 condition2, Filter(wreq, TransactionDate <= RequestDates_1.SelectedDate),
 Filter(wreq, TransactionDate <= RequestDates_1.SelectedDate && 
 TransactionDate >= RequestDates.SelectedDate
 )
 )
)

Here's the warning screenshot

Categories:

Building Power Apps

All responses (5)

Answers (1)

Sort by

Verified answer

Drrickryp Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@Big_S

You are missing the column name to sort on. It needs to be in front of the Descending in the formula.
Big_S 494 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Drrickryp ,
I have added the column TransactionDate but still get the warning
Drrickryp Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

It doesn't make sense. Sort is delegatable in every datasource.
Big_S 494 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Drrickryp ,
I figured it out it was my mistake thank you so much, adding the transaction date column was correct.
Big_S 494 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Drrickryp
I have used and updated your code and added the If statement now I got a delegation warning can you help me how to fix this? here's the screenshot of the code.