Hi guys
I want to build a Purchase Order approval flow but I am struggling to get off the starting line.
This is the scenario:
Users are releasing Purchase Orders in Dynamics NAV 2017, which in SQL changes the Status field of the Purchase Order from Open to Pending Approval. I want the flow to kick in when the status changes from Open to Pending Approval.
Is this possible using the SQL Server trigger? Otherwise I am thinking of running a reccuring flow but I think I would have the same issue about monitoring a single column.
Thanks for your help.
Lukas


Report
All responses (
Answers (