{"id":11953,"date":"2019-12-16T13:49:00","date_gmt":"2019-12-16T13:49:00","guid":{"rendered":"https:\/\/viewmyprojects.com\/winwirewp\/?p=11953"},"modified":"2024-06-05T09:56:01","modified_gmt":"2024-06-05T09:56:01","slug":"customize-sharepoint-using-powerapps","status":"publish","type":"post","link":"https:\/\/viewmyprojects.com\/winwirewp\/blog\/customize-sharepoint-using-powerapps\/","title":{"rendered":"Customize SharePoint List Forms Using PowerApps"},"content":{"rendered":"\n<p>PowerApps is part of Microsoft\u2019s Power Platform technologies offerings, which include Power Automate and Power BI (desktop and web). It comes with a lot of user-friendly features, which helps even a non-developer build powerful forms for different layout with various data sources.<\/p>\n\n\n\n<p>It\u2019s built to customize SharePoint list forms (linked directly from the list) so that the site user who has access to the file can edit the list forms according to their requirements. If you customize the form for a list and want to replicate it into another list\/site, PowerApps doesn\u2019t provide such a feature. Also, this is a business problem when you move to a different tenant or within the same tenant!<\/p>\n\n\n\n<p>To modernize SharePoint experience, developers need to create an app to uplift SharePoint experience for their users. Specifically, the new SharePoint list menu, you will now have an option to create a PowerApp for this list.<\/p>\n\n\n\n<p>The integration between PowerApps and SharePoint is seamless, you are not required to manage forms in two places, but they are some challenges the user is required to follow to customize apps.<\/p>\n\n\n\n<p><strong>Challenges Faced to Customize Apps<\/strong><\/p>\n\n\n\n<p>The standard-issue developers face how to migrate from one site to another \/ one tenant to another.<\/p>\n\n\n\n<p>While PowerApps gives you the option to export app the package, but one needs to follow some steps to make it work in a new site\/tenant. The following guide gives a brief idea of how to solve the problem of using custom forms across sites\/tenants for any user.<\/p>\n\n\n\n<p>Here are some steps you can follow to move a SharePoint Custom list PowerApps form one tenant to another.<\/p>\n\n\n\n<p><strong>Step-by-Step Guide to Personalize SharePoint List Forms using PowerApps<\/strong><\/p>\n\n\n\n<p>Steps to create customized SharePoint list forms as an app in PowerApps and importing as a package in another tenant.<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Go to your SharePoint site, create a list (if not yet created it), customize forms through the PowerApps (ex: change font color or background color)<\/li>\n<\/ol>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" src=\"https:\/\/viewmyprojects.com\/winwirewp\/wp-content\/uploads\/2023\/11\/Picture1-300x244-1.webp\" alt=\"\" class=\"wp-image-11954\"\/><\/figure>\n\n\n\n<p>2. Save and Publish the app<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" src=\"https:\/\/viewmyprojects.com\/winwirewp\/wp-content\/uploads\/2023\/11\/Picture2-300x118-1.webp\" alt=\"\" class=\"wp-image-11955\"\/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" src=\"https:\/\/viewmyprojects.com\/winwirewp\/wp-content\/uploads\/2023\/11\/Picture3-300x71-1.webp\" alt=\"\" class=\"wp-image-11956\"\/><\/figure>\n\n\n\n<p>3. Then, export this as a package.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" src=\"https:\/\/viewmyprojects.com\/winwirewp\/wp-content\/uploads\/2023\/11\/Picture4-300x43-1.webp\" alt=\"\" class=\"wp-image-11957\"\/><\/figure>\n\n\n\n<p>4. Provide the name for the package with the description<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" src=\"https:\/\/viewmyprojects.com\/winwirewp\/wp-content\/uploads\/2023\/11\/Picture5-300x233-1.webpg\" alt=\"\" class=\"wp-image-11958\"\/><\/figure>\n\n\n\n<p>5. While exporting, please make sure that&nbsp;<strong>Import Setup<\/strong>&nbsp;should be as&nbsp;<strong>Create as New&nbsp;<\/strong>and save it.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" src=\"https:\/\/viewmyprojects.com\/winwirewp\/wp-content\/uploads\/2023\/11\/Picture6-300x79-1.webp\" alt=\"\" class=\"wp-image-11959\"\/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"300\" height=\"161\" src=\"https:\/\/viewmyprojects.com\/winwirewp\/wp-content\/uploads\/2022\/05\/Picture7-300x161-1.png\" alt=\"\" class=\"wp-image-11960\"\/><\/figure>\n\n\n\n<p>6. Now, click on the Export button. This will start downloading a zip file.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" src=\"https:\/\/viewmyprojects.com\/winwirewp\/wp-content\/uploads\/2023\/11\/Picture8-300x72-1.webp\" alt=\"\" class=\"wp-image-11961\"\/><\/figure>\n\n\n\n<p>7. The exported zip package contains Microsoft.PowerApps folder and manifest JSON file. You have to navigate to&nbsp;<em>PowerApps\\apps\\ [numeric values]&nbsp;<\/em>(refer to below screenshots). Inside this folder hierarchy, navigate to&nbsp;<em>Microsoft.PowerApps\\apps\\ [numeric values].&nbsp;<\/em>There will be only one JSON file, which needs to be edited.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" src=\"https:\/\/viewmyprojects.com\/winwirewp\/wp-content\/uploads\/2023\/11\/Picture16-1-1.webp\" alt=\"\" class=\"wp-image-11964\"\/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" src=\"https:\/\/viewmyprojects.com\/winwirewp\/wp-content\/uploads\/2023\/11\/Picture9-300x197-1.webp\" alt=\"\" class=\"wp-image-11965\"\/><\/figure>\n\n\n\n<p>Note: Before you perform the below steps, please navigate to the site where you want to copy\/move this app (irrespective of the tenant). If you haven\u2019t created the list, please create a similar list as you already created in the source site.<\/p>\n\n\n\n<p>Once the list is ready, please get the List ID by navigating to Site Contents. In the Site Contents,<\/p>\n\n\n\n<p>Select the list and click on the dots against the list name, go to Settings.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" src=\"https:\/\/viewmyprojects.com\/winwirewp\/wp-content\/uploads\/2023\/11\/Picture17-3.webp\" alt=\"\" class=\"wp-image-11966\"\/><\/figure>\n\n\n\n<p>In the browser URL, note down your list ID<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" src=\"https:\/\/viewmyprojects.com\/winwirewp\/wp-content\/uploads\/2023\/11\/Picture11-300x29-1.webp\" alt=\"\" class=\"wp-image-11962\"\/><\/figure>\n\n\n\n<p>8. Open the JSON file in JSON editor app, now replace following sections<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>In the embedded App, replace&nbsp;<strong>SiteID<\/strong>&nbsp;with target site URL,&nbsp;<strong>ListID<\/strong>&nbsp;with target&nbsp;<strong>listId<\/strong>&nbsp;and listUrl with target listUrl (here target refers to list where you want to copy the app)<\/li>\n\n\n\n<li>In dataSources, change its target list name (internal name)<\/li>\n\n\n\n<li>The table name should be target listId (GUID)<\/li>\n\n\n\n<li>In the dataSets, change it to target site URL<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" src=\"https:\/\/viewmyprojects.com\/winwirewp\/wp-content\/uploads\/2023\/11\/Picture12-2-1.webp\" alt=\"\" class=\"wp-image-11967\"\/><\/figure>\n\n\n\n<p>9. Save JSON in the same folder. Now zip the folder again, make sure the folder hierarchy should remain the same<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" src=\"https:\/\/viewmyprojects.com\/winwirewp\/wp-content\/uploads\/2023\/11\/Picture13-300x122-1-1.webp\" alt=\"\" class=\"wp-image-11968\"\/><\/figure>\n\n\n\n<p>10. Go to the PowerApps (where you want to import this app), from the Apps tab navigate to Import as Package page.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" src=\"https:\/\/viewmyprojects.com\/winwirewp\/wp-content\/uploads\/2023\/11\/Picture14-3.webp\" alt=\"\" class=\"wp-image-11963\"\/><\/figure>\n\n\n\n<p>11. Select and upload the newly zipped folder to Import the package. Once the file is uploaded, start import by clicking on the Import button.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" src=\"https:\/\/viewmyprojects.com\/winwirewp\/wp-content\/uploads\/2023\/11\/Picture15-1-1.webp\" alt=\"\" class=\"wp-image-11969\"\/><\/figure>\n\n\n\n<p>12. On successful import of the app, you will have the option to Open the app<\/p>\n\n\n\n<p>13. Open the app, here the data source connection will be still old site list, so to add new SharePoint connection and change data sources to the latest connection. Delete Old SharePoint Connection. Add your list as the new data source. You may need to replace the data source connection in several places of the app<\/p>\n\n\n\n<p>14. Save and Publish the app. Test the app by adding\/editing items<\/p>\n\n\n\n<p>15. If the changes don\u2019t reflect, go to the list and click on the Customize Forms from the PowerApps menu. Make the required changes, save and Publish the app.<\/p>\n\n\n\n<p>If you are looking to create a SharePoint form using PowerApps then this step-by-step guide on can help you expedite the process.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>PowerApps is part of Microsoft\u2019s Power Platform technologies offerings, which include Power Automate and Power BI (desktop and web). It comes with a lot of user-friendly features, which helps even a non-developer build powerful forms for different layout with various data sources. It\u2019s built to customize SharePoint list forms (linked directly from the list) so&hellip; <a class=\"more-link\" href=\"https:\/\/viewmyprojects.com\/winwirewp\/blog\/customize-sharepoint-using-powerapps\/\">Continue reading <span class=\"screen-reader-text\">Customize SharePoint List Forms Using PowerApps<\/span><\/a><\/p>\n","protected":false},"author":61,"featured_media":16497,"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],"tags":[],"class_list":["post-11953","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-uncategorized","entry"],"acf":[],"featured_image_src":"https:\/\/viewmyprojects.com\/winwirewp\/wp-content\/uploads\/2023\/10\/Customize-SharePoint-List.webp","author_info":{"display_name":"Vivek","author_link":"https:\/\/viewmyprojects.com\/winwirewp\/author\/vivek\/"},"views":4170,"uagb_featured_image_src":{"full":["https:\/\/viewmyprojects.com\/winwirewp\/wp-content\/uploads\/2023\/10\/Customize-SharePoint-List.webp",800,440,false],"thumbnail":["https:\/\/viewmyprojects.com\/winwirewp\/wp-content\/uploads\/2023\/10\/Customize-SharePoint-List-150x150.webp",150,150,true],"medium":["https:\/\/viewmyprojects.com\/winwirewp\/wp-content\/uploads\/2023\/10\/Customize-SharePoint-List-300x165.webp",300,165,true],"medium_large":["https:\/\/viewmyprojects.com\/winwirewp\/wp-content\/uploads\/2023\/10\/Customize-SharePoint-List-768x422.webp",750,412,true],"large":["https:\/\/viewmyprojects.com\/winwirewp\/wp-content\/uploads\/2023\/10\/Customize-SharePoint-List.webp",750,413,false],"1536x1536":["https:\/\/viewmyprojects.com\/winwirewp\/wp-content\/uploads\/2023\/10\/Customize-SharePoint-List.webp",800,440,false],"2048x2048":["https:\/\/viewmyprojects.com\/winwirewp\/wp-content\/uploads\/2023\/10\/Customize-SharePoint-List.webp",800,440,false],"post-thumbnail":["https:\/\/viewmyprojects.com\/winwirewp\/wp-content\/uploads\/2023\/10\/Customize-SharePoint-List.webp",800,440,false]},"uagb_author_info":{"display_name":"Vivek","author_link":"https:\/\/viewmyprojects.com\/winwirewp\/author\/vivek\/"},"uagb_comment_info":0,"uagb_excerpt":"PowerApps is part of Microsoft\u2019s Power Platform technologies offerings, which include Power Automate and Power BI (desktop and web). It comes with a lot of user-friendly features, which helps even a non-developer build powerful forms for different layout with various data sources. It\u2019s built to customize SharePoint list forms (linked directly from the list) so&hellip;&hellip;","_links":{"self":[{"href":"https:\/\/viewmyprojects.com\/winwirewp\/wp-json\/wp\/v2\/posts\/11953","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\/61"}],"replies":[{"embeddable":true,"href":"https:\/\/viewmyprojects.com\/winwirewp\/wp-json\/wp\/v2\/comments?post=11953"}],"version-history":[{"count":2,"href":"https:\/\/viewmyprojects.com\/winwirewp\/wp-json\/wp\/v2\/posts\/11953\/revisions"}],"predecessor-version":[{"id":18361,"href":"https:\/\/viewmyprojects.com\/winwirewp\/wp-json\/wp\/v2\/posts\/11953\/revisions\/18361"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/viewmyprojects.com\/winwirewp\/wp-json\/wp\/v2\/media\/16497"}],"wp:attachment":[{"href":"https:\/\/viewmyprojects.com\/winwirewp\/wp-json\/wp\/v2\/media?parent=11953"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/viewmyprojects.com\/winwirewp\/wp-json\/wp\/v2\/categories?post=11953"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/viewmyprojects.com\/winwirewp\/wp-json\/wp\/v2\/tags?post=11953"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}