Power Platform Community Forum Thread Details

Hello everyone,

I’m transitioning from using an Excel data source to SharePoint lists based on recommendations I received. However, I’m encountering delegation warnings with some functions like LookUp, DateValue, Filter, and UpdateIf—warnings I didn’t see when working with Excel from OneDrive.

The button still works, but I don’t understand the reason behind these warnings. Can anyone explain why they occur and how to handle them?

Categories:

Error handling

Hi @BP-06122300-0,

I am not sure why you did not get warnings in Excel and there is nothing in Excel that is Delegable that is not in SharePoint. DateValue() is the only one there that is not supported at all ( Lookup and Filter themselves are Delegable and UpdateIf can be switched on in the settings), but so also must the field types and operators involved. I have a blog on Delegation in SharePoint that may be of assistance.

Please click Does this answer your question 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 a Like.
MVP (Business Applications) Visit my blog Practical Power Apps LinkedIn Buy me a coffee