Learn Power With Me

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...

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

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 ...

  ADD A NEW ROW TO DATAVERSE TABLE - POWER AUTOMATE FLOW Hey Guys! Previously, I showed you how to add a new data row into a Dataverse table using Canvas App, if you missed or wish to review it, here's a link to it 👉 Pizza Table (Canvas App) 👈 In this one, we learn how to add a row to the same table using an Instant Cloud Flow. PRE-REQUISITE Login to  Power Automate I will be using the Pizza Table which I created earlier, it must be available in the Dataverse. If you have not done this already, please use this link to create it 👉 Pizza Table . As an alternative, you may also choose to use any other table from Dataverse. STEP 1: Create a new Instant Cloud flow which can be triggered manually. STEP 2:  Add a new step to Add a new Row in Microsoft Dataverse. STEP 3:  Search and choose Pizzas  table. STEP 4:  Click on Show Advanced Options and add the values shown in the screenshot below. STEP 5:  Save the flow and Test it! Once the flow has run success...

Time to build a Canvas App in Power Apps! Pre-requisite Log In to  Power Platform I will be using Pizza Table which I created in my previous article. You may  Create Pizza Table  or you may choose to use any other table available in the Dataverse. STEP 1 : Navigate to "Create" and click on "Microsoft Dataverse". STEP 2 : Create "+New Connection" STEP 3 : We are going to create a connection to the Microsoft Dataverse to fetch the Pizza table. STEP 4 : Search, select Pizzas Table and Connect. The Canvas App editor opens. STEP 5 : Take a look at the "Tree View", "Canvas", the Play Button on top, the Screen on the RHS with Properties, Adavanced and Ideas tab. In the Tree View, you can see three screens: "BrowseScreen1", "DetailScreen1" & ""EditScreen1". You may click on each of it and see those screens on your canvas. The play button can be used to use the app. The screen on the right side can be used ...

 Got Not Worries! We Have Cloud Storage! In this post, we learn how to create a dataverse table. But before that, If you want to read up on what is Dataverse, go here 👉 Microsoft Dataverse . CREATING A TABLE Step 1: Open  Power Apps  and navigate to Dataverse. You may have to "Create Database" if it's the first time you are accessing it, else you will already be looking at a bunch of standard tables. While you are there, you may check out all the tables, columns, and data available. Step 2: Let's create a Table now. Click on "New Table". Just for fun, I am going to create a table for Pizza! Enter "Pizza" in Display Name and click Create. Provisioning the Table might take a little while. Once the Table is created, you might notice that a few Columns are already created. For example, the column "Created By" auto-populates our name when we add data to the table. There is also a column named "Pizza" whose datatype is a Unique Ident...