I've setup a flow to go through a SharePoint list and delete items from it where a column called "End_Date" is less than today's date. The flow uses Get Items to find the List, and filter out End_Date values using an expression (all shown in the photo attached).
The trouble is, it can't find the column. I've tried pointing it to another column (Start_Date), and it works. I've tried re-ordering the columns in the SharePoint list incase it scans the column names alphabetically.
Has anyone else experienced this happening?
Solved! Go to Solution.
Did the column exist before you added the Get Items to the Flow? Try removing the Get items action and anything else that uses the SharePoint connector. Then re-add it into the Flow. Also, make sure that the All Items view has the column you want included in the view.
If End Date is a calculated column then that is the issue - you won't be able to use a calculated column in the OData filter.
As a work around, you can re-create the calculation in your Flow. For example, if the calculation for end date -s the starte date plus 30 days, take that into account in the expression in your filter.
If you need an example, please let me know.
The column did exist before setting up the flow. I checked the All Items view, and it's definitely in there (the photo in the OP shows the all items view). I've just re-created the flow from scratch and it's failed again
The column isn't calculated in Sharepoint. It's automatically added to the List from a separate Flow that takes data calculated in an excel spreadsheet.
The duration between the start and end dates isn't consistent either - so using a calculation in the expression (i.e. Start Date-30) wouldn't be as practicable.
Check out the winners of the recent 'Can You Solve These?' community challenge!
Join us for an in-depth look at the new Power Automate features and capabilities at the free Microsoft Business Applications Launch Event.
Features releasing from October 2020 through March 2021
Fill out a quick form to claim your user group badge now!