{"id":36284,"date":"2023-10-25T17:33:45","date_gmt":"2023-10-25T12:03:45","guid":{"rendered":"https:\/\/www.inogic.com\/blog\/?p=36284"},"modified":"2023-10-25T17:33:45","modified_gmt":"2023-10-25T12:03:45","slug":"integrate-and-customize-sharepoint-forms-with-powerapps","status":"publish","type":"post","link":"https:\/\/www.inogic.com\/blog\/2023\/10\/integrate-and-customize-sharepoint-forms-with-powerapps\/","title":{"rendered":"Integrate and customize SharePoint forms with PowerApps"},"content":{"rendered":"<p>Recently, we were tasked with a client requirement to customize SharePoint forms, specifically the SharePoint file properties form within a document library. The client needed us to add and modify fields by changing control types. To meet this requirement, we successfully leveraged PowerApps. In this blog post, we will detail the steps we took to achieve this customization.<\/p>\n<p>Microsoft has already introduced the capability to personalize SharePoint forms by leveraging Power Apps. This enhancement enables users to modify and enhance the SharePoint document library and list forms by employing Power Apps.<\/p>\n<p>With this functionality, individuals can effortlessly adjust control types, implement conditional formatting, and apply validation rules to SharePoint forms without the need for manual coding.<\/p>\n<p>In this blog, we will see how to integrate SharePoint forms with PowerApps and with the data sources. Adding the different fields related to the SharePoint data source. We will see how we can change the control types and how to hide SharePoint forms using the <strong>RequestHide()<\/strong> function from SharePoint.<\/p>\n<p>To integrate the SharePoint forms into PowerApps, select any tab that you want to customize, click on the <strong>Integrate<\/strong> button, and select <strong>PowerApps<\/strong> &gt;&gt; <strong>Customize Forms.<\/strong><\/p>\n<p><img decoding=\"async\" class=\"alignnone size-full wp-image-36291\" style=\"border: 1px solid #0a0a0a; padding: 1px; margin: 1px;\" src=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2023\/10\/1SharePoint-forms-with-PowerApps.jpeg\" alt=\"SharePoint forms with PowerApps\" width=\"1900\" height=\"661\" srcset=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2023\/10\/1SharePoint-forms-with-PowerApps.jpeg 1900w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2023\/10\/1SharePoint-forms-with-PowerApps-300x104.jpeg 300w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2023\/10\/1SharePoint-forms-with-PowerApps-1024x356.jpeg 1024w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2023\/10\/1SharePoint-forms-with-PowerApps-768x267.jpeg 768w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2023\/10\/1SharePoint-forms-with-PowerApps-1536x534.jpeg 1536w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2023\/10\/1SharePoint-forms-with-PowerApps-660x230.jpeg 660w\" sizes=\"(max-width: 1900px) 100vw, 1900px\" \/><\/p>\n<p>After integration while customizing the SharePoint forms, these forms are by default connected to a <strong>SharePoint <\/strong>data source.<\/p>\n<p><a href=\"https:\/\/www.inogic.com\/product\/productivity-apps\/dynamics-365-crm-sharepoint-security-metadata-sync\/\" target=\"_blank\" rel=\"noopener\"><img decoding=\"async\" class=\"alignnone  wp-image-36297\" src=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2023\/10\/Ultimate-Microsoft-Dynamics-365-CRM-integration-with-SharePoint-to-Manage-AttachmentsDocumentsSecurity-Privileges-et-al.png\" alt=\"Microsoft Dynamics 365 CRM integration with SharePoint\" width=\"884\" height=\"221\" srcset=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2023\/10\/Ultimate-Microsoft-Dynamics-365-CRM-integration-with-SharePoint-to-Manage-AttachmentsDocumentsSecurity-Privileges-et-al.png 800w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2023\/10\/Ultimate-Microsoft-Dynamics-365-CRM-integration-with-SharePoint-to-Manage-AttachmentsDocumentsSecurity-Privileges-et-al-300x75.png 300w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2023\/10\/Ultimate-Microsoft-Dynamics-365-CRM-integration-with-SharePoint-to-Manage-AttachmentsDocumentsSecurity-Privileges-et-al-768x192.png 768w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2023\/10\/Ultimate-Microsoft-Dynamics-365-CRM-integration-with-SharePoint-to-Manage-AttachmentsDocumentsSecurity-Privileges-et-al-660x165.png 660w\" sizes=\"(max-width: 884px) 100vw, 884px\" \/><\/a><\/p>\n<p>The data source will be your SharePoint List or the document library of the form you have integrated with PowerApps.<\/p>\n<p><img decoding=\"async\" class=\"alignnone size-full wp-image-36290\" style=\"border: 1px solid #0a0a0a; padding: 1px; margin: 1px;\" src=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2023\/10\/2SharePoint-forms-with-PowerApps.jpeg\" alt=\"SharePoint forms with PowerApps\" width=\"1911\" height=\"959\" srcset=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2023\/10\/2SharePoint-forms-with-PowerApps.jpeg 1911w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2023\/10\/2SharePoint-forms-with-PowerApps-300x151.jpeg 300w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2023\/10\/2SharePoint-forms-with-PowerApps-1024x514.jpeg 1024w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2023\/10\/2SharePoint-forms-with-PowerApps-768x385.jpeg 768w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2023\/10\/2SharePoint-forms-with-PowerApps-1536x771.jpeg 1536w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2023\/10\/2SharePoint-forms-with-PowerApps-660x331.jpeg 660w\" sizes=\"(max-width: 1911px) 100vw, 1911px\" \/><\/p>\n<h3><strong>Adding different fields based on the data source and changing their control type as per the requirement.<\/strong><\/h3>\n<p>After integration, using PowerApps, we can add different fields on the SharePoint forms related to the data sources, i.e., SharePoint list or SharePoint document libraries.<\/p>\n<p>To add fields, select the SharePoint form in PowerApps, then click on the <strong>Edit fields.<\/strong> From there, you can select fields and add multiple fields that are related to the SharePoint data source.<\/p>\n<p><img decoding=\"async\" class=\"alignnone size-full wp-image-36289\" style=\"border: 1px solid #0a0a0a; padding: 1px; margin: 1px;\" src=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2023\/10\/3SharePoint-forms-with-PowerApps.jpeg\" alt=\"SharePoint forms with PowerApps\" width=\"1900\" height=\"949\" srcset=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2023\/10\/3SharePoint-forms-with-PowerApps.jpeg 1900w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2023\/10\/3SharePoint-forms-with-PowerApps-300x150.jpeg 300w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2023\/10\/3SharePoint-forms-with-PowerApps-1024x511.jpeg 1024w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2023\/10\/3SharePoint-forms-with-PowerApps-768x384.jpeg 768w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2023\/10\/3SharePoint-forms-with-PowerApps-1536x767.jpeg 1536w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2023\/10\/3SharePoint-forms-with-PowerApps-660x330.jpeg 660w\" sizes=\"(max-width: 1900px) 100vw, 1900px\" \/><\/p>\n<p>Not only can we add multiple fields, but we can also change their control type as per our requirements. For example, I have one description field, and we can change the control type of the field to different types.<\/p>\n<p><img decoding=\"async\" class=\"alignnone size-full wp-image-36288\" style=\"border: 1px solid #0a0a0a; padding: 1px; margin: 1px;\" src=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2023\/10\/4SharePoint-forms-with-PowerApps.jpeg\" alt=\"SharePoint forms with PowerApps\" width=\"1920\" height=\"913\" srcset=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2023\/10\/4SharePoint-forms-with-PowerApps.jpeg 1920w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2023\/10\/4SharePoint-forms-with-PowerApps-300x143.jpeg 300w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2023\/10\/4SharePoint-forms-with-PowerApps-1024x487.jpeg 1024w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2023\/10\/4SharePoint-forms-with-PowerApps-768x365.jpeg 768w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2023\/10\/4SharePoint-forms-with-PowerApps-1536x730.jpeg 1536w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2023\/10\/4SharePoint-forms-with-PowerApps-660x314.jpeg 660w\" sizes=\"(max-width: 1920px) 100vw, 1920px\" \/><\/p>\n<p>I have selected the control type as <strong>Edit rich text<\/strong> so I can edit this field, i.e., description, using rich text format.<\/p>\n<p><img decoding=\"async\" class=\"alignnone size-full wp-image-36287\" style=\"border: 1px solid #0a0a0a; padding: 1px; margin: 1px;\" src=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2023\/10\/5SharePoint-forms-with-PowerApps.jpeg\" alt=\"SharePoint forms with PowerApps\" width=\"1895\" height=\"875\" srcset=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2023\/10\/5SharePoint-forms-with-PowerApps.jpeg 1895w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2023\/10\/5SharePoint-forms-with-PowerApps-300x139.jpeg 300w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2023\/10\/5SharePoint-forms-with-PowerApps-1024x473.jpeg 1024w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2023\/10\/5SharePoint-forms-with-PowerApps-768x355.jpeg 768w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2023\/10\/5SharePoint-forms-with-PowerApps-1536x709.jpeg 1536w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2023\/10\/5SharePoint-forms-with-PowerApps-660x305.jpeg 660w\" sizes=\"(max-width: 1895px) 100vw, 1895px\" \/><\/p>\n<p>There are multiple control types, like text, where the value is shown in a simple text format, or <strong>view phone or email<\/strong> if the description has any phone number or email address. By using these control types, we can open the text as a phone number or particular email address.<\/p>\n<h3><strong>Hide forms using the RequestHide() function.<\/strong><\/h3>\n<p>In a recent release, Microsoft introduced the <strong>RequestHide()<\/strong> function, which is used to hide SharePoint forms from SharePoint. As we can see in the below screenshot, this function is already used in an OnSuccess control, so it will keep hiding the form when any record item is created or saved successfully. After we select the record and click on the properties, the form will open again.<\/p>\n<p><img decoding=\"async\" class=\"alignnone size-full wp-image-36286\" style=\"border: 1px solid #0a0a0a; padding: 1px; margin: 1px;\" src=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2023\/10\/6SharePoint-forms-with-PowerApps.jpeg\" alt=\"SharePoint forms with PowerApps\" width=\"1900\" height=\"456\" srcset=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2023\/10\/6SharePoint-forms-with-PowerApps.jpeg 1900w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2023\/10\/6SharePoint-forms-with-PowerApps-300x72.jpeg 300w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2023\/10\/6SharePoint-forms-with-PowerApps-1024x246.jpeg 1024w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2023\/10\/6SharePoint-forms-with-PowerApps-768x184.jpeg 768w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2023\/10\/6SharePoint-forms-with-PowerApps-1536x369.jpeg 1536w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2023\/10\/6SharePoint-forms-with-PowerApps-660x158.jpeg 660w\" sizes=\"(max-width: 1900px) 100vw, 1900px\" \/><\/p>\n<p>Also, we can manually use this function to close the SharePoint form. In the below example, we have added a button that will close the SharePoint form.<\/p>\n<p><img decoding=\"async\" class=\"alignnone size-full wp-image-36285\" style=\"border: 1px solid #0a0a0a; padding: 1px; margin: 1px;\" src=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2023\/10\/7SharePoint-forms-with-PowerApps.jpeg\" alt=\"SharePoint forms with PowerApps\" width=\"733\" height=\"833\" srcset=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2023\/10\/7SharePoint-forms-with-PowerApps.jpeg 733w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2023\/10\/7SharePoint-forms-with-PowerApps-264x300.jpeg 264w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2023\/10\/7SharePoint-forms-with-PowerApps-660x750.jpeg 660w\" sizes=\"(max-width: 733px) 100vw, 733px\" \/><\/p>\n<p>The RequestHide() function is used for manually hiding the SharePoint forms with conditional scenarios. Currently, this function only works on SharePoint forms. So we can use it only with SharePoint.<\/p>\n<h2><strong>Conclusion<\/strong><\/h2>\n<p>In summary, our blog covered the integration of SharePoint forms with PowerApps, which allowed us to add and tailor fields using various control types. Additionally, we explored the functionality of the <strong>RequestHide()<\/strong> function for concealing SharePoint forms.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Recently, we were tasked with a client requirement to customize SharePoint forms, specifically the SharePoint file properties form within a document library. The client needed us to add and modify fields by changing control types. To meet this requirement, we successfully leveraged PowerApps. In this blog post, we will detail the steps we took to\u2026 <span class=\"read-more\"><a href=\"https:\/\/www.inogic.com\/blog\/2023\/10\/integrate-and-customize-sharepoint-forms-with-powerapps\/\">Read More &raquo;<\/a><\/span><\/p>\n","protected":false},"author":11,"featured_media":0,"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,53],"tags":[2789],"class_list":["post-36284","post","type-post","status-publish","format-standard","hentry","category-power-apps","category-sharepoint","tag-sharepoint-forms-with-powerapps"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/posts\/36284","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\/11"}],"replies":[{"embeddable":true,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/comments?post=36284"}],"version-history":[{"count":0,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/posts\/36284\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/media?parent=36284"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/categories?post=36284"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/tags?post=36284"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}