With Sharepoint being such a popular database tool to use with PowerApps I'm suprised to keep finding functions that are not supported/delegated in Sharepoint for PowerApps.
The delegations that I would find most helpful would be the "<" ">" "=>" "=<" "in" "not"
DateValue would also be very helpful for me, but not necessarily an essential feature.
I'm sure this is not a unique idea, but I really think this should (if not already) be pursued soon as it is essential for most PowerApps users using Sharepoint.
We appreciate your votes and feedback on this topic. We are working to improve experiences where delegation is a factor. We appreciate your patience as we extend capabilities with non-delegatable data sources.
It's been 5 months since I posted this, and I've been sad to still see that I am limited to 500 items because of lack of delegation. I am having to create a Flow to delete my older items when the list count reaches 450, and this is not a great solution since I'd like to be able to use the data for analytics.
I completely agree with you. I am very surprised that SQL Server gets a lot more delegation support than SharePoint lists, as SharePoint lists are far more prevelent for the types of applications likely to use PowerApps. My app included various counts of records, however I have about 4000 records. My workaround was to create a separate SP list to store the counts and a lot of logic in PowerApps to capture events where the counts need to be incremented or decremented, which makes it difficult to maintain and also slows down the performance of the app (due to Patch and refresh).
I would like to see delegation for "in".
Can we get an update on the status of IN and SEARCH delegation? Really needing this as the absence makes working with SharePoint lists less than "low code".
I'd like to see < <= > >= supported on the ID column.