
Announcements
Hello everyone,
I have just starded using Power Automate and I need to do the following activity.
From the answers of a Microsoft Form, I create a copy of an existing excel file in SharePoint and I need to populate this excel file with the answers from the form.
Example:
The form with the questions Name and Age is submited -> then I create a file named "Name - Age.xlsx" which is a copy of another excel file on SharePoint -> then I need to populate this new file like this: "B2" with Name and "C2" with age.
So far, I managed to create the copy of the excel file within the flow and now I would like to populate this file in the way I explained above.
I think maybe I need Office Scripts but I don't exactly know how to use it. Keep in mind that I want to do this without using tables.
Thank you very much for your help!!