Posts

Power Automate Send a customized email when a new SharePoint list item is added

Image
This video is to demonstrate, how we can send email or notification when an item is added to a SharePoint list. #sharepointlist #sharepoint #powerautomate #email #notification

Send Email from Excel using power automate, flow to multiple mail Ids and BCC

Image
 This video is to demonstrate, how we can send email from an excel dynamically using power automate to multiple mail ids and how to pass dynamic emails to BCC. #powerautomate #emails #dynamically #excel #flow

Power Automate HTML Table Formatting and Emailing

Image
This post is to demonstrate, HTML Table Formatting and Emailing using power automate. (datasource: sharepoint) CSS Script: <style> table {     border: 1px solid #1C6EA4;     background-color: #EEEEEE;     width: 100%;     text-align: left;     border-collapse: collapse;   }   table td, table th {     border: 1px solid #AAAAAA;     padding: 3px 2px;   }   table tbody td {     font-size: 13px;   }   table thead {     background: #0602e1;     border-bottom: 2px solid #444444;   }   table thead th {     font-size: 15px;     font-weight: bold;     color: #FFFFFF;     border-left: 2px solid #D0E4F5;   }   table thead th:first-child {     border-left: none;   } </style>

How to use Microsoft Power Automate Tutorial for Beginners: Introduction

Image
Introduction Welcome everyone! In this course you will learn how we can start with power automate. I will try to cover from very basic so that you can use this platform very easily. Feel free to comment below if you have any query. How power automate can help? There are many possibilities which can be done using power automate For example: o    You can use to Automate business processes. o    Send automatic reminders for due tasks or to send any kind of reminders to employees or customers. o    Another use case could be, Move data between systems on a schedule. o    It has more than 500 data sources like SharePoint, SQL, OneDrive and many more. And many APIs as well. o    You can even automate tasks on your local computer like computing data in Excel.   Power Automate is all about automation. It can help you to save time by automating repetitive manual tasks simply by recording mouse clicks, keystrokes and copy paste steps from your desktop. What is

Send special characters with/without variable using HTTP action in power automate & save to sp list

Image
This post is to demonstrate, how we can save strings with special characters I have explained 2 different ways to achieve it. Youtube video link Send HTTP Action Values: URI : _api/web/lists/GetByTitle('YourListName')/Items Body :  { "__metadata":{"type":"SP.Data.Items_x0020_To_x0020_be_x0020_ShippedListItem"}, "Title":"Almond", "City": "Mathura", "Phone":"965798389", "Password":"@$%*()(*pass" } 

How to Read and Create JSON Objects in Power Automate & Save to an Excel

Image
working on: how we can create or parse an array of objects/json using expression and save parsed data to excel. You could save it to any data destination like SharePoint list etc kindly comment if you want a video on different data sources. Youtube #powerautomate #excel #expression #corporateprogramming kindly comment if you want a recorded video on any connector/action in power automate.

How to fix SP.Data.ListItem in Power Automate or Rest api

This post is about a common bug in power automate or Rest Api " SP.Data.Test2ListItem ". To get the correct  ListItemEntityTypeFullName or Term type of your SharePoint list then you can use the below JS function. Code: function getTermTypeofSPList(listName) { console.log(_spPageContextInfo.siteAbsoluteUrl + "/_api/web/lists/getbytitle ('"+listName+"')?$select=ListItemEntityTypeFullName") } getTermTypeofSPList('Your list name') Steps to use It: Open your SharePoint site. Open developer tool by pressing F12. Navigate to the Console tab. Paste the above code. NOTE: Use your list name before calling the function as shown in the above script. Watch Video: https://youtu.be/BzU11NBY0Xc Thank you!