web

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

News and Announcements icon

Power Platform CommunityForums Power Automate Retreiving the date a ...

Power Automate

Answered

Retreiving the date a microsoft form was submitted

(2) Share

Report

Report

Posted on by JS-22051149-0

24

I've a form that captures issues that need addressing, what I want to be able to do though is to retreive the date the form was submitted and then be able to add it into the spreadsheet. What function would I best using?

Categories:

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (0)

Sort by

Suggested answer

Valantis 6,735 on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @JS-22051149-0,

The submission date is available directly from the Forms trigger in Power Automate. No extra function needed.

In your flow, after the trigger "When a new response is submitted" and "Get response details", the submission timestamp is in the field:

triggerOutputs()?['body/submitDate']
Or you can use the expression:
formatDateTime(triggerOutputs()?['body/submitDate'], 'dd/MM/yyyy HH:mm')
to format it however you want before writing to Excel.
If you want just the date without time:
formatDateTime(triggerOutputs()?['body/submitDate'], 'dd/MM/yyyy')

Add this as a column value in your Add a row into a table (Excel) action and it will write the submission date for every new form entry.

Best regards,

Valantis

✅ If this helped solve your issue, please Accept as Solution so others can find it quickly.

❤️ If it didn’t fully solve it but was still useful, please click “Yes” on “Was this reply helpful?” or leave a Like :).

🏷️ For follow-ups @Valantis.

📝 https://valantisond365.com/

💼 LinkedIn

▶️ YouTube

Was this reply helpful? Yes No
Suggested answer

Kalathiya 2,456 Super User 2026 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!
Hello @JS-22051149-0,

You can use the form submission date from Power Automate and map it into your spreadsheet.
In MS Form action, “Get response details” action already includes the submit date/time. Then just add that field into your Excel row.

or you can use.

You can use the current date and time expression as well. Since the form submission triggers the Power Automate flow, referring to the current date/time will also work.

Put below in expression.

formatDateTime(utcNow(),'MM/dd/yyyy hh:mm:ss')

---------------------------------------------------------------------------

Glad it helped 🙂
If this fixed your issue, please click “Does this answer your question?” to mark it as verified so others can find the solution easily.
A Like 👍 is always appreciated, and I’m around if you need more help @Kalathiya

Was this reply helpful? Yes No

Join the conversation