Unanswered

Delegation Error in Power apps gallery

(0) Share

Report

Posted on by Sanket_Katdare

Hi All,

I am using below mentioned formula in gallery to show last visited by column available in SharePoint list, however it is throwing delegation error, can you please help me to eliminate delegation and make it work smoothly?

LookUp(
 Visit_Tracker,
 ID = Max(
 Filter(
 Visit_Tracker,
 DID = ThisItem.ID
 ),
 ID
 )
).Visited_By

Thanks & Regards,

Sanket

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

Rajkumar_M 3,741 Super User 2025 Season 2 on at

Like (0)

Report
Hi @Sanket_Katdare

Create a Collection: In the app's OnStart property or Screen OnVisible wherever you load your data, create a collection that includes the required columns from the SharePoint list.

ClearCollect(
VisitTrackerCollection,
Visit_Tracker
)

Gallery item:

LookUp(
VisitTrackerCollection,
ID = Max(
Filter(
VisitTrackerCollection,
DID = ThisItem.ID
),
ID
)
).Visited_By

This approach pre-loads the data into a collection, allowing you to use non-delegable functions like Max and Filter on the collection instead of the SharePoint list, which should resolve the delegation error.

Thanks!

If my response has been helpful in resolving your issue, I kindly request that you consider clicking "Accept as solution" and "giving it a thumbs up" as a token of appreciation.

Was this reply helpful? Yes No
Sanket_Katdare 39 on at

Like (0)

Report

Hi Rajkumar,

As you suggested i have created VisitTrackerCollection, also have loaded it and cheked whether it has any data by using First(VisitTrackerCollection).Visited_By in one of the label it worked fine.
After that i come back to my gallery and applied Lookup formula in Lable2 as shown below however it is not returning anything and showing some error in bottom, sharing screenshot, kindly suggest ...

Was this reply helpful? Yes No
Rajkumar_M 3,741 Super User 2025 Season 2 on at

Like (0)

Report
Try this formula in label2 property

Text(
First(
Filter(
VisitTrackerCollection,
DID = ThisItem.ID,
ID = Max(Filter(VisitTrackerCollection, DID = ThisItem.ID), ID)
)
).Visited_By
)

Was this reply helpful? Yes No