Modify SharePoint Templates with Power Automate

Visit Website View Our Posts


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


Leave a Comment

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Show Buttons
Hide Buttons