OData Filter SP items on Date = Today +1

[Gaëlle]

Hell othere 🙂

I need a little help on a flow :

I try to get SP Items from a list, but i would like to filter them (with a OData query) as follow :

DepartureDate eq Today+1Day

I wrote the following :

But my flow is getting an empty value because my Date is not written well, and the UTCnow seems not  to work (it should give 02/07/2018, and certainly not 03/23/2018):

Should i use the "FormatDateTIme"  expression ?

Coud you help me on this please ?

Thanks a lot 🙂

Thanks a lot !

[Gaëlle]

A little up on this,

I found how to format my utcNow date correctly :

addDays(utcNow(),1,'dd/MM/yyyy') 

gives me 03/07/2018, which is okay.

But with DepartureDate eq addDays(utcNow(),1,'dd/MM/yyyy'), there is no items shown, even if i've set all my Items' DepartureDates to 03/07/2018.

I tried with

items()?['DepartureDate'] eq 'addDays(utcNow(),1,'dd/MM/yyyy')'

but flow says that my expression is not valid.

Please help me on this 😉

[Gaëlle · Accepted solution]

Annnd Done !

Finally I could get it right !

DepartureDate eq 'addDays(utcNow(),1,'yyyy-MM-dd')'

The addDays expression has to be written in the Expressions panel or it won't really be valid.

It is working now, YAY !