Skip to main content

Posts

Showing posts from July, 2022

Database actions - PAD

  POWER AUTOMATE DESKTOP - DATABASE Pre-Requisites Power Automate Desktop Access to database  Under the database action, we have only three sub actions, namely: Open SQL connection Execute SQL statement  Close SQL connection Open SQL Connection The first step is to connect to the database. So, we will use the Open SQL connection action and provide a connection string to establish the connection (the connection string in the video is a sample). When the connection is successful, the connection details is stored in a variable during execution. Execute SQL statement This action can be used to execute SQL queries. Here, I am using select query and the result is stored in a variable of type datatable. Close SQL connection It is a best practice to always close the database connection once the required queries are executed. YAY! BONUS!😮 How to execute a stored procedure using database action? Stored Procedure without arguments Stored Procedure with arguments (Comma separated in...
Post a Comment
Read more

Switch Control In Power Automate Flow

 SWITCH CONTROL IN CLOUD FLOW PRE-REQUISITE Login to  Power Automate Create a manually triggered flow BUILDING A FLOW TO USE SWITCH STEP 1: Expand the action "Manually trigger a flow" and add an input of the type "Number". This prompts for an input value when the flow is triggered. STEP 2: Search and select "Switch" control. You notice that two branches are added automatically. STEP 3: In the Switch action, select the "Number" variable from the Dynamic content that we created in the Step 1. STEP 4:  We can give one or more cases and a matching criteria for each case. In this case, I am giving Prime numbers between 0-9 and adding a compose action to say its prime. For default case, I am putting a Compose action that says its Non-prime. TESTING TIME Thanks for visiting.😊 Please leave a comment if you would like me to cover a particular topic.
Post a Comment
Read more

Rounding up fractions - Power Automate

 ROUNDING UP IN CLOUD FLOW Use the expression 'formatNumber()' with Compose action, to round up the numbers. Example 1 : 10.3633 rounded off to 2 decimal places gives 10.36. Example 2 : 10.3633 rounded off to 1 decimal places gives 10.4 Example 3 : 10.3635 rounded off to 2 decimal places gives 10.364. That's all folks. Leave a comment in case you have questions.
Post a Comment
Read more

LookUp Function

 LOOKUP FUNCTION - CANVAS APP PRE-REQUISITE Login to  Power Apps Use a Dataverse table for this example BUILDING THE APP STEP 1:  Create a Canvas app. Add a gallery and a label. STEP 2:  Make the "Users" table as the data source of the Gallery. STEP 3:  LookUp function finds the first record that matches a formula. In this example, I use lookup to find the full name of the user who is a "HR Manager". LookUp(Users, Title = "HR Manager").'Full Name' OR  LookUp(Users, Title = "HR Manager", 'Full Name')  We use the gallery to see if Wes is the HR Manager. (To verify if the Look-up function gave the correct output) Note: We used the LookUp function within a label, because it returns 1 record and we're displaying 1 column of the returned record. That's a single value.  Do try it for other tables and columns! Please leave a comment if you have queries.
Post a Comment
Read more

Create a User - Azure AD

 New User - Azure AD PRE-REQUISITE If you are using your trial work-school account, you will have Administrator access to the Azure Portal . But if you are not, please ask your administrator to add the user. STEPS TO ADD NEW USER IN AZURE ACTIVE DIRECTORY Step 1:  Search for "Users" and select Users. Step 2:  Click "+ New User". You may give the details as you please. I will be providing these details! UserName: user1@<domainname>.com Name: User 1 Usage Location: India Click "Create". Step 3:  Once the user is created, I will assign the appropriate Licenses to the user. Select the created user. Select Licenses from the side-menu and assign appropriate licenses to the user, so he/she is able to access the Power Platform and other office tools. That was a quick one on how to add a new user in Azure AD. Please leave a comment if you have any questions!
Post a Comment
Read more

Add User - Power Platform

 ADD USER - POWER PLATFORM PRE-REQUISITE The user you want to add in Power Platform, must be available in the Azure AD. Please check this post for reference 👉  Azure AD - User 👈 Login to your  Power Platform STEPS TO ADD NEW USER TO POWER PLATFORM ENVIRONMENT Step 1: In the Home page of the Power Platform, there is a Settings Gear in the top-right corner, click on it. Under PowerApps, select the "Admin Center". The Power Platform admin center opens in a new tab. Step 2: Select "Environments" from the side-menu and select your current environment. Side Note: Environment will be covered in this blog Step 3: Under the Access block, select "See all" for Users Step 4: Click on "+ Add User". Step 5: Search and select your user. Click on Add. Step 6: By default, the Security Roles, Basic User and Environment Maker will be selected for any user we add. For this example, I am selecting "Approvals User" role and Clicking on Save. Now, refresh ...
Post a Comment
Read more