'When a row is added, modified or deleted', Error on any input 'Filter Rows', 'Trigger Conditions'

(1) Share

Report

Posted on by EK-31101007-0

I need to trigger a flow when a item is added to a specific work queue.

The problem however is that whenever I put something into the option 'Filter Rows', for example "statecode eq 0" (Exactly as the placeholder text suggests), save the flow and go back to the flow overview, I'm getting the error "There's a problem that needs to be fixed to trigger this flow. To see more details, open Flow checker.", which details the error with the message "Exception parsing statecode eq 0 submitted for attribute filterexpression of callback registration. Target entity: workqueueitem. Exception: System.InvalidOperationException: AttributeTypeCode not valid:ManagedProperty..."

I did read about a workaround that involves going the action settings and adding a trigger condition from there.

However when I got to Action Settings and add a 'Trigger Condition' and enter

"@equals(triggerOutputs()?[‘body/_workqueueid_value’],"xxxx")" or anything similiar,
The Flow Check will report an error that says "Fix invalid expression(s) for the input parameter(s) of operation 'When_a_row_is_added,_modified_or_deleted'."

I have tried many different inputs and none of them seems to register, I am getting the same errors no matter what.

This does seem like a bug, because even the expression mentioned in the official documentation gives an error.

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (0)

Suggested answer

abc 123 784 Moderator on at

Like (0)

Report

Single Quotes (Apostrophe) is used to denote a literal string value

@equals(triggerOutputs()?[‘body/_workqueueid_value’],'xxxx')

Another possible issue is that if you've provided a view name, ensure that the field _workqueueid_value is actually in the View. (I have a hard time believing that you have a field named that, but maybe you do.)

Maybe it's a choice or lookup that needs:

@equals(triggerOutputs()?[‘body/_workqueueid/value’],'xxxx')

Final mention is that the fieldname is the internal field name, which can be found in the URL when in the Field Name settings view. (Not the one that on the main pane. That's the Display Name."

Was this reply helpful? Yes No
Suggested answer

Michael E. Gernaey 53,452 Super User 2025 Season 2 on at

Like (0)

Report

Hi

I would need to see your json but I do not believe this is correct

[‘body/_workqueueid_value’],

If it a property then its body?['property']

and usually body is something like [body][value][property[ or another variation, but that is why its not working / isn't the right syntax.

Can you please share your JSON (you can remove the trigger condition, and then run it, so you can see what the Input looksl ike so we can fix it)

Was this reply helpful? Yes No
EK-31101007-0 4 on at

Like (0)

Report
Thank you for the replies.

Certainly, here is the JSON coming in for the action "When a row is added, modified or deleted". Note that some values are removed or modified:

{ "headers": { "Connection": "Keep-Alive", "Expect": "100-continue", "Host": "", "x-ms-correlation-request-id": "", "x-ms-client-request-id": "", "x-ms-user-id": "", "Content-Length": "7908", "Content-Type": "application/json" }, "body": { "statecode": 0, "_statecode_label": "Köad", "statuscode": 0, "_statuscode_label": "Köad", "_workqueueid_value": "xxxx", "_workqueueid_value@Microsoft.Dynamics.CRM.lookuplogicalname": "workqueue", "_workqueueid_type": "workqueues", "createdon": "", "_ownerid_value": "", "_ownerid_value@Microsoft.Dynamics.CRM.lookuplogicalname": "", "_ownerid_type": "systemusers", "requeuecount": 0, "name": "TestItemMan1", "solutionid": "", "ismanaged": false, "processortype": 0, "_processortype_label": "Ingen", "priority": 200, "_modifiedby_value": "", "_modifiedby_value@Microsoft.Dynamics.CRM.lookuplogicalname": "systemuser", "_modifiedby_type": "systemusers", "iscustomizable": true, "modifiedon": "", "retrycount": 0, "componentstate": 0, "_componentstate_label": "Publicerad", "_createdby_value": "", "_createdby_value@Microsoft.Dynamics.CRM.lookuplogicalname": "systemuser", "_createdby_type": "systemusers", "componentidunique": "", "_owningbusinessunit_value": "", "_owningbusinessunit_value@Microsoft.Dynamics.CRM.lookuplogicalname": "", "_owningbusinessunit_type": "businessunits", "input": "[]", "uniqueidbyqueue": "", "workqueueitemid": "", "ItemInternalId": "", "SdkMessage": "Create", "RunAsSystemUserId": "", "RowVersion": "32593336" } }

Was this reply helpful? Yes No