Modify SharePoint Templates with Power Automate

The SharePoint connector for Power Automate provides a wide range of actions for accessing and modifying SharePoint items. But, did you know you can use Power Automate to modify SharePoint templates? One of those actions, Get file contents, can be used to get and store an entire file inside of a flow run. From there, the flow can act based on the contents of that file, such as replacing predefined “tags” in the file with dynamic content from a Dataverse row.

Consider a text (.txt) file stored in SharePoint which contains the following sentence: “Trenton is the state capitol of New Jersey.” We could turn this into a template by replacing some words with tags (a word with brackets surrounding it), then using a Power Automate flow to replace those tags with data from one or more Dataverse rows.

Let’s replace “Trenton” with “[capitolName]” and “New Jersey” with “[stateName].” We now have a text file that looks like this: “[capitolName] is the state capitol of [stateName].” If we use the SharePoint Get file contents action to get our text file, we can begin modifying our file in a flow…(read full post on www.beringer.net)

The post Modify SharePoint Templates with Power Automate appeared first on CRM Software Blog | Dynamics 365.