Hello everyone,
I’m a beginner in the Power Platform, but I’m working on improving my skills as a side project. Currently, I’m working on a solution that will help me, my colleagues, and ultimately our customers.
We create repair quotes and inspection reports for medical devices, and I’d like to display this information clearly in PowerApps.
The starting point is an Excel file that contains the repair and inspection data for individual medical devices. Unfortunately, this file has to be downloaded manually by each customer advisor.
In my app, I’ve created a way to upload the file, along with other metadata, to a SharePoint library. So far, so good.
My question is how to proceed from here in the easiest way. The Excel data now needs to be processed and displayed in the app somehow.
My first idea was to use a Power Automate flow to automatically transfer the uploaded Excel data into a SharePoint list, which I could then retrieve in PowerApps.
But then I thought, maybe it’s simpler to access the Excel file directly (if that’s even possible). The Excel data is often only temporarily important anyway. What’s most important for the customer is a final overview that shows which spare parts for the medical devices have been ordered with installation costs and which without.
I’m realizing that the project requirements are exceeding my skills and understanding at the moment. But I don’t want to give up, and I’m hoping someone here can provide me with a bit of clarity and guidance.
Thanks in advance for your help!
Best regards,
