Apologies as this is probably something very easy but I can't for the life of me find it.
I've created a flow which connects to an azure sql database successfully, It creates records and updates them. I've added another column to the SQL table but the column is not showing in flow. It's just a varchar(50) column. Is there a button to update the schema of the table so it shows as a parameter in the sql update action on flow please? Don't fancy recreating the whole sql part of flow everything I add a new column lol.
When testing this issue with SQL Server on-premises, the newly added columns could be synced to the flow after refreshing the browser.
Could you try to refresh the browser or wait for a moment to sync the table changes?
I guess it might be a sync issue.
Please let me know if you are still having the issue.
I'm dealing with a similar issue as well, however with deleted columns from a SQL table.
I've deleted columns from a table in an on-premises SQL Server database, and the updated columns are not disappearing in the flow. This is while I'm using the SQL Server "Insert Rows V2" connector.
Is this a known issue? How long should a sync take to occur?
I have encountered this very issue as well with an traditional SQL database. I added columns after creating my connection and they do not show up. After recreating my connection, the new columns showed up. Prior to that, I refreshed my browser and toggled between different SQL connections to no avail.
Posting this in the hopes it'll get some attention as this issue does not seem to be resolved thus far.
Features releasing from October 2020 through March 2021
We are excited to announce the launch of Power Virtual Agents Community. Check it out now!
We've updated and improved the layout and uploading format of the Power Automate Cookbook!
Fill out a quick form to claim your user group badge now!