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

Power Automate Fundamentals # 34: Usage of and Function in Power Automate

Introduction: In Power Automate, at times we must validate two expressions and proceed further if both the expressions are true, in these scenarios and function is used. As an scenario, name of the person and lucky number values were taken to show and function behavior. Step 1: Login to the required Power Apps environment using …

Continue reading Power Automate Fundamentals # 34: Usage of and Function in Power Automate

Power Automate Fundamentals # 33: Usage of do Until Function in Power Automate

Introduction: In Power Automate, at times we must repeat certain steps until a condition met. In these scenarios we make use of Do until function as an example counter value will be incremented till it become 3. Step 1: Login to the required Power Apps environment using URL make.powerapps.com by providing username and password and …

Continue reading Power Automate Fundamentals # 33: Usage of do Until Function in Power Automate

Back to Basics # 30: BPF In Model-Driven-Power-Apps

Introduction: We can include BPF in a model driven app in Dynamics CRM where directly a new contact can be created from App and start using Business Process Flow. Step 1: Login to the required environment and go to flows and select Business process flows – Vaccination and observe whether BPF is active or not, …

Continue reading Back to Basics # 30: BPF In Model-Driven-Power-Apps

Power Automate Fundamentals # 32: Usage of or Function in Power Automate

Introduction: In Power Automate, for doing validations or Function will be used. As an example, an String variable and a number is used to do this validation. 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 left-hand side as shown in …

Continue reading Power Automate Fundamentals # 32: Usage of or Function in Power Automate