cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
amritbabina
Regular Visitor

Creat flow to update excel template

Untitled~2.png

Hello All, 

 

I am trying to create a flow to use an existing excel file as a template to then create new excel files using the information from MS Form. I have to a stage where I can create a new file but I can find a way to then update few cells in new excel sheet with the information from MS Form. 

 

So how this should work is 

-form submitted

-excel file is created; name of the file will be the name from MS Form 

-use the info from MS Form to fill in the template with name and numbers.

-send an email to other colleagues to get them to do their part and update the excel file. 

 

I am stuck at the second last stage. I have found a forum but the guy there is using CDS which is a premium connector and I don't have access to premium connector. 

https://benediktbergmann.eu/2020/09/27/create-and-fill-an-excel-file-dynamically-with-power-automate...

 

Could anyone please provide some guidance. 

 

0 REPLIES 0

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Community Calls Conversations

Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Users online (5,540)