Skip to main content

Notifications

Announcements

Replay: Power Platform Community AMA - Copilot Studio | April
Welcome to the Power Platform Communities
News and Announcements icon
Community site session details

Community site session details

Session Id : N65/EA5FaMk7k4FVIKTdS5
Power Platform Community / Forums / Power Automate - Building Flows / Flow Trigger - SQL New...
Power Automate - Building Flows
Answered

Flow Trigger - SQL New Item Created

Like (0) ShareShare
ReportReport
Posted on 25 Mar 2020 15:54:04 by mindrift_io 25

Hi there,

 

I am trying to set up a flow that triggers after a new row has been added in an SQL DB. I have set up and connected the SQL DB with Power Automate via a gateway and I have set up the first version of the flow. I added new rows to the SQL DB manually via MS SQL SMS, but the trigger does not react. When I test the flow it does work, but only takes the first/oldest row from the SQL DB as an output. I want the flow to only take the newly added row (which should trigger the flow) as an output for my following steps. Do I need to add a "Get row) step afterward? Why is the flow not triggering when I add new rows to the table? Why is it only taking the oldest row from the table as an output?

BR
Thomas

  • abm abm Profile Picture
    abm abm 32,464 Most Valuable Professional on 24 Jan 2022 at 00:02:50
    Re: Flow Trigger - SQL New Item Created

    Hi @calerof 

     

    Good question. Couple of workarounds for this but not straight forward.

     

    1. Create another table to keep track of the last updated date. Create a new flow scheduled trigger every day to check when is the last date created. If its nearing the 90 days limit then try to run the flow with some dummy value create or update.

    2. Create a custom connector. Pass the flowname and environment name. Check the run history. If its nearing the 90 days limit then try to run the flow with some dummy value create or update.

    See this blog about how to get run history

    How to create custom connector to get the flow run history - Power Platform/Dynamics 365 CE/DevOps Blog (d365dotblog.com)

     

    Thanks

  • calerof Profile Picture
    calerof 255 on 23 Jan 2022 at 14:34:26
    Re: Flow Trigger - SQL New Item Created

    Hi @abm ,

    What happens if there are no new records created in more than 90 days? I'm thinking of a dimension table that normally is not modified frequently. What would be a turn around to avoid the Flow to get disabled.

    Thanks,

    Fernando

  • mindrift_io Profile Picture
    mindrift_io 25 on 13 Apr 2020 at 07:21:39
    Re: Flow Trigger - SQL New Item Created

    Hi Bolandre,

     

    the issues was the table that I created in SQLSMS did not have a key ID value with incrementally increasing IDs. 

     

    https://stackoverflow.com/questions/10991894/auto-increment-primary-key-in-sql-server-management-studio-2012

     

    I created an auto-incrementing ID in the table and this was obviously needed for flow to understand the structure of the incoming rows.

     

    Hope this helps!

    BR
    Thomas

  • bolandre92 Profile Picture
    bolandre92 73 on 12 Apr 2020 at 17:16:50
    Re: Flow Trigger - SQL New Item Created

    Hi, 

    I am having the same issue and seems that you have solved it. Could you please stress more on this "The issue was that I did not define a key ID in my table" and how did you solve it step by step?

     

    That would be extremely helpful.

     

    Thank you 

  • Verified answer
    mindrift_io Profile Picture
    mindrift_io 25 on 27 Mar 2020 at 12:17:02
    Re: Flow Trigger - SQL New Item Created

    After some trial and error I found the solution myself. In case this might help somebody with the sme issue:

    The issue was that I did not define a key ID in my table. After adding a key to the table Power Automate correctly registers new rows in the table. Even when bulk inserting power automate correctly triggers the flow N amounts of times where N=the amount of rows added in bulk.

  • abm abm Profile Picture
    abm abm 32,464 Most Valuable Professional on 27 Mar 2020 at 01:03:21
    Re: Flow Trigger - SQL New Item Created

    Hi @mindrift_io 

     

    Sometimes the flow trigger take time to do all the refresh it needed. Is this working for you now? 

     

    Thanks

  • mindrift_io Profile Picture
    mindrift_io 25 on 25 Mar 2020 at 16:56:55
    Re: Flow Trigger - SQL New Item Created

    I disconnect and readded the connection to the DB and tried with the existing flow and with a new flow and nothing changed. I also added the rows with a tab and when using "Get rows" I can see all entries in the output. I would really like to know why the flow is not registering the new row and not triggering the flow as it should.

  • abm abm Profile Picture
    abm abm 32,464 Most Valuable Professional on 25 Mar 2020 at 16:28:52
    Re: Flow Trigger - SQL New Item Created

    Hi @mindrift_io 

     

    Existing trigger. Also when you enter manually make sure press tab to next row otherwise it won't treat as saving the record.

     

    Thanks

  • mindrift_io Profile Picture
    mindrift_io 25 on 25 Mar 2020 at 16:26:47
    Re: Flow Trigger - SQL New Item Created

    Do you mean a new connection to the existing DB or a new connection to another table?

  • abm abm Profile Picture
    abm abm 32,464 Most Valuable Professional on 25 Mar 2020 at 16:21:31
    Re: Flow Trigger - SQL New Item Created

    Hi @mindrift_io 

     

    Thanks for your quick reply. Could you add a new connection for the trigger and try?

     

    Thanks

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Replay: Power Platform Community AMA - Copilot Studio | April
Welcome to the Power Platform Communities

Quick Links

Understanding Microsoft Agents - Introductory Session

Confused about how agents work across the Microsoft ecosystem? Register today!

Markus Franz – Community Spotlight

We are honored to recognize Markus Franz as our April 2025 Community…

Kudos to the March Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 146,668 Most Valuable Professional

#2
RandyHayes Profile Picture

RandyHayes 76,287 Super User 2024 Season 1

#3
Pstork1 Profile Picture

Pstork1 66,004 Most Valuable Professional

Leaderboard

Featured topics

Start and wait for an approval action

Product updates

Microsoft Power Platform Community release plans