Flow with SQL Server and Windows Form application

[Anonymous]

A basic easy question: I am developing an in-house Windows Form application that uses SQL Server for a db backend but this program will need to have one or more flows attached to it.  I am assuming this answer is yes, but I do not want to assume and get into this project too much if the answer is no.  Can Flow be used in conjunction with SQL and a Windows form program?  I have only used flow currently with SharePoint lists and Power Apps.  Thanks

[v-yamao-msft · Accepted solution]

Hi @Anonymous,

Microsoft Flow is now able to connect to SQL Server, see more details at here:

https://flow.microsoft.com/en-us/blog/on-premises-data-gateway/

https://flow.microsoft.com/en-us/blog/introducing-triggers-in-the-sql-connector/

However, I am afraid that Flow is not able to connect to the Windows Form Application directly. While if you are familiar with Custom APIs, you might try to call APIs to build custom connectors with their own triggers and actions.

For more details about Custom connectors, please check it at here:

Custom connectors overview

Custom connectors in Microsoft Flow

Best regards,

Mabel Mao

[Anonymous]

Thanks and I would not need Flow to get into the UI of the form directly, but need to be triggered from a change, update, insert into a SQL db table.