Posts

Power Apps SharePoint Pagination: Load 500 Records at a Time Using Index_Id

When working with large SharePoint lists in Power Apps, you may hit the delegation limit if you try to load more than 2,000 records at once. To build an efficient app that scales beyond this, we can use a custom pagination technique — loading data 500 records at a time using a numeric Index_Id column. In this post, I’ll walk you through a fully working solution that loads SharePoint list items in chunks, supports “Next” and “Previous” buttons, and avoids delegation issues by leveraging indexed fields.
1 comment
Read more

Steps to Embed a HTML Page in a Model-Driven App Form

Image
 Step 1: Upload the HTML file as a Web Resource Open your solution, then click on + New and select Web Resource. Add your HTML code. Set the File Type to 'Webpage (HTML)', provide a Name and Display Name, then click Save. HTML CODE: <!DOCTYPE html> <html> <head>     <title>Account Info</title>     <meta charset="utf-8" />     <script src="ClientGlobalContext.js.aspx" type="text/javascript"></script>     <style>         body {             font-family: "Segoe UI", sans-serif;             padding: 20px;         }     </style> </head> <body>     <h2>Account Information</h2>     <p> <strong>Record Id:</strong> <span id="id">Loading...</span><br/> <strong>Entity Name:</strong> <span...
Post a Comment
Read more

Steps to Embed a Canvas App Page in a Model-Driven App Form

Image
Step 1: Go to your solution and create a Canvas App page . Refer to the image below for guidance. Step 2: The Canvas App page will open in Power Apps Studio. In the OnStart property of the app, add the following code: Set ( a , Param ( "recordId" )) ;       // Returns the record ID Set ( b , Param ( "entityName" )) ; Next, insert a Label control and set its Text property to: "a: " & a & "" & Char ( 10 ) & " b: " & b & "" & Char ( 10 ) This will display the values of the parameters passed from the model-driven app. Finally, give your custom page a name and publish it. Step 3: Add the custom page to your Model-Driven App by editing the app in the App Designer. Refer to the image below for detailed steps. Then, select the custom page you added and uncheck the "Show in navigation" option. This ensures the page doesn't appear in the app’s left-hand navigation but can still be open...
1 comment
Read more

Enhancing Data Security with Hierarchy Security in 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...
Post a Comment
Read more

Mastering the RANKX Function in Power BI – From Common Errors to Dynamic Rankings

Image
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...
1 comment
Read more

Supercharge Your Power Apps Look with SVG

Image
 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...
Post a Comment
Read more