{"id":924,"date":"2021-07-15T07:58:14","date_gmt":"2021-07-15T05:58:14","guid":{"rendered":"https:\/\/dynamiacs.com\/?p=924"},"modified":"2021-07-15T07:58:59","modified_gmt":"2021-07-15T05:58:59","slug":"filtering-in-cloud-flows-by-enums-from-dynamics-365-fo","status":"publish","type":"post","link":"https:\/\/dynamiacs.com\/?p=924","title":{"rendered":"Filtering in Cloud Flows by Enums from Dynamics 365 FO"},"content":{"rendered":"\n

You want to use data from Dynamics 365 Finance and Supply Chain in Power Automate and filter there for so-called values in enums and get stuck?<\/p>\n\n\n\n

Then I have a little tip for you.<\/p>\n\n\n\n

To get the right name for the enum, I use a “List Items present in Table” action:<\/p>\n\n\n\n

In this action I set the value for the filter query to the field and the value I want to filter. Here in my example I want to filter the entity SalesOrderHeadersV2 for open orders. The value for open orders is “Backorder” and is in the SalesOrderStatus field.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

With this filter query, I’ll just run my Cloud Flow test.<\/p>\n\n\n\n

The execution now runs on error because my filter query is not correct.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

In the Error Details I now find the hint to my error<\/p>\n\n\n\n

A binary operator with incompatible types was detected. Found operand types \u2018Microsoft.Dynamics.DataEntities.SalesStatus\u2019 and \u2018Edm.String\u2019 for operator kind \u2018Equal\u2019.<\/em><\/p>\n\n\n\n

which now brings me the hint to the correct value in the filter query:<\/p>\n\n\n\n

My correct filter must be here<\/p>\n\n\n\n

SalesOrderStatus eq Microsoft.Dynamics.DataEntities.SalesStatus\u2019Backorder\u2019<\/em><\/p>\n\n\n\n

because I want to filter on a value from an enum.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Now I run the flow again and voila, it runs through without error.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

I hope this helps you.<\/p>\n","protected":false},"excerpt":{"rendered":"

You want to use data from Dynamics 365 Finance and Supply Chain in Power Automate and filter there for so-called values in enums and get stuck? Then I have a little tip for you. To get the right name for the enum, I use a “List Items present in Table” action: In this action I…<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_kad_blocks_custom_css":"","_kad_blocks_head_custom_js":"","_kad_blocks_body_custom_js":"","_kad_blocks_footer_custom_js":"","_kadence_starter_templates_imported_post":false,"_kad_post_transparent":"","_kad_post_title":"","_kad_post_layout":"","_kad_post_sidebar_id":"","_kad_post_content_style":"","_kad_post_vertical_padding":"","_kad_post_feature":"","_kad_post_feature_position":"","_kad_post_header":false,"_kad_post_footer":false,"_kad_post_classname":"","footnotes":""},"categories":[8],"tags":[11,188,173],"class_list":["post-924","post","type-post","status-publish","format-standard","hentry","category-blog","tag-dynamics-365","tag-filter","tag-power-automate"],"taxonomy_info":{"category":[{"value":8,"label":"Blog"}],"post_tag":[{"value":11,"label":"Dynamics 365"},{"value":188,"label":"Filter"},{"value":173,"label":"Power Automate"}]},"featured_image_src_large":false,"author_info":{"display_name":"Jan","author_link":"https:\/\/dynamiacs.com\/?author=2"},"comment_info":0,"category_info":[{"term_id":8,"name":"Blog","slug":"blog","term_group":0,"term_taxonomy_id":8,"taxonomy":"category","description":"","parent":0,"count":38,"filter":"raw","cat_ID":8,"category_count":38,"category_description":"","cat_name":"Blog","category_nicename":"blog","category_parent":0}],"tag_info":[{"term_id":11,"name":"Dynamics 365","slug":"dynamics-365","term_group":0,"term_taxonomy_id":11,"taxonomy":"post_tag","description":"","parent":0,"count":14,"filter":"raw"},{"term_id":188,"name":"Filter","slug":"filter","term_group":0,"term_taxonomy_id":188,"taxonomy":"post_tag","description":"","parent":0,"count":2,"filter":"raw"},{"term_id":173,"name":"Power Automate","slug":"power-automate","term_group":0,"term_taxonomy_id":173,"taxonomy":"post_tag","description":"","parent":0,"count":6,"filter":"raw"}],"_links":{"self":[{"href":"https:\/\/dynamiacs.com\/index.php?rest_route=\/wp\/v2\/posts\/924","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/dynamiacs.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/dynamiacs.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/dynamiacs.com\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/dynamiacs.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=924"}],"version-history":[{"count":1,"href":"https:\/\/dynamiacs.com\/index.php?rest_route=\/wp\/v2\/posts\/924\/revisions"}],"predecessor-version":[{"id":925,"href":"https:\/\/dynamiacs.com\/index.php?rest_route=\/wp\/v2\/posts\/924\/revisions\/925"}],"wp:attachment":[{"href":"https:\/\/dynamiacs.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=924"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dynamiacs.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=924"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dynamiacs.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=924"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}