Hello,
My company is trying to transition from an Order Form built in Excel to either Power Forms, Power Apps, or Power Pages.
I have our customer's history modeled into a dataflow in Microsoft Fabric, and on the Order Forms I'd like them to be able to select a SKU they've previously purchased and see their purchase history of that SKU.
I've looked into which program can both have data uploaded into it from a dataflow in Microsoft Fabric AND then allow customer input to get back to us, but I can't decide which program can do both of these features.
Here are the issues I've run into with the three programs I've researched: Power Forms seems to not allow refreshable data to be uploaded through Fabric, Power Apps seems to be internal use only and not be allowed access by outside parties, and Power Pages seems to cost $200 per month per customer site (we have several customers).
Is there another Microsoft Program that would allow me to upload data into it from Microsoft Fabric, and then allow customers to input Order Quantities? Is there any work around the programs I mentioned to allow what we need?
Thank you,