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 2026 Super Users!
Congratulations to our 2025 community superstars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Vish WR 785
Valantis 669
Haque 563
