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

All responses (3)

Answers (0)

Sort by

Rajkumar_M 3,747 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
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.
Sanket_Katdare 41 on at

Like
a
(0)

Report
Copy link

Link copied!

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 ...
Rajkumar_M 3,747 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
Try this formula in label2 property

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