Making your Power Virtual Agent more interactive is achievable using Power Automate. When the bot asks the end user a question, it can accept input (entities), pass these to Power Automate and then in return tailor a response, based on the outcome of your flow....
Continue reading...Create a draft Email in Outlook
Learn how easy it is to create a draft email in your Outlook Draft folder using Power Automate. Rather than send the email direct from Power Automate, let me show you a simple way to create a draft email. You can review, edit and send...
Continue reading...Error Handling – Power Automate
You have multiple flows, they run multiple times a day and then one starts failing. Power Automate will eventually notify you that your flow has failed a few times recently and that you should take a look but how about a proactive approach to error...
Continue reading...Building an app is Child’s Play – Part 1
Whether you are building your first Power App or looking to get your own child or class started with Power Apps, this is hopefully a great place to start learning by doing. I was challenged by my 9-year-old daughter, Emily, to build a Power App...
Continue reading...Create Table in Excel WorkSheet
If you are receiving daily/weekly excel workbooks containing data that isn’t saved as a table, how are you going to query it in PowerAutomate? One method is to use Office Scripts. With a relatively simple piece of TypeScript, you can insert a Table into your...
Continue reading...Round Robin in Power Automate
If you are looking to implement a round-robin allocation of list items, Microsoft form submissions, tasks, or emails via Power Automate, I have a couple of very easy solutions that you can implement using either a Microsoft List or Security/Distribution Group for the user array/list....
Continue reading...Mention a Channel or Team – Power Automate
Via Microsoft Teams, you can mention a Team or Channel and the members will be alerted to a new message being posted. Currently, via the default Power Automate actions, you are not able to mention either, unless you are familiar with Graph. It’s not as...
Continue reading...Add members to a distribution list – Power Automate
Are you looking to add members or list members of an exchange email distribution list via Power Automate? As part of an onboarding process, maybe you have a Power App or Microsoft Form that allows a manager to request that their new member of staff...
Continue reading...Unique IDs and pad a string
Are you looking to create a unique ID in Power Automate for your Microsoft List items or files created in a SharePoint Document Library, an invoice number, file name, or sequential ID? Let me show you how to sequentially increment your unique ID based on...
Continue reading...Microsoft List – Add Comment
If you are looking to automatically add comments to Microsoft List Items (or “SharePoint” List items) via Power Automate, you’ve come to the right place. In this article, I will show you how you can use the SharePoint Rest API to both post a comment...
Continue reading...