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 !
Solved! Go to 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 !
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 ๐
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 !
Check out new user group experience and if you are a leader please create your group
See the latest Power Automate innovations, updates, and demos from the Microsoft Business Applications Launch Event.
User | Count |
---|---|
2 | |
1 | |
1 | |
1 | |
1 |
User | Count |
---|---|
3 | |
3 | |
3 | |
2 | |
2 |