
Announcements
I have a requirement to output a list item into a preexisting Excel template. Currently, I have a power app where data is saved to a SharePoint list. I need the ability to export that specific line item into an excel spreadsheet that is preformatted in a specific template (image below). I saved the template to the site's document library. But do not know how to set the list item's data into the specific cells of the spreadsheet. Is this possible?
Excel File Example:
I found a solution that will work for me where you create a table on a second page and reference the fields in that table into the needed fields of the first tab's template. Thank you Matt Devaney!
https://www.matthewdevaney.com/fill-in-an-excel-template-with-power-automate/