Unanswered

Odata filter in dataverse connector not working properly

(0) Share

Report

Posted on by dpjatoch

Hi guys,

Created a flow which checks a couple of values in Dynamics records. This works perfectly except for that i'm getting the wrong records. Typeplan codes shows me a record which has typeplan code of 425360002. Any idea why this is? I'm thinking something is wrong in my OR but i'm not sure why.

thank you in advance

bx_type eq 425360002 and statuscode eq 1 and enddate gt @{addToTime(utcNow(), 30, 'day', 'yyyy-MM-dd')} and enddate lt @{addToTime(utcNow(), 31, 'day', 'yyyy-MM-dd')} and (bx_typeplan ne 425360000 or bx_typeplan ne 425360001 or bx_typeplan ne 425360002 or bx_typeplan ne 425360004)

Categories:

Using connectors

I have the same question (0)

All responses (2)

Answers (0)

okeks 802 Super User 2024 Season 1 on at

Like (0)

Report

It is probably because your query checks right at the beginning if "bx_type eq 425360002".

I guess you want to have "bx_type ne 425360002" instead as in the rest of your query.

Was this reply helpful? Yes No
dpjatoch 26 on at

Like (0)

Report

Thank you for your reply,

They are both different fields, the number is equal because this is our dataverse "standard".

I have managed to solve the problem now by adding EQ : everything i want to see. It's ugly, but it works. still weird that NE doesnt work.

Was this reply helpful? Yes No