Power Apps Community : PAC

  How to Create your First App: MyLeads We will first setup a simple Excel worksheet as follows. ·       Create a new excel workbook on your windows pc ·       Create a tab called MyLeads ·       Add columns for all the fields you want Example Fields: BusinessName, ContactName, Email, Phone, Website, Comments, TypeOfBusiness, DateContacted, DateToFollowup ·       Select the range and format as a Table (Search for format as Table) ·       Name the Table: MyLeads ·       Save and close the excel workbook ·       Next, visit make.powerapps.com and login. ·       Click Start with data (under other ways to create an app) ·       Scroll down and click Upload an Excel file ·       Drag and drop in your MyLeads.xl...

  Blueridge Web Services BWS Our Story  “ Blueridge Web Services  ( BWS ) is a web design, database design, and application design company that works closely with our clients to understand their unique needs and goals. Our team of experts creates customized solutions that optimize search engine visibility, mobile compatibility, and visual appeal. We offer Database Driven Applications and powerful Mobile Apps that connect seamlessly to your Database, whether on-premise or in the cloud. Using the latest Power Platform and Power Apps Architecture, including Dataverse Storage and Copilot integration (AI) we deliver state-of-the-art solutions that integrate with Microsoft’s Power Platform.” Your team have access to your business applications everywhere 24x7! We can help you make it happen. Visit us today to learn more about our power platform cloud services.

 Use XrmToolbox and dbdiagram.io Tools for ERD Connect to Dataverse using XrmToolbox ( https://www.xrmtoolbox.com/ ) Generate 'script' of your selected entities like account and contact etc. https://dbdiagram.io/ Paste the script to dbdiagram.io and export, publish, or share the ERD of your Dataverse Entity Relationships When Exporting, it even creates the SQL statements to create tables if needed. (You don't need them for Dataverse, but you can feed them to Copilot or ChatGPT to generate 'Dataverse' fields instead for your own Tables. Example: Export Example for SQL: CREATE TABLE [account] (   [accountid] uniqueidentifier PRIMARY KEY ,   [masterid] lookup,   [msa_managingpartnerid] lookup,   [parentaccountid] lookup,   [primarycontactid] lookup ) GO CREATE TABLE [contact] (   [contactid] uniqueidentifier PRIMARY KEY ,   [accountid] lookup,   [masterid] lookup,   [msa_managingpartnerid] lookup,   [parentcontactid] lookup ) GO ...

"The prototype of BWS Smart Order Manager ." a Model-Driven Power App using Dataverse and the Power Platform The Navigation Panel on the left: Focus on Accounts A closer look at the Order and OrderDetail OrderTotal: The Total number of items Ordered is calculated with a RollUp Field on the Parent (Order) Table.  The user can also manually recalculate it anytime (using the Recalculate Button), but otherwise the system will do it every 12 hours on the server side according to Microsoft Documentation here:  Create a rollup column - Training | Microsoft Learn Use a rollup with sum aggregation to calculate the total number (Qty) or items ordered. You can calculate the $Total Amount for the Parent Order in a similar way (not shown here) Editable Grid Control Component in Action With GroupBy Enabled - Product Focus  Join our Discord Server Today:  https://discord.gg/kg3ZBbgAAg

  Welcome to the Power Apps Community "Knowledge Shared is Power Squared  " Join our Discord Channel   https://discord.gg/kg3ZBbgAAg      Welcome to the vibrant Power Apps Community ! This is a place where we not only build innovative apps but also learn and share valuable insights about Power Apps and the Power Platform . Dive into a wealth of resources including online training courses , comprehensive documentation , and instructive videos that cover product capabilities and practical guides . Empower yourself to swiftly construct low -code apps that modernize operations and tackle complex business obstacles within your organization . Let 's harness the power of Power Apps together ! Knowledge Shared is Power Squared! Discover how to make the most of Power Apps with online training courses, docs, and videos covering product capabilities and how-to articles. Learn how to quickly build low-code apps that modernize processes and solve tough business challeng...