Skip to main content

Posts

Showing posts from August, 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 incase of many a
Post a Comment
Read more

Blog Contents

 CONTENTS Click on the links below, to conveniently navigate throughout this blog! Happy Learning!👻 Section 1: Microsoft Power Platform What is Power Platform? Login to Power Platform Types of Power Apps Add User to Power Platform Section 2: Microsoft Power Automate Build flows using Templates Types of PA Flows Trigger flows from a button click in mobile app Types of variables in PA Flow Management Add Data To Dataverse Using A Flow Get Current Date/Time Apply To Each Do Until Text Functions Length of String/Array Round Up Switch Condition/Control Using the Dataverse connector in flow Section 3: Microsoft Dataverse What is Microsoft Dataverse? Create a Dataverse table Section 4: Canvas App Quickly create Canvas App with Dataverse as source Get started with Canvas app editor Variables in Canvas App Set ( ) - PowerApps Navigate & Back - PowerApps Gallery Control Using Formula in Canvas App Filter A Gallery Browsing through a gallery Lookup Function Currently Logged In User Details
Post a Comment
Read more

Microsoft Dataverse & Power Automate - Part 3

POWER AUTOMATE & MICROSOFT DATAVERSE - 3 PRE-REQUISITES Login to  Power Automate Create a manually triggered flow In this post, I will be using the data that is available in the Accounts table ADD NEW DATA ROWS INTO A DATAVERSE TABLE Select the action "Add a new row" under Microsoft Dataverse, select a table and then enter the data to be added into the table. After running the flow, check the table to see the data has being entered. DELETE A ROW FROM A DATAVERSE TABLE To delete a value from a table, we need to know the GUID/Row ID. That can be fetched from the table or use list rows in cloud flow. Now, use the "Delete a row" action, select the table and pass the GUID. Run the flow and check if the data is deleted. GET A ROW BY ID FROM DATAVERSE TABLE If you know the GUID of a row from a table in dataverse, we can use it to fetch many details related to that row. Test: UPDATE A ROW IN DATAVERSE TABLE If you know the GUID of a row from a table in dataverse, we can
Post a Comment
Read more

Microsoft Dataverse & Power Automate - Part 2

POWER AUTOMATE & MICROSOFT DATAVERSE - 2 PRE-REQUISITES Login to Power Automate Create a manually triggered flow In this post, I will be using the data that is available in the Accounts table LIST ROWS WITH FILTER QUERY From the Accounts table, fetch the Logical name of the column to be filtered. Use the logical name in Cloud Flow while listing the rows and test it. (There is only 1 entry for the City Kochi) The other operators that can be used in filter: LIST ROWS WITH SORT Get the logical name of the column to be sorted. Use desc  for descending order and asc  for ascending order. Sorted by State and Tested: LIST ROWS WITH ROW COUNT Number of rows to be fetched from dataverse can be mentioned. However, 5000 is the default number of rows that can be fetched. It can be increased to a maximum of 1,00,000 rows under Settings > Pagination > Increase Threshold. Thank you for visiting! Please leave a comment for queries. Next >> Add, Delete and Update Table
Post a Comment
Read more

Microsoft Dataverse & Power Automate - Part 1

POWER AUTOMATE & MICROSOFT DATAVERSE - 1 PRE-REQUISITES Login to Power Automate Create a manually triggered flow In this post, I will be using the data that is available in the Accounts table. In Cloud flow, we can use the dataverse connector and perform multiple actions as required. LIST ROWS IN DATAVERSE Use List rows action to list rows/records from a selected table. Use Apply To Each control to go through each row in the table. Data in the Dataverse table Accounts is shown. In Cloud flow, Use List Rows and Apply to each to get data from dataverse and loop through each row. Test Time: LIST ROWS WITH SELECTED COLUMNS From dataverse table, fetch the selected columns only. Multiple column names can be comma separated. Fetch the logical name of the columns (to be selected) from the Dataverse table. (In my observation, fetching only required rows, reduces the execution time) Enter the logical name of the column in Advanced Options of the List rows action. Test Time: Next: List Rows
Post a Comment
Read more

Display details of currently logged in User - Canvas App

 Display Logged In User Details Create a canvas app, insert a label control and try the following: USER NAME EMAIL For other details like country, use the Office 365 Users connector as shown below: Try them out! Have fun building canvas apps. Do leave a comment for any questions.
Post a Comment
Read more