Power Platform Community Forum Thread Details

Hi,

I have a List with a field_16 = a date which in my List Settings Regional Setup (English) - looks like this "13/05/2026" - (thirteenth of May twenty twenty six), 'dd/MM/yyyy'

Row field_16

1 13/05/2026

2 09/05/2026

OK, so i was following a Tutorial online to create an Autoamted Cloud Flow and send an EMail when I am 7 days before the field_16 date, and it worked fine, but now it doesnt?

Bad Request - Status Code 400

It says my Filter <$filter field16 eq '13/05/2026'> - String was not recognized as a valid DateTime

I've read plenty of threads on this, and I get that SharePoint formats are not the same to how I see them as I have applied Regional Settings and looking for some more useful help, as YouTube videos are either partially helpful or simply off the scale for a newbie like me.

The tutorial I followed indicated I create an "Initialise Variable" -

Name var7B4Next

Type - String

Value - addDays(utcNow(),7,'dd/MM/yyyy')

that was easy to understand - all good so far,

Then I Get Items with a Filter Query, selecting the List from my Site

field_16 eq '@{variables('var7B4Next')}'

This is where I get the error.

Any help would be great, thanks, Simon.

Categories:

Power Automate Desktop

@SW-06050322-0

The error occurs because SharePoint displays the date in regional format (`dd/MM/yyyy` like `13/05/2026`), but Power Automate filter queries require the internal ISO DateTime format*. So comparing `field_16 eq '13/05/2026'` fails because SharePoint does not recognize it as a valid DateTime.

Update your variable to use ISO format instead of display format:

formatDateTime(addDays(utcNow(),7),'yyyy-MM-ddT00:00:00Z')

Then use it in the filter query like this:

field_16 eq '@{variables('var7B4Next')}'

Vishnu WR

LinkedIn - My Tech Space

Please ✅ Does this answer your question if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider answering Yes to Was this reply helpful? or give it a Like ♥