web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / SQL Server Trigger - W...
Power Automate
Unanswered

SQL Server Trigger - When Item is Modified - state change

(0) ShareShare
ReportReport
Posted on by 186

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

Categories:
I have the same question (0)
  • manuelstgomes Profile Picture
    6,625 on at

    Hi @LKS 

     

    SharePoint lists have that feature but not SQL Server. 

     

    You're correct in the approach. Create a Scheduled flow that queries the database and gets the values that you want to parse based on the criteria. You can create a stored procedure with all this logic. This way, you can refine your queries and logic on the database side without the need to change the flow.

     

    I know it's not the answer you're looking for, but I'm sure you'll be able to get the same result with this approach. If you need further help, please let me know, and we'll try to figure this out.

     

    If I have answered your question, please mark your post as Solved.
    If you like my response, please give it a Thumbs Up.

    Cheers
    Manuel

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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Expiscornovus Profile Picture

Expiscornovus 201 Most Valuable Professional

#2
David_MA Profile Picture

David_MA 174 Super User 2025 Season 2

#3
harshdeol Profile Picture

harshdeol 167 Moderator

Last 30 days Overall leaderboard