I've created a form (which can be filled out by anyone with the link), when I open the Responses Excel it shows the start and completion time.
I also created a cloud flow to send an email for every response to certain email addresses, but in the "Dynamic content" list, there isn't an option to add the Submission Time, Start Time or Completion Time to the email.
In other flows, this option does show up in the "dynamic content" list (like in the screenshot below).
I would like to add the submission date to my email, because sometimes flows don't work and I have to manually resend an email.
In that case, the time that the email was send isn't the date and time the form has been filled in.
Can anyone tell my why this option isn't showing up in de "dynamic content" list and is there any way to fix this?
Thanks!
Hi @Anonymous
Sometimes dynamic content lists get prefiltered based on the field type you are trying to add them to.
In this situation it could be possible if you would add a separate compose action into to flow the submission date would suddenly show up.
That being said, a workaround could be to just use an expression to add this field instead:
outputs('Get_response_details')?['body/submitDate']
WarrenBelz
146,660
Most Valuable Professional
RandyHayes
76,287
Super User 2024 Season 1
Pstork1
66,004
Most Valuable Professional