Unable to add pre-existing data source (dataverse table) to a canvas app after having removed it from the app.

(1) Share

Report

Posted on by Salim_A_M

Hello,

On a live environment, there is a canvas application that needs modifications.

As to not mess with it there, I exported the app to a sandbox environment to freely work on it.

After messing around with it a bit, and not getting the test data that I was expecting to have in the app, I found out that despite the app now residing in the sandbox environment, it was still getting its data from the data sources on the live environment.

Thinking I could just remove the data source from the app and add it back in, I went ahead to do just that.

I removed the data source which I was working with from the app. Again, this is all on the sandbox environment.

Afterwards, I went ahead to add it back in, hoping this time, it would be the data source from the sandbox environment.

Problem is, it's not even showing up when I search for it.

The data source does exist in the sandbox environment, so I'm not sure why it won't appear.

I researched it a bit, and mostly messed around with the app's Settings>Upcoming Features panel, to no avail.

Any help in solving the problem would be greatly appreciated.

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (0)

Sort by

BCBuizer 22,654 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Hi @Salim_A_M ,

Did you move just the app to the sandbox environment, or as part of a solution?

In case you just moved the app, the issue is that the table doesn't exist in the sandbox environment, hence you can't connect to it.

To resolve the issue, you need to create a solution, add all components (app, table, etc.) and then export/import that to the sandbox environment. More information on how to do these things can be found here: Solutions in Power Apps - Power Apps | Microsoft Learn

Was this reply helpful? Yes No
Salim_A_M 98 on at

Like (0)

Report
Copy link

Link copied!

Hello, thank you for your reply.

The table does exist in the target environment, that's the crux of the problem.
Fortunately, I ended up asking a co-worker who gave me at least a fix.

Before adding the data source, I made sure to pick the correct environment through the below button:

Was this reply helpful? Yes No
BCBuizer 22,654 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi @Salim_A_M ,

Indeed if you want to connect to a table in another environment than the current one, you need to select it using the method you posted.

I understood you wanted to connect to the same table but in a different environment which is why I gave you the previous reply. Like that you can freely perform CRUD actions on your data source without impacting the production environment.

Was this reply helpful? Yes No
Salim_A_M 98 on at

Like (1)

Report
Copy link

Link copied!

Pardon me if I couldn't explain it properly.

All the tables present in the production environment are also present in the sanbox environment.
After moving the canvas app from the production to the sandbox, on its own- not in a solution, it still retained some of its data sources from the production environment for no reason I can discern.

I did indeed want it to be taking its data from the sandbox environment, so I used the above method to explicitly pick the sandbox environment so that the correct data sources showed.

That is all.

Was this reply helpful? Yes No