Introduction: In few scenarios when working on List of records for a given entity it is needed to find out the count of total records present in that table to perform certain manipulations. Here length function in power automate can be used to get record count for a given list. As an example contact table …

Continue reading Power Automate Fundamentals # 50: Get Record Count for a List  in Power Automate

Introduction: In certain scenarios we have to bundle multiple operations together so that all should pass or fail, in any case if one of the operations fails then all the other operations gets roll backed to make atomic operations. To achieve this functionality in Power Automate we can use ChangeSet Request Action , as a …

Continue reading Power Automate Fundamentals # 49: Usage of ChangeSet Request in Power Automate

Introduction: In Power Platform, for certain business scenarios we must extract first, and last characters of a given string or First and Last items present in an array. First And Last function can be used in power automate to achieve this functionality. Step 1: Login to the required Power Apps environment using URL make.powerapps.com by …

Continue reading Power Automate Fundamentals # 48: Usage of First & Last Function in Power Automate

Introduction: In order to get details of related entity for the selected entity without separate retrieve call we can leverage Expand Query .As a business scenario for the same vaccination use case extracting details of accounts that are present in list of contacts who took vaccination.        Step 1: Login to the required Power Apps environment …

Continue reading Power Automate Fundamentals # 47: List Rows Based on Expand Query in Power Automate

Introduction: During certain scenarios we must work on List of records to perform certain operations like sending alerts to list of customers. In these scenarios it is critical to filter records to make sure actual requirement was met. In Power Automate, we can use FetchXMLQuery option under List Rows as an example we can see …

Continue reading Power Automate Fundamentals # 46: List Contacts Based on FetchXMLQuery in Power Automate

Introduction: In Power Platform for certain scenarios data needs to be represented in HTML Table , in those cases we can work with HTML Table Action, as an example we will show list of contacts in an HTML Table. Step 1: Login to the required Power Apps environment using URL make.powerapps.com by providing username and …

Continue reading Power Automate Fundamentals # 45: Usage of HTML Table in Power Automate

Introduction: In Power Platform, at times we must skip few elements from an Array or few characters from a given strings. In these scenarios, Skip function in Power Automate can be used.As an example Employees String Array and Employee Name String variables are used to explain this behaviour. Step 1: Login to the required Power …

Continue reading Power Automate Fundamentals # 44: Usage of Skip Function in Power Automate

Introduction: In Power platform for some requirements, it is required to extract Choice values for entities. As an example, on update of Contact record, Status [Choice] Text Value will be extracted . Step 1: Login to the required Power Apps environment using URL make.powerapps.com by providing username and password and click on Flows on the …

Continue reading Power Automate Fundamentals # 43: Extract Choice Text Value in Power Automate

Introduction: In Power Automate one of the common scenarios was to extract Look up Field Text which will be a nightmare for the people who are new to Power Automate about how to extract details of lookup field. As an example on update of Contact Table, Account Details will be extracted . Step 1: Login …

Continue reading Power Automate Fundamentals # 42: Get Lookup Field Text in Power Automate

Introduction: In Power Automate, during certain scenarios we must traverse all the records in excel file table and based on few conditions content in excel to be updated. List Rows action present under Excel Online(Business) Connector in power automate can be used. As an example scenario of updating eligibility of Employees based on Age explained …

Continue reading Power Automate Fundamentals # 41: Working with List Rows Present in Excel Table OneDrive in Power Automate