Unanswered

Flow to Record Microsoft Forms Response in SharePoint

(0) Share

Report

Posted on by Janelle_856

When the responses from Forms is exported into Excel there are "Start Time" and "Completion Time" columns. My question is, what dynamic content or expression should I use for getting the "Completion Time" so that the response from Forms can be recorded to the SharePoint list. I am using Submission Time as the dynamic content for the "Start Time" Column.

Microsoft Form Results exported to Excel

Power Automate Flow

Categories:

General topics

All responses (3)

Answers (0)

Sort by

RobElliott 10,539 Super User 2026 Season 2 on at

Like
a
(0)

Report
Copy link

Link copied!

@Janelle_856 Completion time is not made available to the flow. The closes you could get to it - though it wouldn't be exact is to use an expression of utcNow().

Rob
Los Gallardos
If I've answered your question or solved your problem, please mark this question as answered. This helps others who have the same question find a solution quickly via the forum search. If you liked my response, please consider giving it a thumbs up. Thanks.
Janelle_856 5 on at

Like
a
(0)

Report
Copy link

Link copied!

@RobElliott sorry for the delay but thanks for answering my question. I figured completion time was not made for the flow. Thanks for the suggestion I'll keep it in mind for you future.
PP4Sharon 31 on at

Like
a
(0)

Report
Copy link

Link copied!

@RobElliott I have a similar situation. I have a form and I'm exporting to an SP list. I need it to filter on [Today]. When it was created [Today] the value in the created field is 5 hours ago. How do I put that in a flow to be a variable using 'formatDateTime(utcNow(),'MM-dd-yyyy')'