You’re offline. This is a read only version of the page.
43
Hi
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?
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
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
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
#1
WarrenBelz
146,605
Most Valuable Professional
#2
RandyHayes
76,287
Super User 2024 Season 1
#3
Pstork1
65,946
Most Valuable Professional
Share
Report
All responses (
Answers (
