Get Items Filter Query Not Working - UK Dates

(0) Share

Report

Posted on by Community Power Pla...

Hi,

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.

Any help much appreciated

thanks

Mike

All responses (2)

Answers (1)

Community Power Pla... on at

Like (1)

Report

Re: Get Items Filter Query Not Working - UK Dates

Thanks ABM,

I tried a slight variation of your formula: addDays(formatDateTime(utcNow(),'MM-dd-yyyy'),-30)
and it works

many thanks!

Mike
Verified answer

abm abm 32,506 Most Valuable Professional on at

Like (0)

Report

Re: Get Items Filter Query Not Working - UK Dates

Hi @Anonymous

Try this expression

addDays(formatDateTime(utcnow(), 'yyyy-MM-dd'),-30)

Thanks