Powerapps connection to Azure SQL database is playing up again. This is a regular monthly occurance.
Last month we couldn't connect at all now it is so slow it take minutes to save or retrieve records. Again after a powerapps update!!
Now I'll wait for...give me your Session ID then 5 days of support emails without a resolution for 2 weeks...
Whilst user have to put up with it!
SESSION ID : 1d8270c1-3fb6-4997-8e30-b159be8e00651
Come on Microsoft this is pathetic now!
Solved! Go to Solution.
I got a problem connecting to Azure SQL database. The collections shows all fields when I connect to less SQL tables and the app is not complicated. But when I add more SQL connections and create more screens, the collections doesn't show value in some fields like below picture.
If I connect my app to Excel file (on premise machine), it never happens regardless the complexity of the app.
My Session ID is: 24eaaa6c-75a7-41f6-8a15-c503108cb7f7.
Thank you very much!
Can you check if you have the setting for Explicit column selection turned on? It is designed to reduce the columns that you are actually using in the app for better performance. You may have a mismatch of columns in the different places where the table is used with this feature on.
It was the culprit. It's strange that the columns I am using also disappears while turning on that "Explicit column selection". Anyway, if I turn it off, everything shows again.
Can you try turning ECS back on and then referencing the columns that don't have data in the app? You can use a formula or bind it to a UI control like a gallery. Please let us know if the data shows up.
Check out new user group experience and if you are a leader please create your group
Check out how to claim yours today!
Test your skills now with the Cloud Skill Challenge.
We are excited to announce that Demo Extravaganza for 2021 has started!
On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks