{"id":12246,"date":"2017-03-22T11:57:00","date_gmt":"2017-03-22T11:57:00","guid":{"rendered":"https:\/\/viewmyprojects.com\/winwirewp\/?p=12246"},"modified":"2023-11-30T08:40:54","modified_gmt":"2023-11-30T08:40:54","slug":"powerapps-using-sharepoint-list","status":"publish","type":"post","link":"https:\/\/viewmyprojects.com\/winwirewp\/blog\/powerapps-using-sharepoint-list\/","title":{"rendered":"Creating PowerApps using SharePoint list"},"content":{"rendered":"\n<p>Many teams make use of SharePoint lists to access, share, and collaborate around structured data. To cater to this, Microsoft has provided a powerful capability to create apps using PowerApps that utilizes SharePoint lists as a data source.<\/p>\n\n\n\n<p>PowerApps is a service that fundamentally transforms and accelerates how organizations build the custom line of business application. With PowerApps, users can seamlessly create mobile apps that communicate the essential data to other employees and stakeholders.<\/p>\n\n\n\n<p>In PowerApps, you can manage the organizational data by running an app that you created or someone else has created and shared with you. The apps run on the mobile devices and you can also run them in a browser by accessing Dynamics 365. You can smoothly create an infinite variety of apps \u2013 all without learning a programming language.<\/p>\n\n\n\n<p>Apparently, with PowerApps, the organizations can build the cloud apps easily at the warp speed. Isn\u2019t it interesting?<\/p>\n\n\n\n<p>In this blog, you will learn a step-by-step approach on how to convert the SharePoint list to <a href=\"https:\/\/viewmyprojects.com\/winwirewp\/digital-engineering\/modern-workplace\/\">PowerApps<\/a>. When you\u2019re creating your PowerApps from the SharePoint, by default the PowerApp only render the data from the single list that where we are in. You can add different data sources to display and interact with data from somewhere else. It can be a SQL Database table, SharePoint list, a list of Salesforce opportunities or an RSS feed.<\/p>\n\n\n\n<p>Here, I have taken a very simple example, I have a SharePoint list of the Employees and it has sample data. This example will be just one screen of a PowerApp where you can search the employees by their names and also have an option for sorting and creating a new item.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"206\" height=\"354\" src=\"https:\/\/viewmyprojects.com\/winwirewp\/wp-content\/uploads\/2023\/11\/Nag-first.webp\" alt=\"\" class=\"wp-image-18704\" srcset=\"https:\/\/viewmyprojects.com\/winwirewp\/wp-content\/uploads\/2023\/11\/Nag-first.webp 206w, https:\/\/viewmyprojects.com\/winwirewp\/wp-content\/uploads\/2023\/11\/Nag-first-175x300.webp 175w\" sizes=\"auto, (max-width: 206px) 100vw, 206px\" \/><\/figure><\/div>\n\n\n<p><strong>Follow the steps to create the PowerApp<br><\/strong><br>1. Create a custom Employee list with respective columns<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"461\" height=\"126\" src=\"https:\/\/viewmyprojects.com\/winwirewp\/wp-content\/uploads\/2023\/11\/naga1-1.webp\" alt=\"\" class=\"wp-image-18705\" srcset=\"https:\/\/viewmyprojects.com\/winwirewp\/wp-content\/uploads\/2023\/11\/naga1-1.webp 461w, https:\/\/viewmyprojects.com\/winwirewp\/wp-content\/uploads\/2023\/11\/naga1-1-300x82.webp 300w\" sizes=\"auto, (max-width: 461px) 100vw, 461px\" \/><\/figure><\/div>\n\n\n<p>2. To create a PowerApp, you need to switch to amodern look. Follow the steps below to switch to anew version if you are still using an old version.<\/p>\n\n\n\n<p>a) Navigate to Employee List Settings page.<br>b) Click on \u201cAdvanced settings\u201d.<br>c) In the section of List experience, choose \u201cNew experience\u201d as shown in the image below.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"410\" height=\"136\" src=\"https:\/\/viewmyprojects.com\/winwirewp\/wp-content\/uploads\/2023\/11\/Nag2.webp\" alt=\"\" class=\"wp-image-18717\" srcset=\"https:\/\/viewmyprojects.com\/winwirewp\/wp-content\/uploads\/2023\/11\/Nag2.webp 410w, https:\/\/viewmyprojects.com\/winwirewp\/wp-content\/uploads\/2023\/11\/Nag2-300x100.webp 300w\" sizes=\"auto, (max-width: 410px) 100vw, 410px\" \/><\/figure><\/div>\n\n\n<p><br>d) Click Ok.<br>e) As we have a modern look in the list, we can see the new option in the Employee list.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"590\" height=\"137\" src=\"https:\/\/viewmyprojects.com\/winwirewp\/wp-content\/uploads\/2023\/11\/Nag3.webp\" alt=\"\" class=\"wp-image-18716\" srcset=\"https:\/\/viewmyprojects.com\/winwirewp\/wp-content\/uploads\/2023\/11\/Nag3.webp 590w, https:\/\/viewmyprojects.com\/winwirewp\/wp-content\/uploads\/2023\/11\/Nag3-300x70.webp 300w\" sizes=\"auto, (max-width: 590px) 100vw, 590px\" \/><\/figure><\/div>\n\n\n<p>3. Click on \u201cPowerApps\u201d and select \u201cCreate an app\u201d.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"523\" height=\"130\" src=\"https:\/\/viewmyprojects.com\/winwirewp\/wp-content\/uploads\/2023\/11\/nag4.webp\" alt=\"\" class=\"wp-image-18715\" srcset=\"https:\/\/viewmyprojects.com\/winwirewp\/wp-content\/uploads\/2023\/11\/nag4.webp 523w, https:\/\/viewmyprojects.com\/winwirewp\/wp-content\/uploads\/2023\/11\/nag4-300x75.webp 300w\" sizes=\"auto, (max-width: 523px) 100vw, 523px\" \/><\/figure><\/div>\n\n\n<p>4. Enter the app name and click on \u201cCreate\u201d.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"338\" height=\"298\" src=\"https:\/\/viewmyprojects.com\/winwirewp\/wp-content\/uploads\/2023\/11\/Nag5.webp\" alt=\"\" class=\"wp-image-18714\" srcset=\"https:\/\/viewmyprojects.com\/winwirewp\/wp-content\/uploads\/2023\/11\/Nag5.webp 338w, https:\/\/viewmyprojects.com\/winwirewp\/wp-content\/uploads\/2023\/11\/Nag5-300x264.webp 300w\" sizes=\"auto, (max-width: 338px) 100vw, 338px\" \/><\/figure><\/div>\n\n\n<p>5. Once the PowerApp wizard opens, you can see the \u201cEmployee list data\u201d in the design workspace with thedefault look and feel.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"507\" height=\"245\" src=\"https:\/\/viewmyprojects.com\/winwirewp\/wp-content\/uploads\/2023\/11\/Nag-6.webp\" alt=\"\" class=\"wp-image-18712\" srcset=\"https:\/\/viewmyprojects.com\/winwirewp\/wp-content\/uploads\/2023\/11\/Nag-6.webp 507w, https:\/\/viewmyprojects.com\/winwirewp\/wp-content\/uploads\/2023\/11\/Nag-6-300x145.webp 300w\" sizes=\"auto, (max-width: 507px) 100vw, 507px\" \/><\/figure><\/div>\n\n\n<p>6. In the right-side Screen thumbnails section, you have three default screens:<\/p>\n\n\n\n<p>I. Browse Screen<br>II. Details Screen<br>III. New \/ Edit Screen<\/p>\n\n\n\n<p>7. To preview the app, click on \u201cPlay button\u201d or press F5.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"479\" height=\"234\" src=\"https:\/\/viewmyprojects.com\/winwirewp\/wp-content\/uploads\/2023\/11\/Nag7.webp\" alt=\"\" class=\"wp-image-18711\" srcset=\"https:\/\/viewmyprojects.com\/winwirewp\/wp-content\/uploads\/2023\/11\/Nag7.webp 479w, https:\/\/viewmyprojects.com\/winwirewp\/wp-content\/uploads\/2023\/11\/Nag7-300x147.webp 300w\" sizes=\"auto, (max-width: 479px) 100vw, 479px\" \/><\/figure><\/div>\n\n\n<p>8. Click on the arrow of the item, you can see the screen of the item display form and an option to edit or delete the specific item.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"442\" height=\"261\" src=\"https:\/\/viewmyprojects.com\/winwirewp\/wp-content\/uploads\/2023\/11\/Nag-8.webp\" alt=\"\" class=\"wp-image-18710\" srcset=\"https:\/\/viewmyprojects.com\/winwirewp\/wp-content\/uploads\/2023\/11\/Nag-8.webp 442w, https:\/\/viewmyprojects.com\/winwirewp\/wp-content\/uploads\/2023\/11\/Nag-8-300x177.webp 300w\" sizes=\"auto, (max-width: 442px) 100vw, 442px\" \/><\/figure><\/div>\n\n\n<p>9. In PowerApps, you can write the formulas in the Formula bar to apply the filter on the SharePoint list data depending upon the business requirements and here, I have set the formula for the employee name.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"499\" height=\"245\" src=\"https:\/\/viewmyprojects.com\/winwirewp\/wp-content\/uploads\/2023\/11\/Nag-9.webp\" alt=\"\" class=\"wp-image-18709\" srcset=\"https:\/\/viewmyprojects.com\/winwirewp\/wp-content\/uploads\/2023\/11\/Nag-9.webp 499w, https:\/\/viewmyprojects.com\/winwirewp\/wp-content\/uploads\/2023\/11\/Nag-9-300x147.webp 300w\" sizes=\"auto, (max-width: 499px) 100vw, 499px\" \/><\/figure><\/div>\n\n\n<p>10. To add a new Data source, select \u201cContent\u201d and click on \u201cData sources\u201d then access the option \u201cAdd data source\u201d in the left side wizard.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"524\" height=\"188\" src=\"https:\/\/viewmyprojects.com\/winwirewp\/wp-content\/uploads\/2023\/11\/nag-10.webp\" alt=\"\" class=\"wp-image-18713\" srcset=\"https:\/\/viewmyprojects.com\/winwirewp\/wp-content\/uploads\/2023\/11\/nag-10.webp 524w, https:\/\/viewmyprojects.com\/winwirewp\/wp-content\/uploads\/2023\/11\/nag-10-300x108.webp 300w\" sizes=\"auto, (max-width: 524px) 100vw, 524px\" \/><\/figure><\/div>\n\n\n<p>11. Once you make all the changes, select File from the top right corner and click on Save or press Ctrl-S.<\/p>\n\n\n\n<p>12. To know more about the PowerApps you have three sections which will guide you further on how to manage the apps.<\/p>\n\n\n\n<p>A. In the \u201cDetails\u201d section, you can see Owner, Connections, Shared with, Flows and Web link.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"460\" height=\"188\" src=\"https:\/\/viewmyprojects.com\/winwirewp\/wp-content\/uploads\/2023\/11\/nag11.webp\" alt=\"\" class=\"wp-image-18708\" srcset=\"https:\/\/viewmyprojects.com\/winwirewp\/wp-content\/uploads\/2023\/11\/nag11.webp 460w, https:\/\/viewmyprojects.com\/winwirewp\/wp-content\/uploads\/2023\/11\/nag11-300x123.webp 300w\" sizes=\"auto, (max-width: 460px) 100vw, 460px\" \/><\/figure><\/div>\n\n\n<p><br>B. In the Share section, you can share the app with others.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"437\" height=\"200\" src=\"https:\/\/viewmyprojects.com\/winwirewp\/wp-content\/uploads\/2023\/11\/nag-12.webp\" alt=\"\" class=\"wp-image-18707\" srcset=\"https:\/\/viewmyprojects.com\/winwirewp\/wp-content\/uploads\/2023\/11\/nag-12.webp 437w, https:\/\/viewmyprojects.com\/winwirewp\/wp-content\/uploads\/2023\/11\/nag-12-300x137.webp 300w\" sizes=\"auto, (max-width: 437px) 100vw, 437px\" \/><\/figure><\/div>\n\n\n<p><br>C. In the Versions section, you can see all the app version while at any point of time you can consider reverting to the older version.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"459\" height=\"150\" src=\"https:\/\/viewmyprojects.com\/winwirewp\/wp-content\/uploads\/2023\/11\/nag-13.webp\" alt=\"\" class=\"wp-image-18706\" srcset=\"https:\/\/viewmyprojects.com\/winwirewp\/wp-content\/uploads\/2023\/11\/nag-13.webp 459w, https:\/\/viewmyprojects.com\/winwirewp\/wp-content\/uploads\/2023\/11\/nag-13-300x98.webp 300w\" sizes=\"auto, (max-width: 459px) 100vw, 459px\" \/><\/figure><\/div>\n\n\n<p>To view PowerApps on the mobile, follow the link, which will help you with the configuration&nbsp;https:\/\/powerapps.microsoft.com\/en-us\/tutorials\/run-app-client\/<\/p>\n\n\n\n<p><strong>Making it easier with PowerApps<\/strong><\/p>\n\n\n\n<p><em>PowerApps is natively a mobile application, which means the deployment can be deployed via mobile as well as the web. With all of the provided templates, creating a simple data entry application is no longer a herculean task as it was before, the PowerApps is designed to help you move smoothly with minimal effort. If you are looking for a new web application, I highly recommend that you must consider PowerApps as you may be astonished to see how little effort is involved here.<\/em><\/p>\n\n\n\n<p>To learn more about PowerApps, visit&nbsp;<a href=\"https:\/\/powerapps.microsoft.com\/en-us\/tutorials\/app-from-sharepoint\/\" target=\"_blank\" rel=\"noreferrer noopener\">https:\/\/powerapps.microsoft.com\/en-us\/tutorials\/app-from-sharepoint\/<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Many teams make use of SharePoint lists to access, share, and collaborate around structured data. To cater to this, Microsoft has provided a powerful capability to create apps using PowerApps that utilizes SharePoint lists as a data source. PowerApps is a service that fundamentally transforms and accelerates how organizations build the custom line of business&hellip; <a class=\"more-link\" href=\"https:\/\/viewmyprojects.com\/winwirewp\/blog\/powerapps-using-sharepoint-list\/\">Continue reading <span class=\"screen-reader-text\">Creating PowerApps using SharePoint list<\/span><\/a><\/p>\n","protected":false},"author":79,"featured_media":16674,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_eb_attr":"","_uag_custom_page_level_css":"","footnotes":""},"categories":[1,67,59],"tags":[],"class_list":["post-12246","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-uncategorized","category-digital-collaboration-blogs","category-blogs","entry"],"acf":[],"featured_image_src":"https:\/\/viewmyprojects.com\/winwirewp\/wp-content\/uploads\/2023\/11\/PowerApps-using-SharePoint-list.webp","author_info":{"display_name":"Nagaraju","author_link":"https:\/\/viewmyprojects.com\/winwirewp\/author\/nagaraju\/"},"views":3788,"uagb_featured_image_src":{"full":["https:\/\/viewmyprojects.com\/winwirewp\/wp-content\/uploads\/2023\/11\/PowerApps-using-SharePoint-list.webp",800,440,false],"thumbnail":["https:\/\/viewmyprojects.com\/winwirewp\/wp-content\/uploads\/2023\/11\/PowerApps-using-SharePoint-list-150x150.webp",150,150,true],"medium":["https:\/\/viewmyprojects.com\/winwirewp\/wp-content\/uploads\/2023\/11\/PowerApps-using-SharePoint-list-300x165.webp",300,165,true],"medium_large":["https:\/\/viewmyprojects.com\/winwirewp\/wp-content\/uploads\/2023\/11\/PowerApps-using-SharePoint-list-768x422.webp",750,412,true],"large":["https:\/\/viewmyprojects.com\/winwirewp\/wp-content\/uploads\/2023\/11\/PowerApps-using-SharePoint-list.webp",750,413,false],"1536x1536":["https:\/\/viewmyprojects.com\/winwirewp\/wp-content\/uploads\/2023\/11\/PowerApps-using-SharePoint-list.webp",800,440,false],"2048x2048":["https:\/\/viewmyprojects.com\/winwirewp\/wp-content\/uploads\/2023\/11\/PowerApps-using-SharePoint-list.webp",800,440,false],"post-thumbnail":["https:\/\/viewmyprojects.com\/winwirewp\/wp-content\/uploads\/2023\/11\/PowerApps-using-SharePoint-list.webp",800,440,false]},"uagb_author_info":{"display_name":"Nagaraju","author_link":"https:\/\/viewmyprojects.com\/winwirewp\/author\/nagaraju\/"},"uagb_comment_info":0,"uagb_excerpt":"Many teams make use of SharePoint lists to access, share, and collaborate around structured data. To cater to this, Microsoft has provided a powerful capability to create apps using PowerApps that utilizes SharePoint lists as a data source. PowerApps is a service that fundamentally transforms and accelerates how organizations build the custom line of business&hellip;&hellip;","_links":{"self":[{"href":"https:\/\/viewmyprojects.com\/winwirewp\/wp-json\/wp\/v2\/posts\/12246","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/viewmyprojects.com\/winwirewp\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/viewmyprojects.com\/winwirewp\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/viewmyprojects.com\/winwirewp\/wp-json\/wp\/v2\/users\/79"}],"replies":[{"embeddable":true,"href":"https:\/\/viewmyprojects.com\/winwirewp\/wp-json\/wp\/v2\/comments?post=12246"}],"version-history":[{"count":2,"href":"https:\/\/viewmyprojects.com\/winwirewp\/wp-json\/wp\/v2\/posts\/12246\/revisions"}],"predecessor-version":[{"id":18759,"href":"https:\/\/viewmyprojects.com\/winwirewp\/wp-json\/wp\/v2\/posts\/12246\/revisions\/18759"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/viewmyprojects.com\/winwirewp\/wp-json\/wp\/v2\/media\/16674"}],"wp:attachment":[{"href":"https:\/\/viewmyprojects.com\/winwirewp\/wp-json\/wp\/v2\/media?parent=12246"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/viewmyprojects.com\/winwirewp\/wp-json\/wp\/v2\/categories?post=12246"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/viewmyprojects.com\/winwirewp\/wp-json\/wp\/v2\/tags?post=12246"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}