Power Platform

Every organization must protect its data while ensuring that the right people have access when they need it. Microsoft Power Platform offers a feature called hierarchy security , which makes controlling access easier and more precise, even in complex environments. In this guide, we'll walk you through the basics in plain language. What Is Hierarchy Security? Hierarchy security is an extension of existing security models in Power Platform (like business units, security roles, sharing, and teams). It helps you define who can see what data by building a logical structure based on a company's management or job roles. Essentially, it lets you assign access rights using a "chain of command" or a "position" setup. This method is not only more granular (or detailed) but also reduces the effort required to manage many business units manually. The Two Key Models There are two common ways to organize hierarchy security: 1. Manager Hierarchy The manager hierarchy is ba...

Power BI offers powerful DAX functions, and RANKX is one of the most useful when you want to assign ranks based on measures like sales, profit, or quantity. But if you're new to it, it might not work as expected at first. In this blog, I'll walk you through a real-world scenario where I explored RANKX, faced common issues, and how I solved them. Syntax of RANKX RANKX(     table,     expression,     [value],     [order],     [ties] ) Parameter Description table The list (table or column) over which ranking is done. expression The expression to evaluate for each row (usually a measure like [total sale]). Value(optional) A value to rank (rarely used; DAX infers automatically). order(optional) ASC (ascending) or desc (descending). Default is asc ties(optional) How to handle ties: skip, Dense  or leave blank (default is Skip ). our goal is we want to calculate a rank for products based on total sales usi...

 What is SVG? SVG (Scalable Vector Graphics) is an XML-based vector image format for two-dimensional graphics. Unlike raster images (like PNG or JPG), SVGs don’t lose quality when scaled , making them perfect for responsive and sharp UI designs. Key Benefits of SVG: Scalable without losing quality. Lightweight compared to image files. Customizable using CSS or inline styles. Supports interactivity and animations. Ideal for icons, shapes, progress indicators, graphs, etc. How to Use SVG in Power Apps – Step by Step Step 1: Get Your SVG Code You can get SVG code from: https://www.svgrepo.com/ https://fonts.google.com/icons Or export from tools like Figma, Adobe Illustrator etc Or you can use Microsoft Copilot or ChatGPT to create the SVG's for example just give prompt as give SVG code for progress bar Step 2: Convert SVG to a Data URI (if needed) Power Apps doesn’t support raw <svg> tags directly. Convert it to data URI format...

  Step 1: Install LocalDB Before proceeding, make sure LocalDB is installed on your computer. You can refer to the installation guide using this link . Step 2: Install SQL Server Management Studio (SSMS) Download and install SSMS by following this link . Step 3: Open SSMS Launch SQL Server Management Studio . You will see a window like the one shown below. Then, click on Connect . Step 4: Create a Database and Tables After connecting to the server, create a new database and the required tables as shown in the image below. To create a database: Right-click on Databases in the Object Explorer Select New Database Provide a name and click OK To create a table: Expand your newly created database Right-click on Tables Select New Table , then define your columns and data types Step 5: Install the On-Premises Data Gateway To connect your local database with cloud services like Power BI or Power Apps, you need to install the On-Premises Data Gateway . 👉 Click on this lin...

We are uploading files through Power Apps using the Attachment control. In the backend, a Power Automate flow uploads these files to OneDrive and assigns unique permissions . Since Power Automate does not have a built-in connector to directly assign unique permissions in OneDrive, we are handling this through the Microsoft Graph API (without using a custom connector). Step 1: Create a Blank Power Apps Application Open Power Apps Studio. Select New app > Start with a page design as shown below. Step 2 :  select Blank Canvas  Step 3: Add an Attachment Control In Power Apps, the Attachment control is not available directly from the standard controls list. To get the Attachment control: Add an Edit Form to your app. Connect the form to a SharePoint list . Once connected, the form will automatically include the Attachments field. You can then use this Attachment control to upload files. Step 4: Keep Only the Attachment Control Since we only need th...