Showing results for 
Search instead for 
Did you mean: 
Frequent Visitor

Filtering Sharepoint Online column do not work correctly

Hi guys,



One of column in my Sharpoint Online list is Country, this column is fulfilled with values like: "Italy", "Italy;Spain", "China;Italy;Poland", etc. In PowerApps I use following formula to show items in gallery:
Filter(SharepointList, ComboBox.Selected.Value in Country)
ComboBox has values: Italy, Spain, Poland, etc.


It works fine if at least one item on my Sharepoint List is simple "Italy", then when I choose "Italy" from ComboBox it shows all Sharepoint items which contain this word but if Sharepoint list have got only items "Italy;Spain" or "China;Italy;Poland" and I choose from ComboBox "Italy", it doesn't find any result.


Am I doing something wrong or this is bug?

Super User III
Super User III


What type of Column is 'Country' in SharePoint: Choices or Single-Line Text?


Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

The column is a Single line of text.

Helper V
Helper V

To resolve this issue, reduce the number of items in the view for the affected list or library to 5,000 items or less. To do this, take one of the following actions, as appropriate for your situation:

Create a new view for the list or library or change the existing view. When you do this, use indexed columns and filtering to keep the view size for the list to 5,000 items or less. For more information about how to create a filtered view that has a column index, go to Manage large lists and libraries in SharePoint migration.

Note: The list limit to add or remove an indexed column is 20,000 items.

Create folders in the library, and put items in the folders to keep the view for the library to 5,000 items or less.

Helper V
Helper V

It’s a known issue in SharePoint.

To work around the problem, you can edit the list view web part in the page > Miscellaneous > check the “Server Render” option.


I hope you find this helpful.



I will try and let you know.

I must have missed something in this conversation?  How many items does your list have?

My list contain about 650 items. I will try second advise from @Max44 


I would make a different suggestion.  Change the properties of your ComboBox to these.






["France", "Italy", "Spain"]


Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."


I cannot find "Server Render" option, neither Miscellaneous tab/menu. I use Modern View sharepoint. Can advise how to navigate to this option?

I tried your suggestion but it says it is not valid, looks like problem is "This.Item.Country" in Split function. Error - "The function Split has some invalid arguments".

Helpful resources

News & Announcements

Community Blog

Stay up tp date on the latest blogs and activities in the community News & Announcements.

Power Apps Community Call

Power Apps Community Call- January

Mark your calendars and join us for the next Power Apps Community Call on January 20th, 8a PST

PP Bootcamp Carousel

Global Power Platform Bootcamp

Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.


Power Platform Community Conference On Demand

Watch Nick Doelman's session from the 2020 Power Platform Community Conference on demand!

Top Solution Authors
Top Kudoed Authors
Users online (3,630)