Sql when an item is created filter context

(0) Share

Report

Posted on by drobinson

Using Sql when an item is created filter context(v2) I am trying to filer the sql table to only trigger when a status code equals QF.

The flow fails. I can get it to work if I leave filter out, but it gives me all status. I only want to be triggered when a new item with

IC_STATUS_CODE = QF.

I tried IC_STATUS_CODE eq QF

"The field 'QF' of the record wasn't found.\r\n inner exception: The field 'QF' of the record wasn't found.\r\nclientRequestId: 9b17012f-8afa-474d-bfc2-65f2111e4ccd",

All responses (2)

Answers (0)

v-bacao-msft on at

Like (0)

Report

Re: Sql when an item is created filter context

Hi @drobinson ,

Please try to use this expression:

Best Regards,
Pstork1 66,966 Most Valuable Professional on at

Like (0)

Report

Re: Sql when an item is created filter context

Its interpreting QF as a field name or variable and not a value. Normally in SQL you surround constants like this with ''. Try using

IC_STATUS_CODE = 'QF'