Unanswered

Delegation Issue When Filtering SharePoint List by Current User in Person Column

(0) Share

Report

Posted on by CU21041436-0

A Power Apps gallery is supposed to display items assigned to the current user using a Person field in SharePoint. Formula used:

Filter('Tasks', AssignedTo.Email = User().Email)

This gives a delegation warning and fails on large lists (>500 items)

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

stampcoin 5,058 Super User 2025 Season 2 on at

Like (0)

Report

CU21041436-0 Hi,

Try to get the user id , and set it to a variable in OnStart.

and use the Id for filter.

For example :

Set(Id,LookUp(myList, Email = User().Email,Id));

Filter('Tasks', AssignedTo.Id= varId)

if the task can belong to multiple users. then

Filter('Tasks', varId in AssignedTo.Id )

Was this reply helpful? Yes No
BCBuizer 22,505 Super User 2025 Season 2 on at

Like (0)

Report

Hi!

I had no issues using the same formula (the displayed item is beyond the Data Row limit as set in the app (2):

Can you share further details about the column settings (hint: screesnhots help!), and confirm this is the full formula you are using and it does not have any additional conditions in it.

If this reply helped you in any way, please give it a Like 💜 and in case it resolved your issue, please mark it as the Verified Answer ✅.

Was this reply helpful? Yes No
Suggested answer

vipuljain03 647 Super User 2025 Season 2 on at

Like (0)

Report
Hi.

.Email on complex columns like AssignedTo is not delegable in SharePoint connector.

Create a hidden single-line text column in SharePoint named AssignedToEmail.

Auto-populate this column using Power Automate or within the app using Patch:
Patch('Tasks', ThisItem, {AssignedToEmail: User().Email})

Filter the gallery using: Filter('Tasks', AssignedToEmail = User().Email)

This approach is fully delegable and performant.

Was this reply helpful? Yes No
Verified answer

WarrenBelz 153,026 Most Valuable Professional on at

Like (0)

Report

@CU21041436-0

Just noting here that the observation by @vipuljain03 is incorrect. Certain complex field types (single choice Person, Choice or Lookup columns for example) are delegable with the equals operator and your formula on its own Filter('Tasks', AssignedTo.Email = User().Email) certainly should be Delegable (and I have just tested one here).

@BCBuizer is correct and I am sure he can sort this out for you.

Was this reply helpful? Yes No