Posts

Power automate approval workflows in SharePoint

Image
 Power automate allows approval flow across several services including SharePoint, Dynamics 365, Salesforce, OneDrive for Business, Wordpress. Add an action "Approval - Start and wait for an approval" to any flow to start create an approval flow. Create an automated cloud flow with the flow trigger as "When an item is created". A blank flow is created with the connector as "When an item is created". Create an action "Start and wait for an approval" and input the below entries. Email is triggered to the users in Assigned To when an item is created in the list. Flow will look as below, The employee data list is as shown below, Add a new item "Scooby" into the list. The workflow runs and the approval is triggered as shown. You can click on approve or reject to process the request. 

Create an item in a List using Manual flow

Image
  Login to Power automate and click on New flow --> Instant cloud flow. Give the flow name as "Insert Item to List" and select the trigger as "Manual trigger". Click on Create. An Empty flow created with manual trigger as shown below. This flow will create a copy of country data to the backup list "CountryCopy". To accomplish this, we create 2 actions in the flow Get Country Data from the list and Create item in the list.   Get country data action takes the data from the list country. It is achieved using an api call with site address and filter query. Next, you need to make an Apply to each block and iterate the data in the parent list "Country". In Create an item in the list action, give the site address and list name as "CountryCopy" and enter the values from the parent list. Select the option Manually. Click on Test. Click on Run flow. The below message appears. The below screenshot shows the country list. Data are now copied...

Error handling in Power automate flows

Image
 This blog explains you how to use try catch action scope in Power Automate flow. Getting notification when your flow has failed is a critical feature that every business requires. Error handling in Power automate is done using scope action block. You can choose from one of the below three ways to start a flow, 1. Start from blank 2. Start from a template 3. Start from a connector Create a manual flow and add 2 scope try, catch to accomplish exception handling. Create a blank instant flow. Add a scope action in that flow. Rename that scope as "Try". Create an action "Send an Http request" and give the fake URL in the URI as shown below. Create another scope and name it as "Catch". This block contains the action to send notification in case of failure in try block. The flow is done, click on Save. Click on Test to test the flow. The flow is run and the output is as below. You can see that the action "Send an Http request" failed and the catch bloc...

Power Automate

Image
Power automate is a digital automation platform with digital process automation and robotic process automation capabilities. It provides an no code solution for all the issues. Power automate is available both in cloud and desktop version. Power automate in desktop allows to automate complex scenarios using scripts in JavaScript, Python and PowerShell. It can act as an AI tool also, unique AI builder services optimizes business operations. Microsoft Power platform cloud can be avail as free version with a developer Office 365 trial account.   There are 3 types of Power automate / flow. 1. Scheduled flow 2. Trigger flow (Automatic flow i.e. Data is changed or created) 3. Instant flow or button flow(Manual flow) Scheduled flow: It is triggered based on time constraint. we can trigger a flow for every Monday 9am of every week or every month.  Trigger flow: Trigger is an event that starts the flow. For example, if you want to receive a notification in teams every time w...