web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Automate Calculating the submis...

Power Automate

Unanswered

Calculating the submission time of a Form is 24 hours or less from date selected

(0) Share

Report

Report

Posted on by Doby

2

I need help with a flow to calculate the time of submission from the date selected in a form. The flow sends an email to the respondent based on the date selected inside the form. For example, if the time of submission and date selected is 24 hours or less they would receive email #1, but if the time of submission and date selected is greater than 24 hours then they would receive email #2. I am new to Power Flow and I don't have any screenshots to share yet.

Categories:

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (0)

yashkamdar 1,044 on at

Like (0)

Report
Copy link

Link copied!
Hello Team,

Here is how you achieve this.

Here is a simple form I created just so I can show you the solution -

I have a simple date picker in this.

My flow-

Step 1 and 2 - When a new response is submitted, get response details (self explanatory)

Step 3 - Condition to check if submission date is equal to today's date

formatDateTime(outputs('Get_response_details')?['body/submitDate'],'yyyy-MM-dd') is equal to Date to be compared against submission

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
Doby 2 on at

Like (0)

Report
Copy link

Link copied!

Thanks, I tried what you suggested but getting an error message: The template language function 'formatDateTime' expects its first parameter to be of type string. The provided value is of type 'Null'

Was this reply helpful? Yes No

Join the conversation