Replacing Excel Data Source in PowerApps

[Fly800]

I currently have a two (2) Excel data sources.  Both are data dumps from another database of which I don't have connection access rights.  My plan is to save these excel data dumps in a OD folder and assign them the same tables as the initial data dumps (read-only). 

I have made a Powerapps using the excel data dump and works very well.  When I insert the new Data dumps, the connection is lost.  I've noticed in the original excel data connections there is a column __PowerAppsId__ for both excel data sources is assigned by Powerapps.  When I replaced both new up to data excel data dumps, there is no longer a __PowerAppsId__ column even after doing a Data connect Refresh in Powerapps.

How can I relink the two excel data source each time I replace the data dumps.

How are you able to refresh the excel data dumps to include the __PowerAppsId__.

[v-monli-msft]

Hi @Fly800 ,

I'm not sure what you mean by "data dumps". Can you please explain more detail about your app and what you want to achieve? You can explain with some sample data. 

Regards,

Mona

[Fly800]

Hi Mona - What I meant by data dump is our corporate DBA performs two E1 ("Current Financial DB) query which is delivered in two (2) excel spreadsheets.  Our DBA at this time is not willing to provide us with a connection to E1 to Powerapps.  Until they feel comfortable, we compromised in using these data dumps in two excel sheets.  This data is for auditing and reporting purposes, so live data is not required at this time.  We will get these queries every week or so.  

Our business is to contract Construction projects for the Government.  The two excel sheets in the following data:

1. Project Data. i.e.  Contract #, Contractor, Date award, Award Amount, Operating Allowances,............
2. Change Order.  Contract #, Change order Description, Change Order cost, approval, ..........

I link each other using the SortByColumns and filter formula using Contract # as the relationship ID.

The App is to provide our project Coordinators means to audit their projects (i.e Is there outstanding Change Orders, Funding available, ........).

I hope this helps in providing a bit of context of my issue.

[TopShelf-MSFT]

Bumping to see if the community can assist. 

@TopShelf-MSFT