Skip to main content

Notifications

Power Automate - General Discussion
Answered

SQL Trigger Issue - update one column then trigger sending message

(0) ShareShare
ReportReport
Posted on by 9

Hello all,

 

I have a SQL flow "When an item is modified (V2)",  and I want to receive a message when the column "Quoted" 's value [bit] has been updated to true

 

1.png

 

then I build the flow as below

2.png

 

the problem is:
no matter which column I update,  I will receive the message

such as "update Erp.QuoteHed set CustNum = 10 where quotenum = '100015'"

 

how to resolve this problem?

 

Thank you

 

 

  • Verified answer
    TommyDeng Profile Picture
    TommyDeng 9 on at
    Re: SQL Trigger Issue - update one column then trigger sending message

    To resolve the problem, I called the Support DL Microsoft, and they said the requirements are not supported .

    so i used another method to resolve the problem:

    1.build a triggle in MSSQL:when the quoted has been changed from false to true, add one row of data into a new table

    2.build a flow when an item is created v2 to monitor the table

  • manuelstgomes Profile Picture
    manuelstgomes 6,625 on at
    Re: SQL Trigger Issue - update one column then trigger sending message

    Hi @TommyDeng 

     

    The "Select Query" is not a valid query. Can you please check what is the query you need "select Quoted from Erp.QuoteHed where ...." for example.

     

    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

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,666

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,996

Leaderboard