Contents
For example, to see all documents that were modified in the last 30 days, you can create a filter on the Date column that’s greater than or equal to [Today] – 30. To leave out the current day, set a second filter on the Date column to is less than [Today] and connect them with And. You can filter a SharePoint list that has a metadata column.
You can have up to 10 statements in a filter definition. When you’re done, select OK at the top or bottom of the page to save the view. The Edit View page closes and is replaced by the view you’ve defined. For a view to quickly filter through many items, the first column in the filter must be indexed.
Are there drawbacks to instant filter in SharePoint?
Drawback with the above instant filter is that there are more than 10,000 items in my list and I have setup the view to display items in set of 1000 and instant filter only search first 1000 items only so how am I to filter remaining items?
To answer your second question: no, you would do all the OData stuff in the first Get Items. I too have had issues with doing multiple criteria in the filter as And doesn’t seem to work well. On one of my flows I’ve got round it by doing the filter in the Get Items and then adding a Condition.
My data is a SharePoint list with 100 rows and 5 categories. On the first page of the app I have a button for each category. Each button applies a filter to the gallery on the next page, and then switches to it. The result is that the same gallery will always show 20 items, filtered according to which category you selected.
Change that step into this: Unfortunately, there’s not much informations available around performance tuning at the moment (here are some additional details: https://blog.crossjoin.co.uk/2016/11/20/referenced-queries-and-caching-in-power-bi-and-power-query/) If you liked my solution, please give it a thumbs up.
How to filter the current day in SharePoint?
To leave out the current day, set a second filter on the Date column to is less than [Today] and connect them with And. You can filter a SharePoint list that has a metadata column. Go to your list and select +Add column. Select More… choose the Managed Metadata radio button, and then select OK.
Do you need to index the first column in a filter?
For a view to quickly filter through many items, the first column in the filter must be indexed. Other columns you specify in the view filter may or may not be indexed, but the view does not use those indexes. The first column of the filter should return fewer items than the List View Threshold.