Power Platform Community Forum Thread Details

I'm working on a PowerApp that uses SQL tables connected via an on-prem gateway as its primary data source. The app worked fine with just tables, but after this we added a SQL view to the app and I can't see any data in edit mode now.

For whatever reason we can still see the data in play mode, but every data source in edit mode shows an error reading "The specified record was not found. Server Response: [dbo].[Table Name] failed: Something went wrong."

I don't have a huge amount of experience with SQL in general, so I'm unsure as to why this would only happen when the SQL view was added to the app. Any suggestions or advice would be appreciated.

Categories:

Building Power Apps