You’re offline. This is a read only version of the page.
Announcements
44
Hey experts hopefully you can help me with this one it's a doozy.
So I have 3 environments Test->QA->Prod. In the test environment I have developed an app in an unmanaged solution and am importing it into QA as an unmanaged solution.
I have the SQL Server connector setup inside the solution so when I move it into the QA environment I get to choose the QA SQL connection. All of the flows that were in the solution successfully pick up the new connection; however, the tables and flows all have errors inside the actual PowerApp. Meaning to fix the issue I have to manually remove the flows and SQL connections and re-add them to have the connections work correctly. The error message that appears when I try to refresh a table is "Failed to retrieve appDataSourceConfig"
There are some other similar tickets out there that don't have a solution.
Here they just gave up and re-added/re-created the connection:
@nihar had basically the same question here and no one answered:
@ANB had what looked like a solution here but following these steps I still get the above mentioned error:
Is there a solution to this problem or perhaps different steps that I should be doing to not receive this error?
After scouring old forum posts I have finally found something that solved the issue. Doing these steps in the dev environment before importing it into QA and Prod:
From @MattStannett and this post: https://powerusers.microsoft.com/t5/Building-Power-Apps/Unable-to-add-SQL-Server-connection-to-imported-app-inside-a/td-p/719916
There is a possibility that you forgot to save the app after you re-added the connections last time. Hence the old connections are still there in the backend and that prompts the message.
Therefore, could you please follow these steps and let me know the result?
Thanks again for your time and cooperation.
Share
Report
All responses (
Answers (
