Learn Power With Me

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

Hello, "Power People"💪! Let's jump right in! Microsoft Dataverse A secure cloud-based storage service Stores and manages business application data Power Platform uses Dataverse to store data Data can be utilized by other apps without any need for customization Also integrated into Dynamics 365 Can handle any type of data - Relational, Unrelational, File, Image, etc. Tables Data is organized as Tables in Dataverse. The table contains Rows that represent a record of data and Columns that represent headers or a certain data item. There are readily available "Standard tables" like the "Contacts" table, we can also create "Custom Tables" which meet our organization's needs. "Managed Tables" are also available, but these aren't customizable. Table Relationships The rows in one table can be associated with rows in another table or the same table. There are two types of relationships: One-to-many  and Many-to-many Business Rule B...

Automation is our favorite! Not because we're lazy, but because we're crazy!😇 As a pre-requisite, you have to log in to Power Automate . If you do not have your free trial account yet, then this post 👉 Create Work School Account 👈 will help you out! Building a super-easy flow from the available templates Outline of the requirement: "Whenever I receive a mail with attachments in Outlook, I immediately want those attachments to be uploaded into my OneDrive For Business"! Let's keep both applications "OneDrive For Business" and "Outlook" open in separate tabs. You may access those apps using the App Launcher visible icon on the top left corner Step 1: Navigate to Templates Menu in Power Automate. Step 2: Search and select the template "Save Office 365 email attachments to specified OneDrive for Business folder". Step 3: Sign in to both the apps that we need to access in this flow and click continue. (These are special little things Co...

 First Things First Peeps! The good news is that we do not have to download/install any Client App to access Power Platform. It is a PaaS offering, so all we need is a work-school account created through Azure Active Directory to log in to the Power Platform. We have the option of exploring it for free with the 30-day trial plan. Using this plan, we can: Use the Office 365 suite Create & run Canvas App Create & run Model-driven App Create & manage Microsoft Dataverse Create automated workflows using Power Automate Create & manage Environments What happens when my trial expires? It can be extended up to 90 days (30 days each, 2 times) CREATING WORK-SCHOOL ACCOUNT Step 1 : Open 👉  Office 365 Plans  👈 in a new browser window/tab Step 2 : Try for free the Office 365 E3 plan Step 3 : Enter a personal email and click Next. Step 4 : Click Set up the account and fill in your details. Verify your phone number. Step 5 : Enter a username and domain name and se...

What is my perception of “ Microsoft Power Platform ”? Data is a big part of Enterprise. All the business processes & applications are built, based on how we use data for different purposes. We build web and mobile applications, create visualization charts for business insights, we want to automate processes that are mundane, build services for backend jobs, and so on. And, to achieve these multiple requirements, we have to choose from a huge market of numerous applications and tools. Wouldn't it be awesome if we can access, connect and automate all these numerous applications in a single place?😱 Well, here is our answer to that: “ Microsoft Power Platform ”! And, I believe that this Platform is ultimately going to help us to refine most business processes/apps using minimal technical expertise! Check out this Suite!🤩 1. Power Apps : A low-to-no-code custom app builder. The Power App is responsive and can run smoothly on browsers as well as Mobiles phones/Tablets. We can ...