Thanks for the reply @v-yuazh-msft.
Actually before posting this qus, i tested it at my end using onpremise data gateway and it worked fine for me. But the issue i am facing is, third party vendors are managing onpremise database. They have configured the onpremise gateway and shared the connection with service account, using that service account i have configured the MS flow to trigger on insert/update of sql table. Now when we do a insert in sql table, MS flow doesn't trigger. Its not showing any failed or Error in run history.
but I can see many "Skipped entry" in Checks(no new data) in run history section. Can you please help me on this issue.
After going through some blogs i was wondering whether trigger suppose to work or not for onpremise sql server.[https://flow.microsoft.com/en-us/blog/introducing-triggers-in-the-sql-connector/]
Since you have confirmed it, can you please advice me on some troubleshooting steps. Just to mention i am new to MS flow and trying to get all the helps to solve this issue. Many thanks !