Skip to main content

Notifications

Power Automate - Using Connectors
Answered

When an Item is Modified in SQL flow is not working.

(1) ShareShare
ReportReport
Posted on by 50

Hi,

Does anyone has solution for when a row is modified in sql server the flow to trigger?

Thanks in advance 

  • SachinG31 Profile Picture
    SachinG31 422 on at
    Re: When an Item is Modified in SQL flow is not working.

    @na12063 , Thanks for the suggestion.  i have added rowversion column manually in my ERP table and its working now. 

  • na12063 Profile Picture
    na12063 50 on at
    Re: When an Item is Modified in SQL flow is not working.

    @SachinG31 ,

    I recently created sql table and added Modified column which triggers the Power Automate flow:
    1. When an item is modified

    2. When an item is created or modified

    na12063_0-1653401777585.png

     

    Regards, 

     

  • SachinG31 Profile Picture
    SachinG31 422 on at
    Re: When an Item is Modified in SQL flow is not working.

    @na12063 @moutinhoabreu , I have the same issue , even after creating the timestamp column flow not working. i beleive you are also usnig D365 FO ERP.

    Please advise 

  • SachinG31 Profile Picture
    SachinG31 422 on at
    Re: When an Item is Modified in SQL flow is not working.

    @na12063 @moutinhoabreu , I have the same issue , even after creating the timestamp column flow not working. i beleive you are also usnig D365 FO ERP.

    Please advise 

  • Re: When an Item is Modified in SQL flow is not working.

    Still after adding timestamp column , my trigger did not work.

  • na12063 Profile Picture
    na12063 50 on at
    Re: When an Item is Modified in SQL flow is not working.

    Hi @moutinhoabreu ,

    Sorry for late respond did not see your respond. 
    So to make this work I created 
    SQL Columns:
    [Created] [datetime2](7) NULL,
    [Created_By] [nvarchar](250) NULL,
    [Modified] [timestamp] NOT NULL,
    [Modified_By] [nvarchar](250) NULL,

    FLow Use SQL Trigger 
    When an item is created or modified

  • moutinhoabreu Profile Picture
    moutinhoabreu 170 on at
    Re: When an Item is Modified in SQL flow is not working.

    HI @na12063 ,

     

    Can you explain on how to create a timestamp column on a table ?

    Or if we are able to verify if our table already has a timestamp column ?

     

    We use Power Automate over an ERP Sql and we try to avoid mess up with data base.

    If you can help I'll be very appreciated.

     

    Thanks

  • Verified answer
    na12063 Profile Picture
    na12063 50 on at
    Re: When an Item is Modified in SQL flow is not working.

    I did figure this out, I created Timestamp column in sql and flow works fine now. 

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

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,508

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,839

Leaderboard

Featured topics