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