Power Automate Exchange

Please login or click SIGN UP FOR FREE to create your FlowUG account to join this user group.
Expand all | Collapse all

When Item Is Created SQL Trigger

Jump to Best Answer
  • 1.  When Item Is Created SQL Trigger

    Gold Contributor
    Posted Jan 22, 2020 07:33 AM
    I'm trying to setup a flow that uses the when item is created trigger, uses an on-prem SQL server. But for some reason it's not firing when I run an insert into on the table i selected. Anyone have any experience using this trigger action? I'll eventually be migrating to azure SQL database so any experience on that side would be good as well.

    thanks!

    ------------------------------
    Sam Duval
    Data Quality Analyst
    Indianapolis
    ------------------------------


  • 2.  RE: When Item Is Created SQL Trigger
    Best Answer

    Gold Contributor
    Posted 28 days ago
    Never figured out the on-prem, various threads online indicate on-prem is not supported for this measure.

    For azure, the table must have an identity column to work. Once i moved the data up to azure and added an identity column, it works as expected.

    ------------------------------
    Sam Duval
    Data Quality Analyst
    Indianapolis
    ------------------------------