I've since found that you basically need to remove the Data Source to that table or view and re-add it to have changes reflected. However, the Data Connection to the database doesn't need to be changed.
A restart of the on-premises gateway and a refresh of the data source did the trick for me. Not sure how this would work with an Azure DB though.
Same issue here, using On-Premise Data Gateway and MS Flow. Haven't tried the gateway restart yet, but simply re-adding the data source didn't do the trick. My new table is still a ghost.
Microsoft - if anyone is listening, I can see this becoming a major pain. Please fix!
I've simply gotten into the habit of always removing and re-adding the view if I make any sort of add/remove/updates. I've never ran into an issue on either Azure SQL or on-prem SQL servers where I couldn't see a column that exists on the database after removing and re-adding the table/view. I would investigate the logs of the on-prem gateway to see if they shed any light on the health of the gateway. Perhaps there is something conflicting with the software.
Is there already a fix for this?
When I change a view/table or add a view/table it's not reflected in Flow / powerapps!!
This is such an annoying bug.
I keep restarting my gateway (which is in production!)
The other "solution" is to wait 2 or 3 hours...
I had the same problem. Restarting the gateway and refreshing the data source in the Power App Studio worked.
I think that this may not be a great issue in a production environment because I suppose that only a few, structured, changes, are committed in a controlled fashion.
Anyhow it's a tricky way, undocumented, for performing a task that is common during the development phase.
I am also still having this problem. Any schema change does not reflect itself in powerapps or flow. This can take hours to correct itself. I do not have access to the gateway to restart it. Please fix it.
Check it out!
Check it out!
Fill out a quick form to claim your user group badge now!
Find out where you can attend!
Features releasing from October 2019 through March 2020