Often one of the most rewarding parts of digital transformation is the ability to create key business data. After implementing a digital contract lifecycle management system you will have lots and lots of data at your disposal. …

A book that promises you can easily build your own contract management software without IT help The book No Cost Contract Automation (LegalBot Press, IBSN 9783952540800) proposes a different approach. Build your own! The latest advances in no-code / low-code software like Microsoft’s Power Automate make this possible without professional IT help. The book provides a blueprint and step-by-step instructions on how to build your own…

Do you need to create a wildcard search in Microsoft PowerApps. There is no native support for wildcard searches in PowerApps. But below is one possible solution on how to make it work. The solution: Clear(newCollection); ForAll( Split( TextInput.Text, “*” ) As SplitMe, Collect( newCollection, Filter( [Your Data Source], Trim(SplitMe.Result) …

If you are still using email approvals in your company you should stop. In no time at all you can build a sophisticated approval system using the built in Approval connector in Microsoft Power Automate. Why use Power Automate for approvals? Reason 1: It’s free (if you have Microsoft 365…

It happened again! You missed the notice period of your contract. You can stop this from happening by setting up an automatic reminder notice. Chapter 9 of the No Cost Contract Automation book shows how you can configure your existing Microsoft 365 for Business software to send notification emails. This…

To use the HTTP Connector in Power Automate you need a premium license. I figured out an awesome hack that lets you send an HTTP request to APIs without the premium license. The only limitation is the REST API needs to be without any authentication. How it’s done To set up the feature…

A common question that comes up when building PowerApps is whether it is possible to use SharePoint as a data source. The answer is yes. However, when you have lots of data — over 500 rows — there are some limitations. …

The magic of SharePoint automatically adding document properties to word files — When I first started working with contract automation over five years ago I was searching the Internet for ways to automatically insert text into Word documents. All I could find was demos and video instructions using Visual Basic, Building Blocks or other complicated methods to insert fields. These methods did…

I have no affiliation with Microsoft or Microsoft Power Automate For the past two years I have been using Microsoft Power Automate to automatically deliver standard emails both internally and externally. The reason I started working this way was because I wanted to speed up some admin type work that…