PowerAutomate does not recognize SQL OnPremises Schema changes in tables

(0) Share

Report

Posted on by schwibach

Hello,

when I add a new table, it takes PowerAutomate some time to find that table.

It usually takes a few minutes, sometimes about an hour until it finds the new table.

When I change a table (for example add a column) or change a column type (varchar(50) instead of varchar(20)) it may take a few hours, in rare cases I have to delete the action and then re-add the action.

So, my question is: is there a manual process to refresh the schema of the elements of the database so it will work immediately?

Thank you!

All responses (2)

Answers (0)

schwibach on at

Like (0)

Report

Re: PowerAutomate does not recognize SQL OnPremises Schema changes in tables

Where is that tab?
Here in the Admin Center?

If you have a screenshot, that would help me out a lot.
FLMike 31,242 on at

Like (0)

Report

Re: PowerAutomate does not recognize SQL OnPremises Schema changes in tables

@schwibach

Hi,

When you make changes to any datasource, you should go to the Data (Tab), click the ... by the Source name and choose refresh.

If not it can take a long time.

If you like my answer, I would really appreciate if you please Mark it as Resolved, and give it a thumbs up, so it can help others

Cheers

Thank You
Michael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsoft
https://gernaeysoftware.com
LinkedIn: https://www.linkedin.com/in/michaelgernaey