Showing results for 
Search instead for 
Did you mean: 
Helper II
Helper II

How to change the datetime format to just have date for conditions in powerautomate

Hi Guys,

I am trying to create a flow that reminds the owner of the order (Dynamics 365) by using a date time field, however the date time field is showing time. I would explain the flow that I created below (I am not sure if this is the correct way that I did it or if there are more optimal ways to go with this problem) 


I first initialized a variable that would get the time now and add an additional 7 days to it.




and then afterwards i used a list record which gives out active orders. (This is the part where I think i can improve it by using a filter query to just check the datetime field that would be coming up in the next 7 days only however I do not know the exact query to use)




After getting the list I use this condition where it uses the variable i initialized at the start to check for the datetime field however due to it being a date time field its not matching, i checked it using a compose and it showed up like this.



Below you could see that the datetime field has time on it as well, i was wondering how i could just leave the date field on it.



Or if you have better ideas to make it more optimized like just adding something on the filter query to prevent listing a lot of active orders that would be the best. Thanks guys


Impactful Individual
Impactful Individual

Could you share a screen shot of your complete  flow.
I believe you can use a compose to return the date only but need to see your flow so i can see its structure and where it would go

Helpful resources

Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Users online (5,427)