Forum Discussion
slicer filter based on metadata numbers
Perhaps a simple question, but I can't find to much information about it.
I have a document library with 2 extra metadata columns (Height - numerical between 1 and 10000 / Length - numerical between 1 and 10000). Is there a way to do a filter for a range of those numbers. Similar to the default date filter (modified since slicer from first date untill today)
Height : 1-------------------------------- 10000
Length: 1 -------------------------------- 10000
The default filter I have now just gives me checkboxes for the different values added to the document
To be clear: I would like a filter similar to the date filter for the length/height column based on the numerical values.
1 Reply
- You could add another column that has the range as text that you calculate using Flow. You then filter on the range text rather than the number. The Flow would be on item created and use an expression on the number to calculate which range it was in, or maybe an array and use a filter, then update the item field with the text.
