Unanswered

Dynamics Dataverse: When a row is added ODATA filter

(0) Share

Report

Posted on by sobenson

169

I am building a flow from Dynamics "Quotes" table using the Dataverse: When a row is added, modified or deleted. I was trying to filter the query to only pick up new Revision '0' Quotes.

{D58054BD-AC2B-4BFF-AA07-640533F82603}.png

I tried

revisionnumber eq '0'
revisionnumber eq 0
revisionnumber ne '1'
revisionnumber ne 1

the raw output is showing

"revisionnumber": 0,

but when I have the filter in place the flow will not run.

My solution was remove the filter statement and add a condition,

{1EA6EA09-1282-4142-AAD0-73B16EDC7DAD}.png

but in an effort to be better, why did the filter not work?

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (0)

Sundeep_Malik 6,484 on at

Like (0)

Report

Hey @sobenson
In dataverse you have to write the publisher Id/code before column name.
So it's like
C123column name eq '0'
Something like this.

Was this reply helpful? Yes No
v-liwei-msft on at

Like (0)

Report

Hi @sobenson

Could you please tell me:
Do you mean that input in Trigger's Filter rows does not trigger flow?
You should use the logical name of the column.

Best Regards,
Levi

Was this reply helpful? Yes No
sobenson 169 on at

Like (0)

Report

Hi @v-liwei-msft I believe I was using the correct name
and yes, the flow will not trigger if I have the statement above in the filter of the trigger.

Was this reply helpful? Yes No
sobenson 169 on at

Like (0)

Report
Hi @Sundeep_Malik where would I find the publisher Id/code?
Here is a portion of the raw output from the trigger. In the middle you can see that it is just called "revisionnumber"
"_modifiedby_value@Microsoft.Dynamics.CRM.lookuplogicalname": "systemuser", "_modifiedby_type": "systemusers", "shippingmethodcode": 864630000, "_shippingmethodcode_label": "FCA", "revisionnumber": 0, "_createdby_value": "2e896cb7-9cda-eb11-bacb-000d3a4fa9f8", "_createdby_value@Microsoft.Dynamics.CRM.lookuplogicalname": "systemuser", "_createdby_type": "systemusers", "hsl_powerbicostsheetreporturl": "https://app.powerbi.com/groups/d50154b7-7321-4f06-8dca-e140b92249cb/rdlreports/b431cee9-c071-4eb6-b52f-5d5dc94b67de?rp:Quotenumber=QUO-15079-P1Y9B9", "hsl_totalcost_state": 1, "hsl_totalcost_date": "2022-09-26T22:02:59Z",

Was this reply helpful? Yes No