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

Back to Basics # 33: Restrict Stage Movement Based on Roles using JavaScript in BPF

Introduction: In certain implementations, BPF Stage movement to be done based on roles. So, this can be achieved by writing custom JavaScript and logic to capture roles of the logged in user. As an example, we consider here same vaccination BPF on Contact record , where for users with role sales man will be restricted …

Continue reading Back to Basics # 33: Restrict Stage Movement Based on Roles using JavaScript in BPF

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

Back to Basics # 32: Move to Next Stage using JavaScript in BPF

Introduction: At times we must work on BPF Stages and navigate Stages automatically based on the business requirement, in this post we are going to see how it can be achieved through javascript .As an example, existing Vaccination BPF on an existing Contact record was used to show this navigation to Next Stage on change …

Continue reading Back to Basics # 32: Move to Next Stage using JavaScript in BPF

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

Power Automate Fundamentals # 35: Usage of Equals Function in Power Automate

Introduction: In Power Automate, at times we must validate two values and proceed further if result is true, in these scenarios Equals function is used. As a scenario, name of the person and current years  values were taken to show this function behaviour. Step 1: Login to the required Power Apps environment using URL make.powerapps.com …

Continue reading Power Automate Fundamentals # 35: Usage of Equals Function in Power Automate

Back to Basics # 31: Understanding Move Next and Move Previous in BPF

Introduction: At times we must work on BPF Stages and navigate Stages automatically based on the business requirement, for quick test D365 Client API’s can be used for navigation with predefined methods moveNext and movePrevious in console window of browser before writing JavaScript code. As an example, existing Vaccination BPF on an existing Contact record …

Continue reading Back to Basics # 31: Understanding Move Next and Move Previous in BPF