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

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Flow for File duplicat...
Power Automate
Unanswered

Flow for File duplication and Data Extraction

(0) ShareShare
ReportReport
Posted on by

Hello,

 

I'm seeking guidance on automating a process using Power Automate. Specifically, I'm looking to create a flow where, upon completion of a Microsoft Forms submission, a copy of an existing Excel template is generated and the form data is extracted into this copied file. Can someone provide step-by-step instructions on how to achieve this using Power Automate?

 

Thank you in advance for your assistance!

Categories:
I have the same question (0)
  • Verified answer
    v-jefferni Profile Picture
    on at

    Hi @Vikram_Aras ,

     

    Based on your requirement, the flow would be as follows:

    vjefferni_0-1709533376852.png

     

    Row contents should be the actual column names on your end in the existing excel table and formatted in JSON.

     

    {
     "column1":"question1",
     "column2":"question2",
     ...
    }

     

     

    Best regards,

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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 538 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 405 Moderator

#3
abm abm Profile Picture

abm abm 252 Most Valuable Professional

Last 30 days Overall leaderboard