Hi,
Long time lurker, first time poster. Thank you all who help people struggling, your comments and asisstance has helped me so many times already.
For the last few days I have tried so many things to get an extract from a SharePoint list to an excel file, while filtering rows away that contains data. It works fine in my test list but when changing from test data to live data it stops filtering at all.
The test data contains only 2 lines and the following array will filter that perfectly, but whenever I switch to the production list with approx. 500 lines, where 200 should be filtered away, it provides the full list without applying the filter. The flows both look the same but I fail to see if there are limitations to filter arrays or if I can do it in a smarter way. I have looked into filtering already in the Get Items Filter Query but I struggle to find a format for the query in which it only keeps the rows where 'Exitdate' is empty.
What am I missing?
Image: Working test flow
Image: Not working production flow
Any help is much appreciated!
Sincerely
John
