Answered

Use date from Microsoft Forms -14 days

(0) Share

Report

Posted on by VentureG

Hello all,

I would like to create a Flow when submitting a form it sends a message to a shared mailbox and look if the data is in the time range of 14 days. If it is true, it has to send a message to the responder.

Sending the message to a shared mailbox is working, but i cant get the 14 days working.

Currently i have:

- If form date is equal or greater then now and 14 days (formatDateTime(addDays(utcNow(),-14),'yyyy-MM-dd'))

- if form date is equal of less then now (formatDateTime(utcNow(),'yyyy-MM-dd'))

What i am doing wrong?

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Verified answer

yashag2255 24,769 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi @VentureG

To compare the date and time type datatype it is advised to use the "ticks()" function So in your condition, in the left input, type ticks() and within the brackets select the item from the dynamic data selector and in the right one just wrap your formatdatetime function in the ticks function (like this-> ticks(formatdatetime(..)))

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!

Was this reply helpful? Yes No
VentureG 4 on at

Like (0)

Report
Copy link

Link copied!

After posting this message i found an other way to solve my own problem.

I created a "add by time" with the current day and + 14 days. The output of that i used to check the form date.

Was this reply helpful? Yes No
yashag2255 24,769 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi @VentureG

Yes! That works too. But wrap them in the ticks() function for the appropriate comparision of the date and time type.

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!

Was this reply helpful? Yes No