Problem wirking with lists

(0) Share

Report

Posted on by BP-06122300-0

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?

All responses (1)

Answers (1)

Verified answer

WarrenBelz 145,434 on at

Like (0)

Report

Problem wirking with lists

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