web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Form saves response as...
Power Automate
Answered

Form saves response as yyyy/mm/dd when entered as mm/dd/yyyy? Get rid of brackets and quotes?

(4) ShareShare
ReportReport
Posted on by 11
I'm trying to build a flow that uses a form that asks for today's date, the name of a student, their campus, the fundings, the effective date on the fundings, and a multiple choice for the current services of the student. The issue is that when a form is filled out, the dates are displayed as yyyy/mm/dd despite the fact that it was entered into the system as mm/dd/yyyy, and it keeps this issue when the flow sends all of the information as an email. Does anyone know how to fix this?

I also am trying to fix an issue with the multiple-choice question displaying brackets and double quotes. My main question is where do I find the question ID? I need that in order to run the function in a compose action that I've seen other solutions try and all mention succeeding with. Thank you in advance
Screenshot 2024-08-20 150423.png
Screenshot 2024-08-20 151027.png
Categories:
I have the same question (0)
  • Verified answer
    trice602 Profile Picture
    16,363 Super User 2026 Season 1 on at
    Hi,
     
    You can change the format of the displayed date, such as in an email, by using a quick compose action and using the formatDateTime() expression.
     
     
     
    One other thing to consider, the next time you update your Form, is to consider dropping the Today's date question all-together.  That's because the submitted date is automatically captured for you and you can just refer to the submission date as "today's date".  I will provide that example below.
     
    In general terms, I try to eliminate questions that are already collected by the form.  Regardless, I hope I helped you out tonight!
     
     
     
    To answer your second question, you get the question dynamic content by using the action "Get response details" and use the ID from the trigger.  This will give you the dynamic content for your questions (see my examples above).
     
     
    ------------------------------------------------


    If this was helpful, please like and/or mark as a verified answer to help others find this too!


    Always glad to help! 💯💯💯💯💯

    Tom 

    Follow me on LinkedIn - Thomas Rice, PMP | LinkedIn

     

     
     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
David_MA Profile Picture

David_MA 267 Super User 2026 Season 1

#2
11manish Profile Picture

11manish 196

#3
Haque Profile Picture

Haque 182

Last 30 days Overall leaderboard