cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
alex_murphy
Frequent Visitor

Entering data into Excel template

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?

 

EA.png

1 ACCEPTED SOLUTION

Accepted Solutions
DamoBird365
Super User
Super User

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

View solution in original post

3 REPLIES 3
DamoBird365
Super User
Super User

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

View solution in original post

alex_murphy
Frequent Visitor

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

leonunescouto
Advocate II
Advocate II

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

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Users online (1,951)