Here goes an unusual combination of old and new technologies, sprinkled with a bunch of howto-s
The author discusses a project where document templates were needed, but the usual options in Dataverse and Power Automate were not sufficient. The business team mentioned that they had templates created using VBA Macros in Word, which could read data from an Excel spreadsheet. The author then explains how they created a templating engine using a combination of Power FX, Power Automate, SharePoint, JavaScript, and VBA macros. The solution allows users to choose a template, generate a spreadsheet with data, store it in SharePoint, and populate the template with the data using the VBA macro. The author provides a demo recording and links to a GitHub repository with the source files.
Article 11m
Login now to access my digest by 365.Training
Learn how my digest works
Features
- Articles, blogs, podcasts, training, and videos
- Quick read TL;DRs for each item
- Advanced filtering to prioritize what you care about
- Quick views to isolate what you are looking for right now
- Save your favorite items
- Share your favorites
- Snooze items you want to revisit when you have more time