Forum Discussion
Delegation Warning
Thank you both for responding back, much appreciated and well done to you both for sorting my delegation out š
The formula does work perfectly with data row limit set to 1 which is exactly what I wanted and delegation has now disappeared.
However, is the formula limited to how many times it can be used or written? I have 13 item to select from in the Column1NameStatus.Value ie I have 13 item to select from in (1) āPublishedā, (2) āLateā, (3) āNot Arrivedā (4) āArrived Lateā (5) āDepartedā and so on, when the formula get written 7 times, its okay but after this point it goes in to an error where the warning states that I donāt have permission to use the Gallery!!
Any idea why or advice please?
Thank you both for responding back, much appreciated and well done to you both for sorting my delegation out š
The formula does work perfectly with data row limit set to 1 which is exactly what I wanted and delegation has now disappeared.
However, is the formula limited to how many times it can be used or written? I have 13 item to select from in the Column1NameStatus.Value ie I have 13 item to select from in (1) āPublishedā, (2) āLateā, (3) āNot Arrivedā (4) āArrived Lateā (5) āDepartedā and so on, when the formula get written 7 times, its okay but after this point it goes in to an error where the warning states that I donāt have permission to use the Gallery!!
Any idea why or advice please?
@EddieE ,
When I add another selection from my choice value to the Item formula, I get the following message , I don't have permission to view this data. Server Response: The Name of My List failed, the response is not in a JSON format.
Not a problem any longer, as you advised, Iāve added a dropdown to my gallery and it works perfectly, I will continue to monitor the new formula and hopefully I can cross this one of the list of things to do.
Well done and thank you so much for your time, very much appreciated your help and advice. Brilliant keep up the good work you provide.
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()
),
'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.
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.
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.
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.
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