BWS Smart Order Manager Prototype

"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

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


Comments

Post a Comment

Popular

Welcome to Power Apps Community

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

XrmToolbox and dbdiagram.io

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