Announcements
Hi,
Does anyone has solution for when a row is modified in sql server the flow to trigger?
Thanks in advance
I did figure this out, I created Timestamp column in sql and flow works fine now.
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
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
Still after adding timestamp column , my trigger did not work.
@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 ,
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
Regards,
@na12063 , Thanks for the suggestion. i have added rowversion column manually in my ERP table and its working 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.
Congratulations to our 2026 Super Users!
Congratulations to our 2025 community superstars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Haque 598
Valantis 477
Vish WR 370
