{"id":20871,"date":"2019-10-23T12:32:24","date_gmt":"2019-10-23T12:32:24","guid":{"rendered":"https:\/\/www.inogic.com\/blog\/?p=20871"},"modified":"2019-10-23T12:32:24","modified_gmt":"2019-10-23T12:32:24","slug":"cascading-two-dropdowns-in-powerapps-based-on-dynamics-365-crm-optionset-field","status":"publish","type":"post","link":"https:\/\/www.inogic.com\/blog\/2019\/10\/cascading-two-dropdowns-in-powerapps-based-on-dynamics-365-crm-optionset-field\/","title":{"rendered":"Cascading Two dropdowns in PowerApps based on Dynamics 365 CRM optionset field"},"content":{"rendered":"

Introduction<\/strong><\/h2>\n

In today\u2019s blog we will explore how to do cascading of two dropdowns in PowerApps based on Dynamics 365 CRM optionset field.<\/p>\n

To achieve this, first we need to create two optionset fields in Dynamics 365 CRM e.g. Mobile Company (Parent optionset) and Mobile Handset (Child optionset) in the Dynamics 365 CRM Account Entity.<\/p>\n

Now, as given below, create the collection in PowerApps on load of the Account edit form code.<\/p>\n

ClearCollect(productinfo,\r\n{Company:\"Nokia\",Product:\"Nokia 6.1\"},\r\n{Company:\"Nokia\",Product:\"Nokia 7.1\"},\r\n{Company:\"Nokia\",Product:\"Nokia 8.1\"},\r\n{Company:\"Apple\",Product:\"Iphone 7\"},\r\n{Company:\"Apple\",Product:\"Iphone X\"},{Company:\"Apple\",Product:\"Iphone XS\"});\r\n<\/pre>\n
Now on \u2018Edit form\u2019 I have shown both dropdowns. On company dropdown properties click on the dropdown, go to Advanced-> Data ->Items. Enter the code given below:<\/p>\n
Filter(productinfo,Product=DataCardValue11.Selected.Value)<\/em><\/p>\n
And set Company coming from the collection which we have created in the Value as shown in the below screenshot:<\/p>\n
\"Cascading<\/p>\n
Now in the mobile PowerApps you will see that on selecting the Product \u2018Nokia 6.1\u2019 Company is set as \u2018Nokia\u2019 and on selecting Product \u2018iPhone XS\u2019 Company is set as \u2018Apple\u2019 as shown in the below screenshot:<\/p>\n
\"Cascading<\/p>\n
\"Cascading<\/p>\n
Conclusion<\/h2>\n
Thus, as illustrated above, you can easily cascade two dropdowns in PowerApps based on Dynamics 365 CRM optionset field.<\/p>\n
\"\"<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"
Introduction In today\u2019s blog we will explore how to do cascading of two dropdowns in PowerApps based on Dynamics 365 CRM optionset field. To achieve this, first we need to create two optionset fields in Dynamics 365 CRM e.g. Mobile Company (Parent optionset) and Mobile Handset (Child optionset) in the Dynamics 365 CRM Account Entity.\u2026 Read More »<\/a><\/span><\/p>\n","protected":false},"author":13,"featured_media":20876,"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":[44],"tags":[1966,1882],"class_list":["post-20871","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-power-apps","tag-dynamics-365-crm-optionset-field","tag-powerapps"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/posts\/20871","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=20871"}],"version-history":[{"count":0,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/posts\/20871\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/media\/20876"}],"wp:attachment":[{"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/media?parent=20871"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/categories?post=20871"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/tags?post=20871"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}