Hi there... I"m trying to build a flow that would step through a sharepoint list using the "filter by" data.
I have a screenshot below of what I am trying to do. If I select "filter by" on the sharepoint list, I get a list of possible filter choices. I want to use that list of choices in a flow to process the data. Is there an easy way to get this list?
Solved! Go to Solution.
I tried a bit and this worked for me:
You have to create a list view with only the column, you want to have the values from (e.g. just "Title" like you want it)
Then you have to check, if the array already contains the value. If not, you write this value into the array.
If the value already exists, it will skip.
Before:
After:
the compose is just to display the entries of the array
Hope this helps 🙂
Best regards,
André
If you get the list of all the values into an array you can use the Union expression to just get the unique values which would be the same as the list you get in the filter by in SharePoint.
I tried a bit and this worked for me:
You have to create a list view with only the column, you want to have the values from (e.g. just "Title" like you want it)
Then you have to check, if the array already contains the value. If not, you write this value into the array.
If the value already exists, it will skip.
Before:
After:
the compose is just to display the entries of the array
Hope this helps 🙂
Best regards,
André
This is awesome! I wil try this tonight.
it works great but those fields I want to filter are LookUP fields and they are not showing up.....smh.... Interesting the view i set up only contained the column of lookup fields, and that listview wasn't showing up as one of the options on the flow.
Thank you for this.
User | Count |
---|---|
88 | |
43 | |
21 | |
18 | |
16 |
User | Count |
---|---|
132 | |
47 | |
42 | |
36 | |
28 |