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.
Could anyone please provide some guidance.
Helpful resources
Power Automate News & Announcements
Keep up to date with current events and community announcements in the Power Automate community.
Community Calls Conversations
A great place where you can stay up to date with community calls and interact with the speakers.
