Answered

Entering data into Excel template

(0) Share

Report

Posted on by AlexMurphy

I have a SharePoint list which is automatically completed when a user completes a Microsoft form. I now need to add that list item to an Excel spreadsheet. however the issue I have is the fields need to go into certain parts of the form as per the attached image (fields in Yellow). I can add it to a normal spreadsheet but have tried and failed to add it the results in to certain parts of the spreadsheet. Can anyone help please?

Categories:

Using flows

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

DamoBird365 8,942 Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @alex_murphy

You want to look at office scripts. https://docs.microsoft.com/en-us/office/dev/scripts/overview/excel

I have done a couple of demo's for invoicing using this feature and it allows you to select the cells that you wish to save the data to. In fact you create a bespoke Excel Action using the script feature.

I've a playlist on Office Scripts https://www.youtube.com/playlist?list=PLzq6d1ITy6c2_qM_ocYDtEaENrqi92YmM but the video you want to watch is https://www.youtube.com/watch?v=lskqQNDegXc write up is here https://www.damobird365.com/perfectly-complete-an-excel-invoice-template/
Sample scripts are here https://github.com/DamoBird365/PowerAutomate/tree/main/ExcelInvoiceDemo

Please let me know how you get on.

Damien

Was this reply helpful? Yes No
AlexMurphy 43 on at

Like (1)

Report
Copy link

Link copied!

Hi @DamoBird365 sorry for the late reply. I had to learn more about Typescript but everything you showed worked a treat. thanks for your help

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (2)

Report
Copy link

Link copied!

Hi Alex, another workaround would be to create another tab (hidden) in your spreadsheet and drop all your data there, in a single row. Then, you would reference all your cells in yellow to the respective cells in the hidden tab.
Cheers,
Leo

Was this reply helpful? Yes No