I was wondering if there is a better way to read items in a list from SharePoint.
Currently I am reading list data in a Gallery
If(CountRows(BrowseGallery1.AllItems) >= 30, Navigate(fullScreen), !IsBlank(LookUp(WorkshopList_1, Title = User().FullName)), Navigate(existScreen), CountRows(BrowseGallery1.AllItems) < 30, Navigate(firstDate))
Unfortunately, even when the list is over 30 items it will still navigate to the firstDate screen.
Could anyone shed some light on this for me please?
Solved! Go to Solution.
I'm sure I received an error when I used the same formula above, i will double check tomorrow morning and revert back to you as soon as possible!
Thank you for the support, I really do appreciate it!
You most likely saw a delegation warning, as CountRows is not delegable. However, given the context of what you are looking for, the delegation can be ignored.
Let me know what you discover. Happy to help!
Apologies for the late response. I can confirm the formula you provided works a treat! Just hoping the delegation warning doesn't become too severe in the long run. I appreciate the assistance, thank you for your help!
Yes I had specifically mentioned "given the context of what you are looking for, the delegation can be ignored."
That was intentional because the delegation warning will never cause you an issue with that formula.
You are specifically testing to see if the list count is over 30. As long as your record limit on your App is over 30, then this will always be accurate. The same goes for the comparison to being less than 30.
If you has some sort of filtering going on, then I would say it is a concern, but with those low numbers even if you had 1 million records, it would then simply compare to being more than 30.
The Lookup portion of the formula is delegable for the second condition of your If statement, so that will not be an issue either.
@RandyHayes I will keep that in mind and take note for future reference. I read up about it but your explanation is definitely easier to understand. Thank you so much!
Happy to help!
Learn how to create your own user groups today!
Check out the new Power Platform Community Connections gallery!
Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.