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.
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?
Firstly, go to your settings and update your Data row limit to 2000, setting it to 1 was just for testing purposes.
To manage your 13 items you don't need to change your Filter all that much and you are probably best adding a dropdown outside of your Gallery, like this
- add a Dropdown, rename it to suit your needs but I'll just use Dropdown1 in my code below. Set the Items property to
With( { localChoices: Choices(yourListName.Column1NameStatus) }, ForAll( Sequence(CountRows(localChoices)+1), { Value: If( Value = 1, "All", Last(FirstN( localChoices, Value-1)).Value)} ) )This technique gives you all available 13 items in a Dropdown with the added option of "All". This technique isn't mine by the way. It was brilliantly developed and offered by @RandyHayes in his YouTube video here. Randy explains why you do this in his video and it's basically to make the Dropdown options dynamic over time.
Your Gallery Items then becomes:
Sort( Filter( yourListName, (Dropdown1.Selected.Value = "All" || Column1NameStatus.Value = Dropdown1.Selected.Value) && 'Part 1 Planned Start Time' < DateAdd( Now(), 30, Minutes) && 'Part 1 Planned Finish Time' > DateAdd( Now(), -15, Minutes) ), 'Part 1 Planned Start Time', Ascending )Hopefully this suits your needs, let me know if the above needs any extra guidance.