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.
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Announcing a new way to share your feedback with the Power Automate Team.
Power Platform release plan for the 2022 release wave 2 describes all new features releasing from October 2022 through March 2023.
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
Join us for two optional days of workshops and a 3-day conference, you can choose from over 130 sessions in multiple tracks and 25 workshops.