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.
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.
At the monthly call, connect with other leaders and find out how community makes your experience even better.
If you are a small business ISV/Reseller, share your thoughts with our research team.