{"id":6371,"date":"2021-02-04T11:12:27","date_gmt":"2021-02-04T11:12:27","guid":{"rendered":"https:\/\/www.softreetechnology.com\/?p=6371"},"modified":"2021-02-04T11:12:27","modified_gmt":"2021-02-04T11:12:27","slug":"cascading-dropdowns-using-powerapps","status":"publish","type":"post","link":"https:\/\/softreetechnology.com\/blog\/powerapps\/cascading-dropdowns-using-powerapps\/","title":{"rendered":"Cascading Dropdowns using PowerApps"},"content":{"rendered":"\n<p>In this blog, we will see how to apply cascade dropdown to a list field using Power Apps.<\/p>\n\n\n\n<p><strong>Step1. <\/strong>&nbsp;We need to create two SharePoint generic lists named \u201cCountry\u201d and \u201cCity\u201d. The SharePoint generic list \u201cCountry\u201d holds a column of type \u201csingle text line\u201d showing country names and the SharePoint generic list \u201cCity\u201d contains two columns. The first column name is \u201ccountry,\u201d&nbsp; which is of \u201clook up\u201d field type which inherited from parent list \u201cCountry\u201d and second field is \u201cCity\u201d which is a single text line field having country names.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/www.softreetechnology.com\/wp-content\/uploads\/2021\/02\/A.png\" alt=\"\" class=\"wp-image-6372\"\/><\/figure>\n\n\n\n<p>                                                                           Img1. First custom list \u201cCountry\u201d<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/www.softreetechnology.com\/wp-content\/uploads\/2021\/02\/B.png\" alt=\"\" class=\"wp-image-6373\"\/><\/figure>\n\n\n\n<p>                                                                                 Img2. Second custom list \u201cCity\u201d<\/p>\n\n\n\n<p><strong>Step2.<\/strong> Now we will create the list on which we will apply power apps cascading. I have created a SharePoint generic list with the name \u201cEmployee Details\u201d. I have created three columns in it. <em>\u201dEmp_id\u201d<\/em> column is a type of \u201csingle line of text\u201d<em>, \u201cCountry\u201d<\/em> column is \u201clook up\u201d field type, it inherits values from \u201cCountry\u201d list \u201cTitle\u201d field, <em>\u201cCity\u201d<\/em> column is \u201clook up\u201d field type that inherits value from \u201cCity\u201d list \u201cCity\u201d field.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/www.softreetechnology.com\/wp-content\/uploads\/2021\/02\/C.png\" alt=\"\" class=\"wp-image-6374\"\/><\/figure>\n\n\n\n<p>                                                               Img3. Custom list \u201dEmployee Details\u201d<\/p>\n\n\n\n<p><strong>Step3. <\/strong>Go to\u201dEmployee Details\u201d list to the &nbsp;modern view. Now when inserting the new items we can see after inserting country values in \u201cCountry\u201d field when we change \u201cCity\u201d field index, it shows all cities\u2019 names. We will apply Cascading on \u201cCity\u201d field. Cascading is nothing but apply filter conditions to show city names based on data selected on \u201cCountry\u201d field.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/www.softreetechnology.com\/wp-content\/uploads\/2021\/02\/D.png\" alt=\"\" class=\"wp-image-6375\"\/><\/figure>\n\n\n\n<p>                                           Img4. Before cascading apply all city names shows for selected country<\/p>\n\n\n\n<p><strong>Step4. <\/strong>Now we will start Power Apps implementations. Go to list setting, Click on \u201cForm Settings\u201d. Now click on \u201cCustomize in Power Apps\u201d url. It will open power app\u2019s window. You can remove any fields just clicking on it and pressing the delete button.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/www.softreetechnology.com\/wp-content\/uploads\/2021\/02\/E.png\" alt=\"\" class=\"wp-image-6376\"\/><\/figure>\n\n\n\n<p>                                                                           Img5. Power Apps window<\/p>\n\n\n\n<p><strong>Step5.<\/strong> Now we will need to add our list to a database. In our example, we are adding cascaded to \u201cCity\u201d column. In our list \u201cCity\u201d we had provided the all countries and its cities. Now we need to add our SharePoint generic list \u201cCity\u201d to the database. Follow below image to add the list to a database.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/www.softreetechnology.com\/wp-content\/uploads\/2021\/02\/F.png\" alt=\"\" class=\"wp-image-6377\"\/><\/figure>\n\n\n\n<p>                                                                Img5. Steps to add list to database<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/www.softreetechnology.com\/wp-content\/uploads\/2021\/02\/G.png\" alt=\"\" class=\"wp-image-6378\"\/><\/figure>\n\n\n\n<p>                                                           Img6. Click on site url links where list present<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/www.softreetechnology.com\/wp-content\/uploads\/2021\/02\/H.png\" alt=\"\" class=\"wp-image-6380\"\/><\/figure>\n\n\n\n<p>                                                                     Img7. Click on list which you want to add<\/p>\n\n\n\n<p><strong>Step6. <\/strong>Once list added to the database, we, need to apply filter formula. Just click on a field and unlock it.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/www.softreetechnology.com\/wp-content\/uploads\/2021\/02\/I.png\" alt=\"\" class=\"wp-image-6381\"\/><\/figure>\n\n\n\n<p>                                                                           Img7. Unlock field to apply formula on formula bar<\/p>\n\n\n\n<p>Step7. Now we will add formula on \u201cCity\u201d field to apply cascading.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/www.softreetechnology.com\/wp-content\/uploads\/2021\/02\/J.png\" alt=\"\" class=\"wp-image-6383\"\/><\/figure>\n\n\n\n<p>                                                                             Img8. Add formula on formula bar<\/p>\n\n\n\n<p>Step8. Click on F5 button or arrow mark on the toolbar tab to check the changes.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/www.softreetechnology.com\/wp-content\/uploads\/2021\/02\/K-1.png\" alt=\"\" class=\"wp-image-6384\"\/><\/figure>\n\n\n\n<p>                                  Img9. Now changing Country field value to USA shows cities name of USA<\/p>\n\n\n\n<p>Step9. Now we need to save our changes and publish it so that it can be worked on the list. To publish, click on the File tab, then goes to Save, add a version note then publish to SharePoint.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/www.softreetechnology.com\/wp-content\/uploads\/2021\/02\/L.png\" alt=\"\" class=\"wp-image-6385\"\/><\/figure>\n\n\n\n<p>                                                                             Img10. Add a version note<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/www.softreetechnology.com\/wp-content\/uploads\/2021\/02\/M.png\" alt=\"\" class=\"wp-image-6386\"\/><\/figure>\n\n\n\n<p>                                                                               Img11. Publish to SharePoint<\/p>\n\n\n\n<p><strong>Step10.<\/strong> Go to SharePoint list to see the results. Add new item. You can see changes are applied to SharePoint list also.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/www.softreetechnology.com\/wp-content\/uploads\/2021\/02\/N.png\" alt=\"\" class=\"wp-image-6387\"\/><\/figure>\n\n\n\n<p>                                                            Img12. Changes are applied to SharePoint list<\/p>\n\n\n\n<p><strong><span style=\"text-decoration: underline;\">Keywords<\/span><\/strong><\/p>\n\n\n\n<ol class=\"wp-block-list\" type=\"1\"><li>Apply cascade dropdown to SharePoint list field using Power Apps<\/li><li>Cascading dropdown using Power Apps<\/li><li>How to create cascade dropdown using Power Apps<\/li><li>Implementation of cascade dropdown using Power Apps<\/li><li>Cascade dropdown using Power Apps platform SharePoint data<\/li><\/ol>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"blob:https:\/\/www.softreetechnology.com\/888f1fa4-017e-418d-ad09-a9ad8b5c6750\" alt=\"\"\/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"blob:https:\/\/www.softreetechnology.com\/a104cb42-f70c-4bf5-9cec-d51e349d3c20\" alt=\"\"\/><\/figure>\n\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>In this blog, we will see how to apply cascade dropdown to a list field using Power Apps. Step1. &nbsp;We need to create two SharePoint generic lists named \u201cCountry\u201d and \u201cCity\u201d. The SharePoint generic list \u201cCountry\u201d holds a column of type \u201csingle text line\u201d showing country names and the SharePoint generic list \u201cCity\u201d contains two columns. The first column name [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":6413,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[306],"tags":[],"class_list":["post-6371","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-powerapps"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v24.6 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Cascading Dropdowns using PowerApps - Softree Technology<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/softreetechnology.com\/blog\/powerapps\/cascading-dropdowns-using-powerapps\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cascading Dropdowns using PowerApps - Softree Technology\" \/>\n<meta property=\"og:description\" content=\"In this blog, we will see how to apply cascade dropdown to a list field using Power Apps. Step1. &nbsp;We need to create two SharePoint generic lists named \u201cCountry\u201d and \u201cCity\u201d. The SharePoint generic list \u201cCountry\u201d holds a column of type \u201csingle text line\u201d showing country names and the SharePoint generic list \u201cCity\u201d contains two columns. The first column name [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/softreetechnology.com\/blog\/powerapps\/cascading-dropdowns-using-powerapps\/\" \/>\n<meta property=\"og:site_name\" content=\"Softree Technology\" \/>\n<meta property=\"article:published_time\" content=\"2021-02-04T11:12:27+00:00\" \/>\n<meta name=\"author\" content=\"admin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"admin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"6 minutes\" \/>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Cascading Dropdowns using PowerApps - Softree Technology","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/softreetechnology.com\/blog\/powerapps\/cascading-dropdowns-using-powerapps\/","og_locale":"en_US","og_type":"article","og_title":"Cascading Dropdowns using PowerApps - Softree Technology","og_description":"In this blog, we will see how to apply cascade dropdown to a list field using Power Apps. Step1. &nbsp;We need to create two SharePoint generic lists named \u201cCountry\u201d and \u201cCity\u201d. The SharePoint generic list \u201cCountry\u201d holds a column of type \u201csingle text line\u201d showing country names and the SharePoint generic list \u201cCity\u201d contains two columns. The first column name [&hellip;]","og_url":"https:\/\/softreetechnology.com\/blog\/powerapps\/cascading-dropdowns-using-powerapps\/","og_site_name":"Softree Technology","article_published_time":"2021-02-04T11:12:27+00:00","author":"admin","twitter_card":"summary_large_image","twitter_misc":{"Written by":"admin","Est. reading time":"6 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/softreetechnology.com\/blog\/powerapps\/cascading-dropdowns-using-powerapps\/#article","isPartOf":{"@id":"https:\/\/softreetechnology.com\/blog\/powerapps\/cascading-dropdowns-using-powerapps\/"},"author":{"name":"admin","@id":"https:\/\/softreetechnology.com\/blog\/#\/schema\/person\/98740297642f06debccdcee2de84086b"},"headline":"Cascading Dropdowns using PowerApps","datePublished":"2021-02-04T11:12:27+00:00","mainEntityOfPage":{"@id":"https:\/\/softreetechnology.com\/blog\/powerapps\/cascading-dropdowns-using-powerapps\/"},"wordCount":585,"commentCount":0,"publisher":{"@id":"https:\/\/softreetechnology.com\/blog\/#organization"},"image":{"@id":"https:\/\/softreetechnology.com\/blog\/powerapps\/cascading-dropdowns-using-powerapps\/#primaryimage"},"thumbnailUrl":"","articleSection":["PowerApps"],"inLanguage":"en","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/softreetechnology.com\/blog\/powerapps\/cascading-dropdowns-using-powerapps\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/softreetechnology.com\/blog\/powerapps\/cascading-dropdowns-using-powerapps\/","url":"https:\/\/softreetechnology.com\/blog\/powerapps\/cascading-dropdowns-using-powerapps\/","name":"Cascading Dropdowns using PowerApps - Softree Technology","isPartOf":{"@id":"https:\/\/softreetechnology.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/softreetechnology.com\/blog\/powerapps\/cascading-dropdowns-using-powerapps\/#primaryimage"},"image":{"@id":"https:\/\/softreetechnology.com\/blog\/powerapps\/cascading-dropdowns-using-powerapps\/#primaryimage"},"thumbnailUrl":"","datePublished":"2021-02-04T11:12:27+00:00","breadcrumb":{"@id":"https:\/\/softreetechnology.com\/blog\/powerapps\/cascading-dropdowns-using-powerapps\/#breadcrumb"},"inLanguage":"en","potentialAction":[{"@type":"ReadAction","target":["https:\/\/softreetechnology.com\/blog\/powerapps\/cascading-dropdowns-using-powerapps\/"]}]},{"@type":"ImageObject","inLanguage":"en","@id":"https:\/\/softreetechnology.com\/blog\/powerapps\/cascading-dropdowns-using-powerapps\/#primaryimage","url":"","contentUrl":""},{"@type":"BreadcrumbList","@id":"https:\/\/softreetechnology.com\/blog\/powerapps\/cascading-dropdowns-using-powerapps\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/softreetechnology.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Cascading Dropdowns using PowerApps"}]},{"@type":"WebSite","@id":"https:\/\/softreetechnology.com\/blog\/#website","url":"https:\/\/softreetechnology.com\/blog\/","name":"Softree Technology","description":"Celebrating 10+ Years in SharePoint Consulting !","publisher":{"@id":"https:\/\/softreetechnology.com\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/softreetechnology.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en"},{"@type":"Organization","@id":"https:\/\/softreetechnology.com\/blog\/#organization","name":"Softree Technology","url":"https:\/\/softreetechnology.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en","@id":"https:\/\/softreetechnology.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/softreetechnology.com\/blog\/wp-content\/uploads\/2023\/03\/cropped-white-logo-soft.png","contentUrl":"https:\/\/softreetechnology.com\/blog\/wp-content\/uploads\/2023\/03\/cropped-white-logo-soft.png","width":844,"height":230,"caption":"Softree Technology"},"image":{"@id":"https:\/\/softreetechnology.com\/blog\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/softreetechnology.com\/blog\/#\/schema\/person\/98740297642f06debccdcee2de84086b","name":"admin","image":{"@type":"ImageObject","inLanguage":"en","@id":"https:\/\/softreetechnology.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/6fc78c8a7aa3fb0bf43c3b9a2e3962d7?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/6fc78c8a7aa3fb0bf43c3b9a2e3962d7?s=96&d=mm&r=g","caption":"admin"},"sameAs":["https:\/\/softreeconsulting.com"],"url":"https:\/\/softreetechnology.com\/blog\/author\/admin\/"}]}},"_links":{"self":[{"href":"https:\/\/softreetechnology.com\/blog\/wp-json\/wp\/v2\/posts\/6371","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/softreetechnology.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/softreetechnology.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/softreetechnology.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/softreetechnology.com\/blog\/wp-json\/wp\/v2\/comments?post=6371"}],"version-history":[{"count":0,"href":"https:\/\/softreetechnology.com\/blog\/wp-json\/wp\/v2\/posts\/6371\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/softreetechnology.com\/blog\/wp-json\/"}],"wp:attachment":[{"href":"https:\/\/softreetechnology.com\/blog\/wp-json\/wp\/v2\/media?parent=6371"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/softreetechnology.com\/blog\/wp-json\/wp\/v2\/categories?post=6371"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/softreetechnology.com\/blog\/wp-json\/wp\/v2\/tags?post=6371"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}