Unanswered

Filtering Sharepoint Online column do not work correctly

(0) Share

Report

Posted on by Community Power Pla...

Hi guys,

Background

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.

Issue

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?

Categories:

Building Power Apps

I have the same question (0)

All responses (9)

Answers (0)

mdevaney 29,989 Moderator on at

Like (0)

Report

@Anonymous

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

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

The column is a Single line of text.

Was this reply helpful? Yes No
Max44 223 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Max44 223 on at

Like (0)

Report

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.
Admin
Apps4rent

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

I will try and let you know.

Was this reply helpful? Yes No
mdevaney 29,989 Moderator on at

Like (0)

Report

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

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

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

Was this reply helpful? Yes No
mdevaney 29,989 Moderator on at

Like (0)

Report
@Anonymous

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

DefaultSelectedItems

RenameColumns(Split(ThisItem.Country,";"),"Result","Value")

Items

["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."

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

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

@mdevaney
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".

Was this reply helpful? Yes No