I have a Flow that adds sales items to an Excel table and that table gets added to a Word template.
It's problematic, messages e.g. file locked for editing and the table doesn't always update in the template. I also need to clear the table to reuse the file.
There must be a better way. Can you help please?
hi @Shell unfortunally this is a kind of bug that Excel has arround was microsoft flow, I tought was solved but you can try opening a microsoft support case.
See could be solved for the ms enginering team.
Already using SharePoint lists. I want the workflow to add information to a content type template ( I can do that successfully using SharePoint designer) but I also need to add repeating data.
I could update an excel table and input that into the template but it doesn't always work. I then need to clear the rows from the table so it can be used again, that's when I get the file locked message.
I can create an HTML table but how do I get that into the Word document?
Just note, something I've learned the hard way. Sharepoint needs time to think. Make sure to add plenty of delays in there so that the flow doesn't move faster then the time it takes for sharepoint to process your request.
@Shell I would do it the way that @TesDA has explained. Instead of putting your figures into Excel, just load them into a JSON array and use that as your source of repeating data for the Word template.
The Excel connector is so fussy, which you can work around with a do until loop, but it can take ages for the file to free up.
That's the approach I'm taking but unfortunately we don't have the premium action 'Populate Microsoft Word template' 😢
I have the arrays set up but how to get that into the content-type template in the document library
Keep up to date with current events and community announcements in the Power Automate community.
A great place where you can stay up to date with community calls and interact with the speakers.
Check out the latest Community Blog from the community!