web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Delegation error when ...

Power Apps

Answered

Delegation error when trying to filter based on the lookup field

(0) Share

Report

Report

Posted on by johnjohn123

3,514

I have 2 SharePoint lists:-

1) Activities

2) Project Master

now inside the Activities list i have a lookup field to the Project Master as follow:-

now when i am trying to get the activities under a related mater project, i will get a delegation error:-

now if i write the following filter the delegation error will gone, but there will be an issue if two master projects share the same title:-

sort(Filter(Activities,ProjectTitle.Value = varProjectdetails.Title),Created,Descending)

any advice? should i change my lookup setting inside sharepoint to have the ID instead of the title inside the "In this column" dropdown?

Thanks

Categories:

Building Power Apps

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

WarrenBelz 156,536 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @johnjohn123 ,

"Secondary" lookup fields are not Delegable (you also should seriously ask yourself why you are using Lookup fields with Power Apps at all), so changing the column will not help. You really need an identifier in the related list reflecting a field in the "Parent" (if you want to escape the Delegation issue).

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.
Verified answer

johnjohn123 3,514 on at

Like
a
(0)

Report
Copy link

Link copied!
@WarrenBelz i changed the formula as follow:-

sort(Filter(Activities,ProjectTitle.Value = varProjectdetails.Title),Created,Descending)

and i asked the users to make sure that the Project Title is unique.. i can not think of other approachto get this fixed

Join the conversation