Flow with Date Condition

[Muni1996]

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.

[yashag2255 · Accepted solution]

Hi @Muni1996 

You can try this condition:The 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]

@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.

[v-alzhan-msft]

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]

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