For a gallery I have a connection to SQL database to get my list. In the SQL table I have added a new column and entered some data. When I try to refresh the connection from within powerapps, nothing happens. When I reference the table by name I get the error that the identifier could not be found (or something like this).
So, I deleted the connection entirely and made a completely new one. Same error.
Does anyone know what the issue might be?
I know for sure the column exists and that the name is spelled correctly. Just that the column definition isn't updated in Powerapps.
How can I force this update to happen?
Solved! Go to Solution.
Did you remember to include a primary key in your table?
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."
I think this has been buggy for quite a while. Is it on-prem SQL that you're using? If so, restarting the gateway can sometimes help.
Glad that's working @agneum. Out of interest, what kind of delay was there between you making the change in SQL, and seeing it in PowerApps? Was it 10s of minutes, or hours?
Check out new user group experience and if you are a leader please create your group
Next call is happening on April 21st at 8a PST.
May the fourth be with you, join us online!
See the latest Power Apps innovations, updates, and demos from the Microsoft Business Applications Launch Event.