Power Automate Fundamentals # 45: Usage of HTML Table 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

Power Automate Fundamentals # 44: Usage of Skip Function 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

Power Automate Fundamentals # 43: Extract Choice Text Value 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

Power Automate Fundamentals # 42: Get Lookup Field Text 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

Power Automate Fundamentals # 41: Working with List Rows Present in Excel Table OneDrive 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

Power Automate Fundamentals # 40: Usage of Join Function in Power Automate

Introduction: In Power Automate, at times we have to join few items which received in the form of strings. As a scenario, response of the user was taken to show this function behavior. Step 1: Login to the required Power Apps environment using URL make.powerapps.com by providing username and password and click on Flows on …

Continue reading Power Automate Fundamentals # 40: Usage of Join Function in Power Automate

Power Automate Fundamentals # 39: Update A row in an Excel Table Onedrive in Power Automate

Introduction: One of the common scenario was to update data in Excel Spread sheets . To achieve this functionality automatically, we can use an action- Update a row into a Table in Power Automate under connector Excel Online (Business). As an example, after Sending emails to contacts, Employee details will be updated with sent Date …

Continue reading Power Automate Fundamentals # 39: Update A row in an Excel Table Onedrive in Power Automate

Power Automate Fundamentals # 38: Usage of If Function in Power Automate

Introduction: In Power Automate, at times we must validate values and proceed further if result is true, in these scenarios If function is used. As a scenario, response of the user was taken to show this function behaviour. Step 1: Login to the required Power Apps environment using URL make.powerapps.com by providing username and password …

Continue reading Power Automate Fundamentals # 38: Usage of If Function in Power Automate

Power Automate Fundamentals # 37: Send Emails from Excel Sheet (OneDrive) in Power Automate

Introduction: One common manual work was to send emails to list of users, where this can be achieved by using Power Automate. As an example, sending emails through excel sheet from OneDrive considered to explain this. Step 1: Login to the required Power Apps environment using URL make.powerapps.com by providing username and password and click …

Continue reading Power Automate Fundamentals # 37: Send Emails from Excel Sheet (OneDrive) in Power Automate

Power Automate Fundamentals # 36: Add A row into an Excel Table OneDrive in Power Automate

Introduction: Most of the common usage of storing data in Excel Spread sheets and a common scenario was to add data into Spread Sheet. We can use an action Add A row into a Table in Power Automate under connector Excel Online (Business). As an example, Employee details will be passed to Spread sheet through …

Continue reading Power Automate Fundamentals # 36: Add A row into an Excel Table OneDrive in Power Automate