web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

Welcome to the Power Platform Communities
News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Delegation Warning
Power Apps
Answered

Delegation Warning

(0) ShareShare
ReportReport
Posted on by Moe69

Hi all,

 

I'm new to all this SharePoint, Power Apps and Power Automate, but slowly I'm learning and improving my knowledge thanks to these type of community sites. 

 

Can't seem to figure out how to get rid of the delegation warnings for the formulas set below to display on my Power Apps dashboard.

It works okay, however, when the data reaches 500 items it doesn’t load up anymore date post 500. Which I end up deleting data provided from (SharePoint).

 

Sort(Filter(PlanningTool,Or ('Choice Status'.Value= "Late" && ('Start Time' -0.5)<Now() && ('Finish Time'+0.25) >Now())),'Start Time',Ascending)

 

Planning Tool = SharePoint Source 

Choice Status = Drop Down Choice selection of 5 items to choose from.

Start Time = Date and time picker

Finish Time = Date and time picker

 

Appreciate any help, thanks in advance.

Categories:
Building Power Apps
I have the same question (0)
  • EddieE Profile Picture
    EddieE 4,650 Moderator on at

    @Moe69 

    The Or() function isn't delegable, hence the warning. You can re-write your function like this tho because it wasn't getting used anyway.

     

    Sort(
 Filter(
 PlanningTool,
 'Choice Status'.Value= "Late" && 
 ('Start Time' -0.5)<Now() && ('Finish Time'+0.25)>Now()
 ),
 'Start Time',
 Ascending
)

     

    It's a good idea to reference the MS Docs when looking to understand/fix Delegation errors. If you want to get more understanding of delegation @RezaDorrani has a great 5 part YouTube series here.

  • cwebb365 Profile Picture
    cwebb365 3,300 Most Valuable Professional on at

    That’s actually not accurate. Or() is totally delegable. I think the delegation might be coming from the Now() function. To get past that you can just do an UpdateContext({varNow:Now()}) on the button click or what not leading to this filtered event (maybe on start?). Anyway not at computer so can’t test but it could be fixed. Just know getting dates used to cause delegation issues. Or should be fine.  

  • Moe69 Profile Picture
    Moe69 on at

    Hi EddieE,

    Thank you for responding back, much appreciated.

    I have followed and amended as you mentioned, but still getting the delegation warning.

     

    I have since update the names on the data cards in SharePoint, please see screen shot, still the same requirements of events. this is my real details been used in my SharePoint data list. 

    Moe69_1-1646644423092.png

     

     

     

     

  • Moe69 Profile Picture
    Moe69 on at

    Hi  cwebb365,

    Thank you for responding,

     

    My data is coming direct from SharePoint where when the data card choice value is updated (from a drop down selection of 13 items). Power Apps is used as a monitoring screen and there is no button to click on, however i am using a timer to refresh the content to reflect the change has happened.   The below formula is repeated 12 times against the the other choice items.

     

     

    Moe69_2-1646645312718.png

     

  • EddieE Profile Picture
    EddieE 4,650 Moderator on at

    @Moe69 

    Sorry, @cwebb365  is correct in that the Or() function is delegable but you didn’t appear to be using it correctly. Removing it hasn’t fixed your issue though.

     

    It seems like you are doing a time calculation on 2 columns, is that what you are trying to do?

  • Moe69 Profile Picture
    Moe69 on at

    Hi EddieE,

    Thank you for replying back,

    Yes, that’s correct. I am trying to do a time calculation on 2 columns, one for pre-planned start date and time and the other one is post planned finish date and time.

     

    I’m not that experienced enough, however I’ve taken your advice to watched the delegations created by @RezaDorrani but I have not been lucky enough to resolve the delegation on my App. still trying my best to understand if there is a way round this through the different type of scenarios he has covered. 

    At the moment, I’m deleting post data in my SharePoint list to allow for current day to be upload in to Power Apps.

    Any help or advise is very much appreciated.

    Thank you   

  • EddieE Profile Picture
    EddieE 4,650 Moderator on at

    @Moe69 

    Ok, so normally you’d use the DateDiff() function to do time calcs but I don’t think it’s delegable. Also, I don’t think simple time calcs, like the ones you are using are delegable either? Not sure, I’d have to test that.

     

    If you need to do these calcs and the MAX number of records you need to do them is <2000 you can increase the records limit to 2000 in the Settings and just leave the formula as is. If you need more than 2000 records I think you’ll have to think differently about how you data is structured to achieve what you need

  • Moe69 Profile Picture
    Moe69 on at

    Hi EddieE,

    Thank you for your feedback, I will increase to 2000, however, it just means that I will need to delete data to allow for current week to be uploaded.

    But, if you do work the formula out, please, please do get in touch.

    Appreciate your support and advise

     

    Thank you  

  • cwebb365 Profile Picture
    cwebb365 3,300 Most Valuable Professional on at

    So you can't do datediff / add etc. to SharePoint dates with delegation but instead of doing the calculation that way, just do it on the other end? So instead of 

    'Part 1 Planned Start Time' - 0.5 < Now() do:  'Part 1 Planned Start Time' < Now() + 0.5 

    This essentially is the same thing, and you can do the calculation on that side of the condition. 

     

    Also instead of doing +0.5 it's easier to understand using DateAdd(), so if you want 30 minutes do
     'Part 1 Planned Start Time' < DateAdd(Now(),30,Minutes)  

    'Part 1 Planned Finish Time' > DateAdd(Now(),-15,Minutes)

     

    Easier to read and understand etc. I think this should get what you're looking for. 

  • EddieE Profile Picture
    EddieE 4,650 Moderator on at

    @Moe69 

    Well done to @cwebb365 , he has solved your delegation issue for you. I must admit, I haven't read over the MS Delegation docs for awhile and was also typing my answers late at night on my phone without checking said Docs - hence I was a little out of practice! It's nice be schooled and re-learn what has been lost 🙂

     

    The reason this works is because you are sending a constant (ie DateAdd( Now(), 30, Minutes) ) to SharePoint instead of trying to do some maths on a column value (ie a Date value) which isn't delegable. The part in the Delegation docs where this is mentioned is here, which states:

     

    You can also use portions of your formula that evaluate to a constant value for all records. For example, Left( Language(), 2 ), Date( 2019, 3, 31 ), and Today() don't depend on any columns of the record and, therefore, return the same value for all records. These values can be sent to the data source as a constant and won't block delegation.

     

    You can also check if this formula will return all of your required records by changing the Data Row Limit in Settings to 1. Then if more than 1 record should be returned then you will see all of the records in your gallery, if the formula works - just another good tip.

     

    So, your full working formula looks like:

    Sort(
 Filter(
 yourListName,
 Column1NameStatus.Value = "Published" &&
 'Part 1 Planned Start Time' < DateAdd( Now(), 30, Minutes) &&
 'Part 1 Planned Finish Time' > DateAdd( Now(), -15, Minutes)
 ),
 'Part 1 Planned Start Time',
 Ascending
)

     

    Thanks to @cwebb365 for getting me to do some homework 🙂 

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Welcome to the Power Platform Communities

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 358 Most Valuable Professional

#2
11manish Profile Picture

11manish 214 Super User 2026 Season 2

#3
Mohsin Ali Profile Picture

Mohsin Ali 185

Last 30 days Overall leaderboard

Featured topics

Auto-Populate field Power Pages
Gallery Tabs - Show or Hide Tabs based on Field Value
How to patch multiple records at once
Enable Copilot for end users in model-driven apps
Question for everyone : How are you using Create Text GPT in AI Builder?
Community content - sample components, blogs etc. - Link to this page (http://aka.ms/PCFdemos)
Welcome to the Power Apps forum!

Product updates

Microsoft Power Platform Community release plans