Announcements
Hello everyone,
This article says that I should be able to filter a large SharePoint list with an indexed Choice field: https://powerapps.microsoft.com/en-us/blog/powerapps-now-supports-working-with-more-than-256-items-in-sharepoint-lists/
However, I get the bluedot suggestions every time, and I am not seeing all of my items. Why does the article say: "SharePoint connector now supports “equals” type of queries on columns that support filtering (Single line of text, choice, numbers, dates and people)"
If you can switch to Azure SQL Database you will never go back to SharePoint as a database:
https://baizini-it.com/blog/index.php/2017/08/29/powerapps-101-data-storage/
https://baizini-it.com/blog/index.php/2017/09/26/powerapps-and-azure-sql-database-101/
Hi @gdavenport,
Thanks for the feedback.
I have send the feedback from my side, I will post back if I got any response on this.
Regards,
Michael
Confirmed it is not working on lists with more than 500 items. Nor on lists with more than 2000 items (if youve increased the limit using the experimental features). Tested on a choice column, a calculated column pulling the choice column as text and doesnt work, if i move the values from a choice field into a text field then it works as expected.
Please resolve asap.
Thanks
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
WarrenBelz 305 Most Valuable Professional
11manish 212
Valantis 167
