Delegation Warning

Hi @cwebb365 and @EddieE 

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?

Hi @cwebb365 and @EddieE 

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.