Unanswered

Replacing Excel Data Source in PowerApps

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

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__.

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (0)

Sort by

v-monli-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Anonymous ,

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

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
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:

Project Data. i.e. Contract #, Contractor, Date award, Award Amount, Operating Allowances,............
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.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Bumping to see if the community can assist.

@Anonymous

Was this reply helpful? Yes No
lraeper 45 on at

Like
a
(0)

Report
Copy link

Link copied!

I'm currently facing the same issue, where I have a Power Automate process that replaces an Excel data file each week. My app linked to this Excel file works fine, until the file is replaced, then users get a 'No table was found with the name '%7B28B296AD-E14B-4510-A23A-8F3F2D5A7680%7D'. Anyone have a good solution for this?

Was this reply helpful? Yes No