Hi,
I try to filter an Odata query on a Primary position that is assigned to an employee.
I used a connector with D365 Fin & Ops.
An employee can be assigned to several positions, but I only want the Primary position that he is assigned to.
The part with PersonnelNumber eq '000034' works fine! But when I try to add the primary position query, it doesn't work anymore...
Here are the tests I did:
PersonnelNumber eq '000034' and IsPrimaryPosition eq 'Yes'
PersonnelNumber eq '000034' and IsPrimaryPosition eq Yes
Here is the field I want to filter on: it is a Yes/No checkbox field.
Hi @Frog64
Try
PersonnelNumber eq '000034' and IsPrimaryPosition eq true
If you liked my response, please consider giving it a thumbs up
Proud to be a Flownaut!
Learn more from my blogHi @abm,
I tried but it doesn't work: An error has occurred. A binary operator with incompatible types was detected. Found operand types 'Microsoft.Dynamics.DataEntities.NoYes' and 'Edm.Boolean' for operator kind 'Equal'.
When I look at the output of this step, here is the result:
"IsPrimaryPosition":"Yes"
I tried:
IsPrimaryPosition eq 'true'
IsPrimaryPosition eq 'True'
IsPrimaryPosition eq 'Yes'
IsPrimaryPosition eq 'yes'
IsPrimaryPosition eq '1'
Does someone have an idea?
Thanks
Hi @Frog64
Thanks for the update. If your output is 'Yes' then it should work with IsPrimaryPosition eq 'Yes'
try
IsPrimaryPosition eq 1
If you liked my response, please consider giving it a thumbs up
Proud to be a Flownaut!
Learn more from my blogI already tried but it doesn't work 😥
Hi @Frog64
I don't have D365 Fin & Ops to try this. Hopefully someone from community help you soon.
Thanks
If you liked my response, please consider giving it a thumbs up
Proud to be a Flownaut!
Learn more from my blogTry this:
IsPrimaryPosition eq Microsoft.Dynamics.DataEntities.'Yes'
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
Did you know that you could restore a deleted flow? Check out this helpful article.
Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.
User | Count |
---|---|
32 | |
32 | |
24 | |
24 | |
20 |
User | Count |
---|---|
62 | |
57 | |
43 | |
37 | |
28 |