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.
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
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