cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Muni1996
Helper I
Helper I

Flow with Date Condition

community.png

 

Hello!

 

When the "submission" date is one day over, then an e-mail should be sent. How do I have to build the condition.

I can switch Sharepoint to english if its necessary.

Thanks.

 

 

1 ACCEPTED SOLUTION

Accepted Solutions

Hi @Muni1996 

 

You can try this condition:testa.PNGThe expression used is:

formatDateTime(addDays(utcNow(),1),'yyyy-MM-dd')

The date and time formt of the sharepoint column is yyyy-MM-dd and so I am adding a day to the current day of the flow run and checking if the submission is greater than that. But I do not understand why you would want to compare something with tomorrow? So if you have any other date you want to compare to, you can use the add days function to add days to that date and format it using the format date time function. 

 

Hope this helps!

 

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

View solution in original post

4 REPLIES 4

Hi @Muni1996 

 

You can try this condition:testa.PNGThe expression used is:

formatDateTime(addDays(utcNow(),1),'yyyy-MM-dd')

The date and time formt of the sharepoint column is yyyy-MM-dd and so I am adding a day to the current day of the flow run and checking if the submission is greater than that. But I do not understand why you would want to compare something with tomorrow? So if you have any other date you want to compare to, you can use the add days function to add days to that date and format it using the format date time function. 

 

Hope this helps!

 

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

ScottShearer
Super User
Super User

@Muni1996 

I agree with @yashag2255 - his solution will address your issue.

That said, a much better and more efficient way to approach your issue would be to use a filter query in the get items action.  That way, only the items that meet your condition will be returned - no need for a condition.  You would use the same concept in the filter as was presented by @yashag2255 .

Here is a link to a blog post that will walk you through creating the filter query.

 

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Scott
v-alzhan-msft
Community Support
Community Support

Hi @Muni1996 ,

 

Please refer to @yashag2255 's expression for the condition and it would help your achieve your requirement.

 

Best regards,

Alice       

 

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

PPG-Ezra
Helper I
Helper I

@yashag2255 thank you.... your formula worked well for me. 

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

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

Community Calls Conversations

Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Users online (4,544)