Announcements
Hi All, I have a MS form that I would like the responses to be added to certain rows and tabs on an MS Excel Spreadsheet is this possible with Power Automate? can someone point me in the direction of some guidance or training if there is any 🙂
Hi @Kirsty1986 ,
I'm assuming that you need to fill some specific cells of the Excel file that are not necessarily organized in a table format. Although Power Automate works better with table formats in Excel, you still can access the individual cells by using Office Scripts. It works like a "VBA Macro", where you can manipulate an Excel file by using code (in this case, TypeScript) and then run it from a Power Automate code, even passing some parameters to the Script.
Before we move forward, some organizations have restrictions for the use of these scripts, so please confirm if this is something possible from your end. If yes, I will be happy in helping you to write a script for that and integrate it into a flow.
Also, I'm sharing some links about the Office Scripts and its integration to Power Automate:
- Office Scripts in Excel (Official docs): https://learn.microsoft.com/en-us/office/dev/scripts/overview/excel
- Integrate Office Scripts in PA (Official docs): https://learn.microsoft.com/en-us/office/dev/scripts/develop/power-automate-integration?tabs=run-script
- Office Scripts and VBA: http://digitalmill.net/2023/06/10/office-scripts-the-new-vba/
- Getting Started with Office Scripts: http://digitalmill.net/2023/06/19/get-started-with-office-scripts/
- Sending values to Excel ranges with Office Scripts: http://digitalmill.net/2024/01/17/sending-values-from-power-automate-to-excel-with-office-scripts/
Thank you, I will double check with my organisation.
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.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
David_MA 262 Super User 2026 Season 1
11manish 167
Haque 154
