{"id":2857,"date":"2023-01-29T17:45:57","date_gmt":"2023-01-30T01:45:57","guid":{"rendered":"https:\/\/doubleecpu.com\/?page_id=2857"},"modified":"2023-01-29T17:45:57","modified_gmt":"2023-01-30T01:45:57","slug":"connect-list-to-powerapp-gallery","status":"publish","type":"page","link":"https:\/\/doubleecpu.com\/index.php\/connect-list-to-powerapp-gallery\/","title":{"rendered":"Connect List To PowerApp Gallery"},"content":{"rendered":"\n<p>In the App Edit mode, click on the database icon and the + Add data to select the SharePoint connector<\/p>\n\n\n\n<figure class=\"wp-block-image size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/doubleecpu.com\/wp-content\/uploads\/2023\/01\/image-15.png\" alt=\"\" class=\"wp-image-2848\" width=\"282\" height=\"276\"\/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/doubleecpu.com\/wp-content\/uploads\/2023\/01\/image-16.png\" alt=\"\" class=\"wp-image-2849\" width=\"283\" height=\"594\"\/><\/figure>\n\n\n\n<p>after selecting Sharepoint a list of Sharepoint sites will show up, Select the site that has the List and select the List. List from multiple sites can be selected but users can only connect to list they have access to, data will not appear if no access is granted by list owner.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/doubleecpu.com\/wp-content\/uploads\/2023\/01\/image-17.png\" alt=\"\" class=\"wp-image-2850\" width=\"287\" height=\"252\"\/><\/figure>\n\n\n\n<p>The List will appear on the data selection<\/p>\n\n\n\n<figure class=\"wp-block-image size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/doubleecpu.com\/wp-content\/uploads\/2023\/01\/image-19.png\" alt=\"\" class=\"wp-image-2852\" width=\"298\" height=\"176\"\/><\/figure>\n\n\n\n<p>From Here the List data can be called into a collection, displayed in a gallery, updated using forms, and whatever other actions are needed. In this example we will display the data in a gallery and update fields using Patch( ) function. <br>Select a blank flexible height gallery set the position X = 1 and Y = 101<\/p>\n\n\n\n<p>The data source selected can be selected when the gallery is inserted or the Items property for the gallery can be set at a later time.  In this example the List data will be set to a collection variable that is filtered and sorted.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/doubleecpu.com\/wp-content\/uploads\/2023\/01\/image-21.png\" alt=\"\" class=\"wp-image-2854\" width=\"653\" height=\"334\"\/><\/figure>\n\n\n\n<p>on the Screen Properties OnVisible( ) copy and paste the following Code:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>ClearCollect(Rocket_Collection, List_Rocket_Data)<\/code><\/pre>\n\n\n\n<p>Set The Gallery Items property to Rocket_Collection <\/p>\n\n\n\n<figure class=\"wp-block-image size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/doubleecpu.com\/wp-content\/uploads\/2023\/01\/image-22.png\" alt=\"\" class=\"wp-image-2855\" width=\"284\" height=\"221\"\/><\/figure>\n\n\n\n<p>Select the Gallery then insert a Text Label and TextInput Control<\/p>\n\n\n\n<figure class=\"wp-block-image size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/doubleecpu.com\/wp-content\/uploads\/2023\/01\/image-23.png\" alt=\"\" class=\"wp-image-2856\" width=\"256\" height=\"272\"\/><\/figure>\n\n\n\n<p>Set the Position X to 0 and the Y to 0 for the Label and X = 0 and Y = 41 for the text input<\/p>\n","protected":false},"excerpt":{"rendered":"<p>In the App Edit mode, click on the database icon and the + Add data to select the SharePoint connector after selecting Sharepoint a list of Sharepoint sites will show up, Select the site that has the List and select the List. List from multiple sites can be selected but users can only connect to &hellip; <\/p>\n<p class=\"link-more\"><a href=\"https:\/\/doubleecpu.com\/index.php\/connect-list-to-powerapp-gallery\/\" class=\"more-link\">Read more<span class=\"screen-reader-text\"> &#8220;Connect List To PowerApp Gallery&#8221;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-2857","page","type-page","status-publish","hentry"],"featured_media_urls":[],"_links":{"self":[{"href":"https:\/\/doubleecpu.com\/index.php\/wp-json\/wp\/v2\/pages\/2857","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/doubleecpu.com\/index.php\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/doubleecpu.com\/index.php\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/doubleecpu.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/doubleecpu.com\/index.php\/wp-json\/wp\/v2\/comments?post=2857"}],"version-history":[{"count":1,"href":"https:\/\/doubleecpu.com\/index.php\/wp-json\/wp\/v2\/pages\/2857\/revisions"}],"predecessor-version":[{"id":2858,"href":"https:\/\/doubleecpu.com\/index.php\/wp-json\/wp\/v2\/pages\/2857\/revisions\/2858"}],"wp:attachment":[{"href":"https:\/\/doubleecpu.com\/index.php\/wp-json\/wp\/v2\/media?parent=2857"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}