{"id":915,"date":"2021-07-15T07:54:47","date_gmt":"2021-07-15T05:54:47","guid":{"rendered":"https:\/\/dynamiacs.com\/?p=915"},"modified":"2021-07-15T07:58:25","modified_gmt":"2021-07-15T05:58:25","slug":"filtern-in-cloud-flows-nach-enums-aus-dynamics-365-fo","status":"publish","type":"post","link":"https:\/\/dynamiacs.com\/?p=915&lang=de","title":{"rendered":"Filtern in Cloud Flows nach Enums aus Dynamics 365 FO"},"content":{"rendered":"\n

Ihr wollt Daten aus Dynamics 365 Finance and Supply Chain in Power Automate verwenden und dort nach sogenannten Werten in Enums filtern und kommt nicht weiter?<\/p>\n\n\n\n

Dann habe ich hier einen kleinen Tipp f\u00fcr euch.<\/p>\n\n\n\n

Um an die richtige Bezeichnung f\u00fcr das Enum zu gelangen, nutze ich eine “List Items present in Table” Action:<\/p>\n\n\n\n

In dieser Action setze ich den Wert f\u00fcr die Filter Query auf das Feld und den Wert den ich Filtern m\u00f6chte. Hier in meinem Beispiel m\u00f6chte ich die die Entity SalesOrderHeadersV2 nach offen Auftr\u00e4gen filtern. Der Wert f\u00fcr offene Auftr\u00e4ge ist “Backorder” und steht im Feld SalesOrderStatus.<\/p>\n\n\n\n

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

mit dieser Filter Query lass ich nun meinen Test Cloud Flow einfach mal laufen.<\/p>\n\n\n\n

Die Ausf\u00fchrung l\u00e4uft nun auf Fehler, da meine Filter Query nicht korrekt ist.<\/p>\n\n\n\n

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

In den Error Details finde ich nun den Hinweis auf meinen Fehler<\/p>\n\n\n\n

A binary operator with incompatible types was detected. Found operand types ‘Microsoft.Dynamics.DataEntities.SalesStatus’ and ‘Edm.String’ for operator kind ‘Equal’.<\/em><\/p>\n\n\n\n

der mir nun den Hinweis auf den richtigen Wert in der Filter Query bringt:<\/p>\n\n\n\n

Mein korrekter Filter muss hier <\/p>\n\n\n\n

SalesOrderStatus eq Microsoft.Dynamics.DataEntities.SalesStatus’Backorder’<\/em><\/p>\n\n\n\n

lauten, da ich hier auf einen Wert aus einem Enum filtern m\u00f6chte.<\/p>\n\n\n\n

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

Nun lass ich den Flow erneut laufen und voila, er l\u00e4uft ohne Fehler durch.<\/p>\n\n\n\n

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

Ich hoffe das hilft euch weiter. <\/p>\n","protected":false},"excerpt":{"rendered":"

Ihr wollt Daten aus Dynamics 365 Finance and Supply Chain in Power Automate verwenden und dort nach sogenannten Werten in Enums filtern und kommt nicht weiter? Dann habe ich hier einen kleinen Tipp f\u00fcr euch. Um an die richtige Bezeichnung f\u00fcr das Enum zu gelangen, nutze ich eine “List Items present in Table” Action: In…<\/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":[169],"tags":[153,188,173],"class_list":["post-915","post","type-post","status-publish","format-standard","hentry","category-blog-de","tag-dynamics-365-de","tag-filter","tag-power-automate"],"taxonomy_info":{"category":[{"value":169,"label":"Blog"}],"post_tag":[{"value":153,"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":169,"name":"Blog","slug":"blog-de","term_group":0,"term_taxonomy_id":169,"taxonomy":"category","description":"","parent":0,"count":19,"filter":"raw","cat_ID":169,"category_count":19,"category_description":"","cat_name":"Blog","category_nicename":"blog-de","category_parent":0}],"tag_info":[{"term_id":153,"name":"Dynamics 365","slug":"dynamics-365-de","term_group":0,"term_taxonomy_id":153,"taxonomy":"post_tag","description":"","parent":0,"count":13,"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\/915","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=915"}],"version-history":[{"count":1,"href":"https:\/\/dynamiacs.com\/index.php?rest_route=\/wp\/v2\/posts\/915\/revisions"}],"predecessor-version":[{"id":923,"href":"https:\/\/dynamiacs.com\/index.php?rest_route=\/wp\/v2\/posts\/915\/revisions\/923"}],"wp:attachment":[{"href":"https:\/\/dynamiacs.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=915"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dynamiacs.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=915"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dynamiacs.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=915"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}