Hi,
Does anyone has solution for when a row is modified in sql server the flow to trigger?
Thanks in advance
@na12063 , Thanks for the suggestion. i have added rowversion column manually in my ERP table and its working now.
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 @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
@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
Still after adding timestamp column , my trigger did not work.
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
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
I did figure this out, I created Timestamp column in sql and flow works fine now.