Power Platform Community Forum Thread Details

question.
We have an application/system ABC that wants to handover to us on monthly basis an Excel with 6000 id's.
We use that Excel to filter data out of our data warehouse and send it back to the application ABC. The data is a combination of data from several SQL tables. Our database is SQL DB. Selecting and combining the data is done in Azure Data Factory (ADF).

What would be the best way to do?

Building a Power Apps in which application ABC can upload an Excel to sharepoint, which is input for our ADF?

Or building a Power Apps in which application ABC can upload an Excel to blob storage, which is input for our ADF?

Or building a Power Apps, embedded in a Power BI report that is placed in a workspace. And they can use that Power Apps to on-the-fly update our SQLserver table that stores the 6000 id's. The table is our responsibility, the content theirs.

I am pretty new to the Power Platform

Regards
Ron

@WarrenBelz

@RandyHayes

Categories:

Building Power Apps