Unanswered

ODATA filtering new Zendesk ticket start conditions not working?

(1) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hey everyone,

I'm trying to build a Flow that triggers when only certain types of Zendesk tickets are created. We get hundreds of ticket submissions a day, and I only want it to trigger when the ticket's metadata field "ticket_form_id" is of a certain value (12345678).

I've got the whole Flow working smoothly but this condition start is stymying me. Do point out if I'm misinterpretting its value, but I've been trying to use the 'Filter Query' option buried underneath the Zendesk new item trigger.

The Odata format for the filter that I have been trying to use has been 'ticket_form_id' eq '12345678' without any success. Out of curiosity, I switched it to be even simpler : 'subject' eq 'test', and the Flow will still trigger despite the ticket subject being 'bla'.

I'm officially out of brainpower, so any help getting this one working would be fantastic!

Thanks,

Scott

Categories:

General topics

I have the same question (1)

All responses (6)

Answers (0)

v-xida-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @Anonymous,

Could you please share a screenshot of your flow's configuration?

Thanks for your feedback, the issue is confirmed on my side. I afraid that the OData query is not supported in Zendesk connector of Microsoft Flow currently, if you would like this feature to be added in Microsoft Flow, please submit an idea to Flow Ideas Forum:

https://powerusers.microsoft.com/t5/Flow-Ideas/idb-p/FlowIdeas

Best regards,

Kris

Was this reply helpful? Yes No
ChrisC 94 on at

Like (1)

Report
Copy link

Link copied!

Might be simpler to use a condition logic that ends the flow on a lose condition

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

Yeah, I've got that in place as a workaround but it still consumes runs that way.

As we get 100's of tickets a day (sometimes 1000's), I was looking to cut off the Flow before it could start and thus save us having to buy lots of extra flow runs.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

Great, thanks for confirming that Kris. Good to see I'm not going crazy...

I can't figure out how to put a picture on these forums, but the filter query that I'm using in the Zendesk trigger condition is:

ticket_form_id eq '12345678'

Have tried it with and without 's, using alternate field names (i.e. subject) and none of them seem to work well.

Was this reply helpful? Yes No
Alphie 48 on at

Like (1)

Report
Copy link

Link copied!

Have you tried losing the single quotes around the number?

Was this reply helpful? Yes No
Craig_Humphrey 190 on at

Like (0)

Report
Copy link

Link copied!

Did anyone come up with a working solution for this?

There are still neumorous reports of filtering being broken in the ZenDesk connector - dispite it being presented in the UI.

Was this reply helpful? Yes No