Creating First UI Flow

This week we would be looking into our first demo on how to create UI flows using Power Automate Desktop.

Just in case if you are not aware about UI Flows/ Power automate desktop flows. Please refer my previous blogs.

Today we will be creating UI flow that will create an excel file add a few email addresses to it and than send email to respective emails.

What you need to get started, Power Automate Desktop installed in your machine. You can download it form here.

Click on New flow from top right corner of the Power Automate Desktop screen.

Now search form Launch Excel action from Actions panel.

Drag action to main section. double click on it to open action config section.

Similarly drag Create New List.
Drag Add item to list and double click it to add email addresses.

Note: You can add more email address to same list that we created earlier.

Now drag Write to Excel worksheet and double clock on it to configure properties.

Now drag Save Excel action and save excel to a specific location.
Now drag Launch Outlook action.
Iterate excel worksheet using Loop action.

You can use Send Email Message through Outlook action to sent emails.
Lets close excel using Close Excel action.

Great! we are ready with our first demo of UI flows.

Below is how your complete UI flow will look.

You can run flow by clicking on play button on top ribbon on screen.

Now just relax and see the magic happen.

Thanks,

Keyur

Comments

Identity client runtime library (IDCRL) did not get a response from the login server.

Recently I was doing some testing with a background PowerShell and encountered a weird error. “Identity client runtime library (IDCRL) did not get a response from the login server”. The error that you might encounter while working with PowerShell. This error is very misleading when it comes to identifying what could go wrong. After doing quite a good amount of research below are the probable causes for the error. Invalid Credentials MFA (Multi-Factor Authentication) Manage security defaults. Solutions Invalid Credentials Check if your credentials are wrong. Especially if you are using variables. MFA (Multi-Factor Authentication) Check if MFA is enabled on the account which you are using. These only affect you badly if you are developing PowerShell for a background Job. Go to Microsoft 365 admin center Users -> Active users -> Select the user -> Manage multifactor authentication -> Select the user -> Disable multi-factor authentication. M...

Business Data Connectivity

I came to a requirement wherein I was supposed to get data from an 3 rd party portal using API’s and then bring them to SharePoint server. The first approach that I finalized was just to make BDC solution that will get data from 3 rd party portal and will deploy it to SharePoint. How to Create BDC solution in SharePoint? I found below link that is having really great description about hot to create and deploy the BDC solution to SharePoint. http://www.c-sharpcorner.com/uploadfile/hung123/creating-business-data-connectivity-service-using-visual-studio-2010/ After creating an POC I came to know that BDC model cannot be deployed on Multi tenant farm. So what can be done next? After some amount of googling I came to know that we can create BDC solution using WCF services also. So I created a WCF service solution that acted as a wrapper that used to fetch data from the portal. We can them publish that service to IIS or Server and use the servic...

Site Design Tasks, Power Automate and Modern Sites

S harePoint Site templates are now replaced with Site designs in Modern Sites. We can create custom site designs using some json script(s). Site Design allows to create lists, create list views, apply theme, customize navigation, create content types, create site columns and so on. Click here to see JSON scheme reference for creating custom site design. Endpoint to apply site design as a part of flow is as below. _api/Microsoft.Sharepoint.Utilities.WebTemplateExtensions.SiteScriptUtility.AddSiteDesignTaskToCurrentWeb We must use “Send Http Request to SharePoint” action to make an API call to SharePoint. SiteDesignId must be part if body, this is GUID of the SharePoint site design you need to apply. We can line up sequence of calls if we need to apply multiple site designs to a single site. We can now wait for few mins and all our sited designs will get applied or we can also check the status by making another API call with below endpoint. You just need to pass the Apply Desig...

Learning SharePoint

Search This Blog