Choice field filter not working on large SP list

Like (1) Share

Report

Posted on 7 Dec 2017 05:33:24 by greggdavenport

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)"

Categories:

Connecting to Data

General Questions

I have the same question (0)

All responses (5)

Answers (0)

SergioGiusti1 5 on 06 Feb 2018 at 16:42:45

Like (0)

Report

Re: Choice field filter not working on large SP list

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

Was this reply helpful? Yes No
SergioGiusti1 5 on 06 Feb 2018 at 16:34:28

Like (0)

Report

Re: Choice field filter not working on large SP list

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

Was this reply helpful? Yes No
greggdavenport 55 on 12 Dec 2017 at 07:20:52

Like (0)

Report

Re: Choice field filter not working on large SP list

Thank you very much Michael and Meneghino
Gregg

Was this reply helpful? Yes No
v-micsh-msft on 08 Dec 2017 at 09:40:14

Like (0)

Report

Re: Choice field filter not working on large SP list

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

Was this reply helpful? Yes No
Meneghino 6,949 on 07 Dec 2017 at 08:03:14

Like (0)

Report

Re: Choice field filter not working on large SP list

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/

Was this reply helpful? Yes No