Answered

gateway record not found something went wrong

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

I setup a gateway and connected to it a couple days ago successfully in PowerApps, but this app does not seem to have been saved

Since then I have created a new app but am seeing the following error when trying to list the items from a table in the database:

"The specified records was not found. Server response [dbo][tableName] failed: something went wrong"

PowerApps can see the Connection, and can see all the tables in the connection, but it just can't seem to find any records in any of the tables.

I have tried a number of other tables in the database

I have tried recreating the App

I have tried recreating the Gateway and connection

I am able to see records if I setup a PowerApp Entity to the same gateway configuration

The same connection created for PowerApps above, works perfectly fine in Power Automate in a small test I created

I have seen PowerApps may not like a key made of multiple columns, but I believe this table's key is single int column

Running out of things to try, if anyone has any ideas

Categories:

Using connectors

I have the same question (0)

All responses (21)

Answers (2)

Sort by

Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Did you encounter this problem when you created the canvas app or when you configured Flow?

If it is the former, it seems that you should submit this issue on the PowerApps forum.

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

Like (0)

Report
Copy link

Link copied!

I am having the exact issue. I can retrieve the data in Flow but not in PowerApps. Can someone guide.

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

Like (0)

Report
Copy link

Link copied!

The error first appeared when accessing from PowerApps

Even while PowerApps shows this issue/error, Flow (aka Power Automate) continues to function correctly when retrieving records

Was this reply helpful? Yes No
Verified answer

Community Power Pla... Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

Same issue. Can "see" and connect to tables on SQL but as soon as you bind a canvas control to it you immediately get "The specified record was not found. Server response [dbo][tableName] failed: something went wrong"

Authoring Version: 3.20084.9
On-Prem Gateway to SQL Server (2012)

I think this may be an issue with this authoring version (3.20084.9) and SQL Server 2012 (and perhaps earlier?) as when I try exactly the same app but to a different, SQL Server 2014 server, everything works fine.

Also, the downgrade to a previous authoring version works - though you can only seem to do that if you had the app for awhile - for the new app I just created today you don't get a choice to revert to a previous version.

I have raised a ticket with Microsoft but I only have the 8 hour email response service so if anyone hears before that please share !

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

Like (0)

Report
Copy link

Link copied!

Hi @Anonymous ,

I have Microsoft 365 E3 License. and I can use the SQL Premium connector in the Flow and also access the data. But in Power apps I am having this error, same situation where I can see the tables but not access the data.

Can you please share the solution, also is it anything to do with the license I have?

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

Like (0)

Report
Copy link

Link copied!

I don't believe this is a licence issue - I think (IMHO) it is (one of several) bugs with the latest 3.20084.9 release! Hopefully MS will address ASAP!

Was this reply helpful? Yes No
Verified answer

Community Power Pla... Microsoft Employee on at

Like (8)

Report
Copy link

Link copied!

Hi all,

I have been experimenting and I believe I have found the issue (with 3.20084.9).

I think it is the “Enable enhanced Microsoft SQL Server connector” which is now a default "preview" function in settings.

If you turn this OFF, my app starts working again - no more errors.

Of course, turning it off is not that simple as in order to toggle this off (or on) PowerApp makes you first REMOVE any SQL Server data sources that you have - my production app has 62 SQL Datasources so this is a major headache for me......but it works....

Looks like an issue with this preview feature and authoring version 3.20084.9

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

Like (0)

Report
Copy link

Link copied!

@Anonymous ,

Thank you !! This resolved the issue for me as well!

Was this reply helpful? Yes No
LH5 14 on at

Like (0)

Report
Copy link

Link copied!

@Anonymous

You are my hero! I have had the most panicked day and eventually came across your post. I did the same and my issue is resolved too!! THANK-YOU

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

Like (1)

Report
Copy link

Link copied!

Thanks @Anonymous your suggestion was bang on!

Disabling this feature and re-adding the SQL tables worked a charm (I did not have to recreate the connections)

Thanks again

Was this reply helpful? Yes No