Forum Discussion
ikarafi
Jun 20, 2023Copper Contributor
How to filter based on Colour in sharepoint
Hi,
I want to filter based on colour 'red' in sharepoint but the filter option is only available for dates only. Kindly please help.
ikarafi Unfortunately, you cannot filter based on color which is applied using JSON formatting.
SharePoint JSON formatting only customizes how columns in SharePoint lists and libraries are displayed, it does not store any value/information (color) in list.
So, you cannot filter the list items based on colors/values added using conditional JSON formatting.
You have to apply the same logic you used for JSON formatting in your list view filter settings. Follow documentation: Use filtering to modify a SharePoint view
Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.