{"id":12455,"date":"2018-07-23T17:58:57","date_gmt":"2018-07-23T12:28:57","guid":{"rendered":"https:\/\/www.inogic.com\/blog\/?p=12455"},"modified":"2022-07-21T12:18:45","modified_gmt":"2022-07-21T06:48:45","slug":"create-customer-lookup-in-powerapps-using-data-context","status":"publish","type":"post","link":"https:\/\/www.inogic.com\/blog\/2018\/07\/create-customer-lookup-in-powerapps-using-data-context\/","title":{"rendered":"Create Customer Lookup in PowerApps using Data Context"},"content":{"rendered":"

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

Recently, we had a business requirement to show customer lookup in PowerApps similar to the customer lookup in Dynamic 365.<\/p>\n

For example \u2013 In Dynamic 365, we have customer lookup of contact and account, using this we can select contact and account.<\/p>\n

To achieve the same thing in PowerApps, we have to use \u201cContext\u201d <\/strong>parameter of navigation methods.<\/p>\n

For more details about navigation, methods refer below link.<\/p>\n

https:\/\/docs.microsoft.com\/en-us\/powerapps\/maker\/canvas-apps\/functions\/function-navigate<\/a><\/p>\n

Solution:<\/strong><\/p>\n

Step 1: <\/strong>Select a Blank application as shown in below screenshot.<\/p>\n

\"PowerApps\"<\/p>\n

Step 2: <\/strong>Add two Blank Screen one is Home Screen and Customer Screen which will display account and contact list.<\/p>\n

\"PowerApps\"<\/p>\n

Step 3:\u00a0<\/strong>Add Dropdown Control, Textbox, search icon on Home Screen as below.<\/p>\n

\"PowerApps\"<\/p>\n

Step 4:\u00a0<\/strong>Add data source of account and contact in PowerApps as shown in the below screenshot.<\/p>\n

To add Source Go to View-> Data Source -> +Add data source<\/p>\n

\"PowerApps\"<\/p>\n

After that Click on Add data Source, the below screen will appear,<\/p>\n

\"PowerApps\"<\/p>\n

If u have different data source then select that one. Here we have selected a Dynamic 365.<\/p>\n

Click on Dynamic 365 then select required entity. I have selected Account. After selecting entity click on Connect, <\/strong>data source will get added to PowerApps. Similarly we can add Contacts data source as shown in below screenshot.<\/p>\n

\"PowerApps\"<\/p>\n

After successful setup it looks like below.<\/p>\n

\"PowerApps\"<\/p>\n

Step 5:\u00a0<\/strong>Add gallery two controls to \u201cCustomerScreen\u201d <\/strong>as shown in below screenshot.<\/strong><\/p>\n

\"PowerApps\"<\/p>\n

Step 6: <\/strong>Go to HomeScreen select dropdown, to set dropdown value, I have define entityList collection which consist of entityName as property. These will display data on dropdownlist.<\/p>\n

\"PowerApps\"<\/p>\n

Step 7: <\/strong>Now set Items property of dropdown to entityList Collection as shown below.<\/p>\n

\"PowerApps\"<\/p>\n

Step 8: <\/strong>Now add below lines of code in onSelect<\/strong> property of dropdown.<\/p>\n

\"PowerApps\"<\/p>\n

Step 9:\u00a0<\/strong>Select Search Icon of Textbox then add navigate function as shown below.<\/p>\n

\"PowerApps\"<\/p>\n

Step 10:\u00a0<\/strong>Go to CustomerScreen<\/strong> and set Items<\/strong> property Contact and Account Gallery to Source collection that define in navigate function.<\/p>\n

\"PowerApps\"<\/p>\n

Step 11:\u00a0<\/strong>To display only one gallery at a time set visible<\/strong> property of account and contact gallery as shown below<\/p>\n

Contact Gallery<\/strong><\/p>\n

\"PowerApps\"<\/p>\n

Account Gallery<\/strong><\/p>\n

\"PoweraApps\"<\/p>\n

Step 12:\u00a0<\/strong>To display selected data on HomeScreen<\/strong> Textbox, use Set function on OnSelect property of nextArrow Icon as shown in screenshot.<\/p>\n

Contact Gallery<\/strong><\/p>\n

\"PowerApps\"<\/p>\n

Account Gallery<\/strong><\/p>\n

\"PowerApps\"<\/p>\n

Step 13:\u00a0<\/strong>Go to HomeScreen<\/strong> and set default<\/strong> property of textbox as shown in below screenshot.<\/p>\n

\"PowerApps\"<\/p>\n

Note: Instead of Dropdown control, we can use radio Button. <\/strong>Now simply run the application.<\/p><\/blockquote>\n

Conclusion: <\/strong><\/h2>\n

Using the simple steps above user can create customer lookup in PowerApps using data context.<\/p>\n

70% of global 2000 companies apply gamification to improve productivity and returns!<\/div><\/div><\/h2>\n

Gamifics365<\/a> <\/strong>\u2013 Spin the magic of games within Microsoft Dynamics 365 CRM to improve user adoption, enhance productivity, and achieve company goals!<\/em><\/p>\n","protected":false},"excerpt":{"rendered":"

Introduction: Recently, we had a business requirement to show customer lookup in PowerApps similar to the customer lookup in Dynamic 365. For example \u2013 In Dynamic 365, we have customer lookup of contact and account, using this we can select contact and account. To achieve the same thing in PowerApps, we have to use \u201cContext\u201d\u2026 Read More »<\/a><\/span><\/p>\n","protected":false},"author":13,"featured_media":12457,"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":[16,18,19,44,38],"tags":[562,655,1171],"class_list":["post-12455","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-dynamics-365","category-dynamics-365-v9-2","category-dynamics-crm","category-power-apps","category-microsoft-powerapps","tag-dynamics-365-microsoft-powerapps","tag-dynamics-crm-microsoft-powerapps","tag-microsoft-powerapps-dynamics-crm"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/posts\/12455","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=12455"}],"version-history":[{"count":0,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/posts\/12455\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/media\/12457"}],"wp:attachment":[{"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/media?parent=12455"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/categories?post=12455"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/tags?post=12455"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}