New columns in SQL table doesn't show up

[agneum]

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?

[mdevaney]

@agneum 

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."

[timl]

Hi @agneum 

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.

https://powerusers.microsoft.com/t5/Building-Power-Apps/Refreshing-SQL-Server-Schema-in-PowerApps/m-... 

[agneum · Accepted solution]

Yup, it has a primary key that's auto-incrementing. I could see the column now, maybe it just needed more time...

I think it's strange because I both updated AND removed the reference from here without it recognizing the column definitions.

[timl]

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?

[agneum]

@timl  It was about 15 minutes maybe, and that's after me updating everything in the left pane and re-adding the connection.