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

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

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

Power Automate Fundamentals # 31: Usage of Not Function in Power Automate

Introduction: In Power Automate, for doing validations Not Function will be used. As an example, an String variable used to work with Not function. 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 the below figure. …

Continue reading Power Automate Fundamentals # 31: Usage of Not Function in Power Automate

Power Automate Fundamentals # 30: Usage of Less Than Function in Power Automate

Introduction: In Power Automate, generic arithmetic operations like Less Than will be used to validate provided integer values. As an example, an integer variable used to work with Less than function. 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 …

Continue reading Power Automate Fundamentals # 30: Usage of Less Than Function in Power Automate

Power Automate Fundamentals # 29: Usage of Greater Function in Power Automate

Introduction: In Power Automate, generic arithmetic operations like Greater will be used to validate provided integer values. As an example, an integer variable used to work with Greater function. 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 …

Continue reading Power Automate Fundamentals # 29: Usage of Greater Function in Power Automate

Power Automate Fundamentals # 28: Usage of GreaterOrEqual Function in Power Automate

Introduction: In Power Automate, generic arithmetic operations like GreaterOrEqual will be used to compare between values. As an example, Speed Limit with integer value considered to compare with other integer values. 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 …

Continue reading Power Automate Fundamentals # 28: Usage of GreaterOrEqual Function in Power Automate

Power Automate Fundamentals # 27: Usage of JSON Function in Power Automate

Introduction: In Power Automate, at times we must work on JSON with String Values as input. We can use JSON function in power automate to convert string values to JSON and perform related operations. As an example, string values separated with comma and also xml string values are used. Step 1: Login to the required …

Continue reading Power Automate Fundamentals # 27: Usage of JSON Function in Power Automate