Share
Report
234Hello lovely flowers, (are people who write flows called flowers?)
Can I use Power Automate to update a template document in a SharePoint document folder list of template documents?
- I have a template spreadsheet for an event packing list. It gives an event manager a list of products they could take to an event and asks them how many of each they will take (and then a whole lot of other process too)
- The spreadsheet exists as Template.xlsx in a subfolder of the Documents folder, hidden away out of sight of users, to stop them breaking the template
- I have added this spreadsheet as Template to the [New] list for the Documents folder
- Events managers can successfully create new packing lists from the [New] Template
My issue is the list of products changes all the time, so I need the template to update
- I have successfully written a flow that takes a csv of new products, every day, and writes it in to Template.xlsx
- But that only updates the spreadsheet called Template.xlsx
- New documents made from the [New] Template list don't have the updated product list
- I assume [New] makes a hidden Template somewhere, based on but not linked to my Template.xlsx, and uses that for new documents, not my Template.xlsx
- I can update the [New] template from Template.xlsx manually. But obviously I don't want to have to do that manually, every day!
My question is can I add steps to my flow that update the [New] Template with the revised Template.xlsx, each time it is revised?
Thank you for all your help
Guy
All responses (
Answers (
