web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Powerapps form does no...
Power Apps
Answered

Powerapps form does not display some data after published

(0) ShareShare
ReportReport
Posted on by 638

I have a form that is displayed in Edit mode where the user can make changes to an entry and patch it in a SQL Db.

 

When playing and using it on the editor, all the fields in the form display with the data from the DB, when I publish the app, only some fields in the form display the data from the DB....

 

Absolutely no idea why this happens, I've verified 3 times the default item is set correctly and it still doesn't work....I have another form in another screen that performs the same job but facing a different table in SQL and that one displays all the values correctly.

 

I am also 100% sure the DB contains those values, as I'm looking at the entries as I write this....has anyone experienced this before?

Categories:
  • Verified answer
    timl Profile Picture
    37,422 Super User 2026 Season 2 on at

    Hi @jbrit2020 

    Can you confirm what the 'explicit column selection' is set to in your app. If it's enabled, can you disable it to see if it makes a difference?

    https://powerusers.microsoft.com/t5/Building-Power-Apps/Difficulty-get-records-from-a-SQL-Server-table/m-p/714504

     

     

  • jbrit2020 Profile Picture
    638 on at

    It works, thank you so much but it does puzzle me why that didn't impact the other Form?

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Leaderboard > Power Apps

#1
11manish Profile Picture

11manish 248 Super User 2026 Season 2

#2
WarrenBelz Profile Picture

WarrenBelz 192 Most Valuable Professional

#3
Mohsin Ali Profile Picture

Mohsin Ali 135

Last 30 days Overall leaderboard