Forum Discussion
YvonneP
Dec 15, 2021Copper Contributor
SharePoint List Filter - and/or condition? Search box?
the users wish for and/or filter conditions to apply on a SharePoint list.
Example Filter-search 1 (multiple columns connected with 'or': Either column "Active" can be set on "yes" or column "Priority" has to be set on "high".
Example Filter-search 2 (choice column): In the multiple choice column "drinks" we need to search for entries with both "Cola" and "water".
Is there anyway to achieve this and still directly work in the list view?
All solutions I found yet are within PowerApps. This is unfortunate since it was requested to keep the same list view with the feautures it has now, and because we have above 500 entries.
Bonus would be a search box, in addition to the other filter options.
Example Filter-search 1 (multiple columns connected with 'or': Either column "Active" can be set on "yes" or column "Priority" has to be set on "high".
Example Filter-search 2 (choice column): In the multiple choice column "drinks" we need to search for entries with both "Cola" and "water".
Is there anyway to achieve this and still directly work in the list view?
All solutions I found yet are within PowerApps. This is unfortunate since it was requested to keep the same list view with the feautures it has now, and because we have above 500 entries.
Bonus would be a search box, in addition to the other filter options.
No RepliesBe the first to reply