I want help building out a PowerApp that is essentially an order form. More specifically I want users to be able to select an item (SKU) to order, add in the quantity, and then submit. They need to be able to add multiple items/SKUs and specify individual quantities for each. The only other pieces of information I want to collect on this form are the person ordering, and also the location/facility for which they want to order these items. To prove out this concept, I can provide you with an excel sheet of valid items to be ordered and also valid locations/facilities. Longer term I want to integrate a Power BI semantic model to drive the list of valid items and also use it to display the quantity of those items that have been ordered in the last xx months. I also want to embed a power BI report (that I will build) somewhere on the Power App for quick reference. I will build a Power Automate flow that kicks off when an order form is submitted. So all I really need at the moment is someone to help me with the Power App side. Bonus if you have experience in Power Automate and Power BI, but I will plan on handling those pieces.
