I have built a Flow that copies Items, that are older than 30 days, from one SharePoint list to another and then deletes the Items from the original list. Problem is the dates in the SharePoint list are in UK format (mm-dd-yyyy). I had initial problems using the following formula as a filter query: addDays(utcnow('mm-dd-yyyy'),-30) so after lots of searching around I thought I stumbled on a solution using this formula instead:
addDays(converttimezone(utcnow(),'UTC','W. Europe Standard Time','dd/mm/yyyy HH:mm),-30)
When I run the Flow I receive no error but the date filter appears to be getting ignored and 100 items are coped and deleted at a time despite the items being within the 30 period.