Virtual Table Connected to on-prem SQL issue with retrieving some records

(0) Share

Report

Posted on by Kimia_S-06112345-0

Hi all,

I’ve encountered a strange issue with virtual tables connected to an on-prem SQL database in a model-driven Power Apps application. All records display correctly in the view; however, when attempting to open the detail form, Power Apps throws an error stating that the record ID does not exist.

A few key details:

The ID column in the SQL table is defined as a primary key (number).
The issue only occurs for a few specific records.
There are no issues querying these records directly in SQL.
In Power Apps, the ID column is mapped as an External Key with a Float data type.

Any assistance or insights would be greatly appreciated!

I have the same question (0)

All responses (2)

Answers (0)

Suggested answer

Michael E. Gernaey 52,569 Super User 2025 Season 2 on at

Like (0)

Report

Virtual Table Connected to on-prem SQL issue with retrieving some records

HI @Kimia_S-06112345-0

It very well could simply by the conversion of Float from System to System. What are the exact values?

Here is a great way to find a better answer to the question and what it thinks is the problem.

Please follow these steps to look into Live Monitor for possible errors

1. Please go to PowerApps.com in the environment published
2. Please click the Apps menu option on the left
3. Find your App in the list and Click the ... at the end
4. Click Details ==> Live Monitor
5. Once it opens up, click Play Published App
6. When that Tab Opens, Play your App, Cause the issue
7. Go back to Live Monitor Tab
8. On the right side, click the Properties (its vertical) to open the right side window
9. In the Filter (Top Right) Type Error
--See if you have any errors
--if so, please scroll through them, real errors cause 4 lines (usually) of errors
----one of the 4 lines will populate the Properties window with 4 Tabs

10. Grab the Response Tab
11. Expand the Headers and Body Sections
12. See if you can share or understand the error

If this shows nothing please come back here.

If these suggestions help resolve your issue, Please consider Marking the answer as such and also maybe a like.

Thank you!
Sincerely, Michael Gernaey

Was this reply helpful? Yes No
Kimia_S-06112345-0 16 on at

Like (0)

Report

Virtual Table Connected to on-prem SQL issue with retrieving some records

Hi @Michael E. Gernaey,

Thanks for your reply!
I followed the instructions and I got 400 error fetching the record from PowerApps application.

The request is a "Get" request from PowerApps with url which gets the record based on its GUID and selects all the fields. And the below is the response tab

Any ideas?

Was this reply helpful? Yes No