{"id":24241,"date":"2020-07-28T07:38:53","date_gmt":"2020-07-28T07:38:53","guid":{"rendered":"https:\/\/www.inogic.com\/blog\/?p=24241"},"modified":"2020-07-28T07:38:53","modified_gmt":"2020-07-28T07:38:53","slug":"identify-the-trigger-message-when-using-common-data-service-current-connector-in-power-automate-flows","status":"publish","type":"post","link":"https:\/\/www.inogic.com\/blog\/2020\/07\/identify-the-trigger-message-when-using-common-data-service-current-connector-in-power-automate-flows\/","title":{"rendered":"Identify the trigger message when using Common Data Service (Current) Connector in Power Automate Flows"},"content":{"rendered":"

The earlier versions of the D365 Connector or the Common Data Service connector provided separate triggers for each of the CRUD actions like Create, Update and Delete. The latest version of the connector Common Data Service (Current) which is the one we should be using moving forward in most cases provides a single trigger as can be seen in the screenshot below<\/p>\n

\"Power<\/p>\n

Once you choose this trigger, you are then allowed to choose from the various combinations of trigger conditions supported<\/p>\n

\"Power<\/p>\n

This was a good improvement over the previous versions of the connectors because quite often we have similar logic to be executed upon Create or Update and now with the ability to combine these two trigger conditions, we can have a single flow designed to cover both the scenarios.<\/p>\n

In one of the projects we came across a scenario where in addition to the common logic to be executed for both Create and Update operation, there was one piece of logic specific to Update action.<\/p>\n

And there came the need to be able to identify the action that invoked the flow \u201cCreate\u201d or \u201cUpdate\u201d.<\/p>\n

While the dynamic values listing does not provide this information directly, looking at the output body from the test execution, we found that it does share this information<\/p>\n

\"Power<\/p>\n

To use this value, choose to add expression (click on fx button) to bring up the below screen<\/p>\n

\"Power<\/p>\n

Choose the first dynamic value listed as part of your operation output \u2013 Account Name in my case<\/p>\n

\"Power<\/p>\n

Now replace \u201cname\u201d in the above with \u201cSdkMessage\u201d and your expression should now look like<\/p>\n

\"\"<\/p>\n

Add the message names as the cases for Switch operation<\/p>\n

\"\"<\/p>\n

Note: If your flow designer experience does not list out dynamic values as shown in the screenshots above, make sure to enable the new Experimental features for Power Automate<\/p>\n

Navigate to Setting \"\" -> View all Power Automate Settings to bring up the following screen<\/p>\n

\"\"<\/p>\n

Conclusion<\/h2>\n

Have a look at the payload that is returned as part of the trigger output \u2013 you might find values being returned that have not been exposed as Dynamic Values but could still be used by defining appropriate expressions for them.<\/p>\n

 <\/p>\n","protected":false},"excerpt":{"rendered":"

The earlier versions of the D365 Connector or the Common Data Service connector provided separate triggers for each of the CRUD actions like Create, Update and Delete. The latest version of the connector Common Data Service (Current) which is the one we should be using moving forward in most cases provides a single trigger as\u2026 Read More »<\/a><\/span><\/p>\n","protected":false},"author":13,"featured_media":24253,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[9,18,1985],"tags":[],"class_list":["post-24241","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-common-data-service","category-dynamics-365-v9-2","category-power-automate"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/posts\/24241","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/users\/13"}],"replies":[{"embeddable":true,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/comments?post=24241"}],"version-history":[{"count":0,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/posts\/24241\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/media\/24253"}],"wp:attachment":[{"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/media?parent=24241"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/categories?post=24241"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/tags?post=24241"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}