I'm trying to figure out the best approach to enter line items (which could be between 2 and 20) and add those line items to an excel template, save the template in a document library with a specific file name. I also need to generate an auto ID, which is added to the excel file and also save it in a SharePoint List to use for other items in my app. I figured I will also need to use Power Automate to create the excel. Should the fields I need in the Excel be a Gallery using a Collection? What I'm trying to do is build a quote excel document that will be sent to different vendors, so the user just needs to plug in the information, select the vendors and it creates different excel files for each vendor to get mailed out.


Report
All responses (
Answers (