{"id":7648,"date":"2024-02-04T23:16:25","date_gmt":"2024-02-04T23:16:25","guid":{"rendered":"https:\/\/haydentechnology.com\/htblog\/?p=7648"},"modified":"2024-06-26T21:24:21","modified_gmt":"2024-06-26T21:24:21","slug":"exceleration-power-apps-get-sharepoint-data-using-power-automate","status":"publish","type":"post","link":"https:\/\/haydentechnology.com\/htblog\/2024\/02\/exceleration-power-apps-get-sharepoint-data-using-power-automate\/","title":{"rendered":"Exceleration: Power Apps Get Sharepoint Data using Power Automate"},"content":{"rendered":"\n<p>I have recently thought about caching in Powerapps using collections.\u00a0 Cached data can help with performance.\u00a0 I&#8217;ve been investigating the use of SharePoint REST APIs in place of Connectors to SharePoint&#8230; <\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>avoid challenges with delegation<\/li>\n\n\n\n<li>leverage pagination<\/li>\n\n\n\n<li>cache SP JSON responses<\/li>\n<\/ul>\n\n\n\n<p>Caching implies that you want to use a recent version of data that in the cache and has not yet expired.\u00a0 <\/p>\n\n\n\n<p>3 phase logic follows:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>If the entry is valid (exists and has not expired), then just simply return the cached data from the cache\/collection.<\/li>\n\n\n\n<li>If the entry exists in the collection, but has expired (e.g. the data hasn&#8217;t been refreshed in x number of seconds, then get a fresh copy of the data and update (aka patch) the invalid entry.<\/li>\n\n\n\n<li>If there is no entry in the cache, then get a fresh copy of the data and save (aka patch) in the cache (collection)<\/li>\n<\/ul>\n\n\n\n<p>Power function &#8220;COALESCE&#8221; helps to facilitate this.\u00a0 Coalesce will essentially try an option and if that option is invalid, it will try the next option.<\/p>\n\n\n\n<p><strong>Create a Power Automate flow <\/strong>called &#8220;Generic Sharepoint API Call&#8221; that will make a generic GET call to SharePoint and returns the resulting JSON (even if the JSON results contain a list, this list can be stored as a single JSON object in cache along with a set a timestamp.\u00a0 What&#8217;s cool is that this flow does not require any premium connectors or special magic (well, perhaps a little magic).\u00a0\u00a0<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><a href=\"https:\/\/i0.wp.com\/haydentechnology.com\/htblog\/wp-content\/uploads\/2024\/06\/image-4.png?ssl=1\"><img data-recalc-dims=\"1\" fetchpriority=\"high\" decoding=\"async\" width=\"840\" height=\"444\" data-attachment-id=\"7685\" data-permalink=\"https:\/\/haydentechnology.com\/htblog\/2024\/02\/exceleration-power-apps-get-sharepoint-data-using-power-automate\/image-4-3\/\" data-orig-file=\"https:\/\/i0.wp.com\/haydentechnology.com\/htblog\/wp-content\/uploads\/2024\/06\/image-4.png?fit=3425%2C1808&amp;ssl=1\" data-orig-size=\"3425,1808\" data-comments-opened=\"1\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"image-4\" data-image-description=\"\" data-image-caption=\"\" data-medium-file=\"https:\/\/i0.wp.com\/haydentechnology.com\/htblog\/wp-content\/uploads\/2024\/06\/image-4.png?fit=300%2C158&amp;ssl=1\" data-large-file=\"https:\/\/i0.wp.com\/haydentechnology.com\/htblog\/wp-content\/uploads\/2024\/06\/image-4.png?fit=840%2C444&amp;ssl=1\" src=\"https:\/\/i0.wp.com\/haydentechnology.com\/htblog\/wp-content\/uploads\/2024\/06\/image-4.png?resize=840%2C444&#038;ssl=1\" alt=\"\" class=\"wp-image-7685\" srcset=\"https:\/\/i0.wp.com\/haydentechnology.com\/htblog\/wp-content\/uploads\/2024\/06\/image-4.png?resize=1024%2C541&amp;ssl=1 1024w, https:\/\/i0.wp.com\/haydentechnology.com\/htblog\/wp-content\/uploads\/2024\/06\/image-4.png?resize=300%2C158&amp;ssl=1 300w, https:\/\/i0.wp.com\/haydentechnology.com\/htblog\/wp-content\/uploads\/2024\/06\/image-4.png?resize=768%2C405&amp;ssl=1 768w, https:\/\/i0.wp.com\/haydentechnology.com\/htblog\/wp-content\/uploads\/2024\/06\/image-4.png?resize=1536%2C811&amp;ssl=1 1536w, https:\/\/i0.wp.com\/haydentechnology.com\/htblog\/wp-content\/uploads\/2024\/06\/image-4.png?resize=2048%2C1081&amp;ssl=1 2048w, https:\/\/i0.wp.com\/haydentechnology.com\/htblog\/wp-content\/uploads\/2024\/06\/image-4.png?resize=1200%2C633&amp;ssl=1 1200w, https:\/\/i0.wp.com\/haydentechnology.com\/htblog\/wp-content\/uploads\/2024\/06\/image-4.png?resize=600%2C317&amp;ssl=1 600w, https:\/\/i0.wp.com\/haydentechnology.com\/htblog\/wp-content\/uploads\/2024\/06\/image-4.png?w=1680&amp;ssl=1 1680w, https:\/\/i0.wp.com\/haydentechnology.com\/htblog\/wp-content\/uploads\/2024\/06\/image-4.png?w=2520&amp;ssl=1 2520w\" sizes=\"(max-width: 709px) 85vw, (max-width: 909px) 67vw, (max-width: 1362px) 62vw, 840px\" \/><\/a><\/figure>\n\n\n\n<p><\/p>\n\n\n\n<p><\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><a href=\"https:\/\/i0.wp.com\/haydentechnology.com\/htblog\/wp-content\/uploads\/2024\/06\/image-1.png?ssl=1\"><img data-recalc-dims=\"1\" decoding=\"async\" width=\"840\" height=\"333\" data-attachment-id=\"7682\" data-permalink=\"https:\/\/haydentechnology.com\/htblog\/2024\/02\/exceleration-power-apps-get-sharepoint-data-using-power-automate\/image-1-3\/\" data-orig-file=\"https:\/\/i0.wp.com\/haydentechnology.com\/htblog\/wp-content\/uploads\/2024\/06\/image-1.png?fit=1583%2C628&amp;ssl=1\" data-orig-size=\"1583,628\" data-comments-opened=\"1\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"image-1\" data-image-description=\"\" data-image-caption=\"\" data-medium-file=\"https:\/\/i0.wp.com\/haydentechnology.com\/htblog\/wp-content\/uploads\/2024\/06\/image-1.png?fit=300%2C119&amp;ssl=1\" data-large-file=\"https:\/\/i0.wp.com\/haydentechnology.com\/htblog\/wp-content\/uploads\/2024\/06\/image-1.png?fit=840%2C333&amp;ssl=1\" src=\"https:\/\/i0.wp.com\/haydentechnology.com\/htblog\/wp-content\/uploads\/2024\/06\/image-1.png?resize=840%2C333&#038;ssl=1\" alt=\"\" class=\"wp-image-7682\" srcset=\"https:\/\/i0.wp.com\/haydentechnology.com\/htblog\/wp-content\/uploads\/2024\/06\/image-1.png?resize=1024%2C406&amp;ssl=1 1024w, https:\/\/i0.wp.com\/haydentechnology.com\/htblog\/wp-content\/uploads\/2024\/06\/image-1.png?resize=300%2C119&amp;ssl=1 300w, https:\/\/i0.wp.com\/haydentechnology.com\/htblog\/wp-content\/uploads\/2024\/06\/image-1.png?resize=768%2C305&amp;ssl=1 768w, https:\/\/i0.wp.com\/haydentechnology.com\/htblog\/wp-content\/uploads\/2024\/06\/image-1.png?resize=1536%2C609&amp;ssl=1 1536w, https:\/\/i0.wp.com\/haydentechnology.com\/htblog\/wp-content\/uploads\/2024\/06\/image-1.png?resize=1200%2C476&amp;ssl=1 1200w, https:\/\/i0.wp.com\/haydentechnology.com\/htblog\/wp-content\/uploads\/2024\/06\/image-1.png?resize=600%2C238&amp;ssl=1 600w, https:\/\/i0.wp.com\/haydentechnology.com\/htblog\/wp-content\/uploads\/2024\/06\/image-1.png?w=1583&amp;ssl=1 1583w\" sizes=\"(max-width: 709px) 85vw, (max-width: 909px) 67vw, (max-width: 1362px) 62vw, 840px\" \/><\/a><\/figure>\n\n\n\n<p><\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><a href=\"https:\/\/i0.wp.com\/haydentechnology.com\/htblog\/wp-content\/uploads\/2024\/06\/image-6.png?ssl=1\"><img data-recalc-dims=\"1\" decoding=\"async\" width=\"840\" height=\"389\" data-attachment-id=\"7687\" data-permalink=\"https:\/\/haydentechnology.com\/htblog\/2024\/02\/exceleration-power-apps-get-sharepoint-data-using-power-automate\/image-6-3\/\" data-orig-file=\"https:\/\/i0.wp.com\/haydentechnology.com\/htblog\/wp-content\/uploads\/2024\/06\/image-6.png?fit=1515%2C702&amp;ssl=1\" data-orig-size=\"1515,702\" data-comments-opened=\"1\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"image-6\" data-image-description=\"\" data-image-caption=\"\" data-medium-file=\"https:\/\/i0.wp.com\/haydentechnology.com\/htblog\/wp-content\/uploads\/2024\/06\/image-6.png?fit=300%2C139&amp;ssl=1\" data-large-file=\"https:\/\/i0.wp.com\/haydentechnology.com\/htblog\/wp-content\/uploads\/2024\/06\/image-6.png?fit=840%2C389&amp;ssl=1\" src=\"https:\/\/i0.wp.com\/haydentechnology.com\/htblog\/wp-content\/uploads\/2024\/06\/image-6.png?resize=840%2C389&#038;ssl=1\" alt=\"\" class=\"wp-image-7687\" srcset=\"https:\/\/i0.wp.com\/haydentechnology.com\/htblog\/wp-content\/uploads\/2024\/06\/image-6.png?resize=1024%2C474&amp;ssl=1 1024w, https:\/\/i0.wp.com\/haydentechnology.com\/htblog\/wp-content\/uploads\/2024\/06\/image-6.png?resize=300%2C139&amp;ssl=1 300w, https:\/\/i0.wp.com\/haydentechnology.com\/htblog\/wp-content\/uploads\/2024\/06\/image-6.png?resize=768%2C356&amp;ssl=1 768w, https:\/\/i0.wp.com\/haydentechnology.com\/htblog\/wp-content\/uploads\/2024\/06\/image-6.png?resize=1200%2C556&amp;ssl=1 1200w, https:\/\/i0.wp.com\/haydentechnology.com\/htblog\/wp-content\/uploads\/2024\/06\/image-6.png?resize=600%2C278&amp;ssl=1 600w, https:\/\/i0.wp.com\/haydentechnology.com\/htblog\/wp-content\/uploads\/2024\/06\/image-6.png?w=1515&amp;ssl=1 1515w\" sizes=\"(max-width: 709px) 85vw, (max-width: 909px) 67vw, (max-width: 1362px) 62vw, 840px\" \/><\/a><\/figure>\n\n\n\n<p><\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><a href=\"https:\/\/i0.wp.com\/haydentechnology.com\/htblog\/wp-content\/uploads\/2024\/06\/image-5.png?ssl=1\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"840\" height=\"545\" data-attachment-id=\"7686\" data-permalink=\"https:\/\/haydentechnology.com\/htblog\/2024\/02\/exceleration-power-apps-get-sharepoint-data-using-power-automate\/image-5-3\/\" data-orig-file=\"https:\/\/i0.wp.com\/haydentechnology.com\/htblog\/wp-content\/uploads\/2024\/06\/image-5.png?fit=1553%2C1007&amp;ssl=1\" data-orig-size=\"1553,1007\" data-comments-opened=\"1\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"image-5\" data-image-description=\"\" data-image-caption=\"\" data-medium-file=\"https:\/\/i0.wp.com\/haydentechnology.com\/htblog\/wp-content\/uploads\/2024\/06\/image-5.png?fit=300%2C195&amp;ssl=1\" data-large-file=\"https:\/\/i0.wp.com\/haydentechnology.com\/htblog\/wp-content\/uploads\/2024\/06\/image-5.png?fit=840%2C545&amp;ssl=1\" src=\"https:\/\/i0.wp.com\/haydentechnology.com\/htblog\/wp-content\/uploads\/2024\/06\/image-5.png?resize=840%2C545&#038;ssl=1\" alt=\"\" class=\"wp-image-7686\" srcset=\"https:\/\/i0.wp.com\/haydentechnology.com\/htblog\/wp-content\/uploads\/2024\/06\/image-5.png?resize=1024%2C664&amp;ssl=1 1024w, https:\/\/i0.wp.com\/haydentechnology.com\/htblog\/wp-content\/uploads\/2024\/06\/image-5.png?resize=300%2C195&amp;ssl=1 300w, https:\/\/i0.wp.com\/haydentechnology.com\/htblog\/wp-content\/uploads\/2024\/06\/image-5.png?resize=768%2C498&amp;ssl=1 768w, https:\/\/i0.wp.com\/haydentechnology.com\/htblog\/wp-content\/uploads\/2024\/06\/image-5.png?resize=1536%2C996&amp;ssl=1 1536w, https:\/\/i0.wp.com\/haydentechnology.com\/htblog\/wp-content\/uploads\/2024\/06\/image-5.png?resize=1200%2C778&amp;ssl=1 1200w, https:\/\/i0.wp.com\/haydentechnology.com\/htblog\/wp-content\/uploads\/2024\/06\/image-5.png?resize=600%2C389&amp;ssl=1 600w, https:\/\/i0.wp.com\/haydentechnology.com\/htblog\/wp-content\/uploads\/2024\/06\/image-5.png?w=1553&amp;ssl=1 1553w\" sizes=\"(max-width: 709px) 85vw, (max-width: 909px) 67vw, (max-width: 1362px) 62vw, 840px\" \/><\/a><\/figure>\n\n\n\n<p><\/p>\n\n\n\n<p><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>In the first step, define two inputs: in_baseurl and in_restcall.<\/li>\n\n\n\n<li>In the second step, send in_baseurl to Site Address and in_restcall to URI.&nbsp; Also add Header &#8220;Accept&#8221; =&nbsp;&#8220;application\/json;odata=nometadata&#8221;.&nbsp; I also rename this step = &#8220;HTTP _Request&#8221;.<\/li>\n\n\n\n<li>In the third step, return &#8220;data&#8221; with expression &#8220;string(body(&#8216;HTTP_Request&#8217;))&#8221;<\/li>\n<\/ul>\n\n\n\n<p>Now, you can add this flow to Powerapps using the &#8220;Power Automate&#8221; configuration button.<\/p>\n\n\n\n<p>OK, about the cache (collection) in Powerapps.&nbsp; A collection called coll_httprequests with columns &#8220;httprequest&#8221;, &#8220;httpresponse&#8221;, and &#8220;timestamp&#8221; will be created by the component and available to your Powerapps.&nbsp; My cached item in this case will expire after 145 seconds.&nbsp;&nbsp;<\/p>\n\n\n\n<p>Create an invisible component, add a property named &#8220;get&#8221; of type &#8220;Action&#8221; that returns Text.&nbsp; Add 3 input parameters: in_baseurl (type text), in_request_uri (type text), and in_expiry (type number).&nbsp; Place the following in the result. <\/p>\n\n\n\n<p><code>If(LookUp(Sort(coll_httprequests,timestamp,SortOrder.Ascending),httprequest=in_request_uri).timestamp &gt; (Now() - in_expiry\/24\/60\/60), LookUp(Sort(coll_httprequests,timestamp,SortOrder.Ascending),httprequest=in_request_uri), Patch(coll_httprequests, Coalesce( LookUp(Sort(coll_httprequests,timestamp,SortOrder.Ascending),httprequest=in_request_uri), Defaults(coll_httprequests)), {httprequest:in_request_uri,httpresponse:'HT-GenericSPCall'.Run(in_baseurl,in_request_uri).data,timestamp:Now()} )).httpresponse<\/code><\/p>\n\n\n\n<p>Now, add this component to your Powerapps.\u00a0 And now you can call Component_1.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>get(\"https:\/\/_____.sharepoint.com\/sites\/____\", \"_api\/web\/lists\",30)<\/code><\/pre>\n\n\n\n<p>And then parse the results into a Table.\u00a0 This is a little tricky&#8230; you need to know the structure of the response.\u00a0 See\u00a0<a href=\"https:\/\/learn.microsoft.com\/en-us\/sharepoint\/dev\/sp-add-ins\/working-with-lists-and-list-items-with-rest\" target=\"_blank\" rel=\"noreferrer noopener\">https:\/\/learn.microsoft.com\/en-us\/sharepoint\/dev\/sp-add-ins\/working-with-lists-and-list-items-with-rest<\/a>. Set(var_getit7,<\/p>\n\n\n\n<p><code>SPConnect.get(var_baseurl,\"_api\/web\/lists\",60)); ClearCollect(coll_splists, DropColumns(AddColumns( Table(ParseJSON(var_getit7).value), \"Title\", Text(Value.Title), \"Id\", Text(Value.Id), \"Description\", Text(Value.Description), \"DecodeURL\", Text(Value.ParentWebPath.DecodedUrl), \"ImageURL\", Text(Value.ImageUrl) ),\"Value\"));<\/code><\/p>\n\n\n\n<p>I provided some &#8220;write up&#8221; on how to do the Power Flow HTTP call to SharePoint in a &#8220;non-premium&#8221; way.&nbsp;&nbsp;<a href=\"https:\/\/sharepoint.stackexchange.com\/questions\/282308\/how-to-send-json-data-to-power-apps-from-power-automate-ms-flow\" target=\"_blank\" rel=\"noreferrer noopener\">https:\/\/sharepoint.stackexchange.com\/questions\/282308\/how-to-send-json-data-to-power-apps-from-power-automate-ms-flow<\/a><\/p>\n\n\n\n<p>Cheers!<\/p>\n\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>I have explored enhancing Powerapps performance by using caching techniques with SharePoint REST APIs, avoiding the need for premium connectors. By leveraging three phases of logic\u2014validating, updating expired data, and handling new entries\u2014I optimized data retrieval. We implemented a &#8220;Power Automate&#8221; flow for fetching and caching SharePoint data. This facilitates smoother and cheaper operations within Powerapps, using conditions to manage data freshness and validity effectively.<\/p>\n","protected":false},"author":1,"featured_media":7600,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","enabled":false},"version":2}},"categories":[131],"tags":[139,141,140],"class_list":["post-7648","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel","tag-excel","tag-exceleration","tag-microsoft"],"jetpack_publicize_connections":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v24.4 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Exceleration: Power Apps Get Sharepoint Data using Power Automate - Innovative Consulting for banks and credit unions<\/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:\/\/haydentechnology.com\/htblog\/2024\/02\/exceleration-power-apps-get-sharepoint-data-using-power-automate\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Exceleration: Power Apps Get Sharepoint Data using Power Automate - Innovative Consulting for banks and credit unions\" \/>\n<meta property=\"og:description\" content=\"I have explored enhancing Powerapps performance by using caching techniques with SharePoint REST APIs, avoiding the need for premium connectors. By leveraging three phases of logic\u2014validating, updating expired data, and handling new entries\u2014I optimized data retrieval. We implemented a &quot;Power Automate&quot; flow for fetching and caching SharePoint data. This facilitates smoother and cheaper operations within Powerapps, using conditions to manage data freshness and validity effectively.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/haydentechnology.com\/htblog\/2024\/02\/exceleration-power-apps-get-sharepoint-data-using-power-automate\/\" \/>\n<meta property=\"og:site_name\" content=\"Innovative Consulting for banks and credit unions\" \/>\n<meta property=\"article:published_time\" content=\"2024-02-04T23:16:25+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-06-26T21:24:21+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/i0.wp.com\/haydentechnology.com\/htblog\/wp-content\/uploads\/2024\/01\/Excelerated-e1715376682978.png?fit=1652%2C707&ssl=1\" \/>\n\t<meta property=\"og:image:width\" content=\"1652\" \/>\n\t<meta property=\"og:image:height\" content=\"707\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Mark Woollen\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@mwoollen\" \/>\n<meta name=\"twitter:site\" content=\"@mwoollen\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Mark Woollen\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/haydentechnology.com\/htblog\/2024\/02\/exceleration-power-apps-get-sharepoint-data-using-power-automate\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/haydentechnology.com\/htblog\/2024\/02\/exceleration-power-apps-get-sharepoint-data-using-power-automate\/\"},\"author\":{\"name\":\"Mark Woollen\",\"@id\":\"https:\/\/haydentechnology.com\/htblog\/#\/schema\/person\/21588820fde62f721d7dda8f826fc698\"},\"headline\":\"Exceleration: Power Apps Get Sharepoint Data using Power Automate\",\"datePublished\":\"2024-02-04T23:16:25+00:00\",\"dateModified\":\"2024-06-26T21:24:21+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/haydentechnology.com\/htblog\/2024\/02\/exceleration-power-apps-get-sharepoint-data-using-power-automate\/\"},\"wordCount\":485,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/haydentechnology.com\/htblog\/#organization\"},\"image\":{\"@id\":\"https:\/\/haydentechnology.com\/htblog\/2024\/02\/exceleration-power-apps-get-sharepoint-data-using-power-automate\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/i0.wp.com\/haydentechnology.com\/htblog\/wp-content\/uploads\/2024\/01\/Excelerated-e1715376682978.png?fit=1652%2C707&ssl=1\",\"keywords\":[\"Excel\",\"Exceleration\",\"Microsoft\"],\"articleSection\":[\"Exceleration\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/haydentechnology.com\/htblog\/2024\/02\/exceleration-power-apps-get-sharepoint-data-using-power-automate\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/haydentechnology.com\/htblog\/2024\/02\/exceleration-power-apps-get-sharepoint-data-using-power-automate\/\",\"url\":\"https:\/\/haydentechnology.com\/htblog\/2024\/02\/exceleration-power-apps-get-sharepoint-data-using-power-automate\/\",\"name\":\"Exceleration: Power Apps Get Sharepoint Data using Power Automate - Innovative Consulting for banks and credit unions\",\"isPartOf\":{\"@id\":\"https:\/\/haydentechnology.com\/htblog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/haydentechnology.com\/htblog\/2024\/02\/exceleration-power-apps-get-sharepoint-data-using-power-automate\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/haydentechnology.com\/htblog\/2024\/02\/exceleration-power-apps-get-sharepoint-data-using-power-automate\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/i0.wp.com\/haydentechnology.com\/htblog\/wp-content\/uploads\/2024\/01\/Excelerated-e1715376682978.png?fit=1652%2C707&ssl=1\",\"datePublished\":\"2024-02-04T23:16:25+00:00\",\"dateModified\":\"2024-06-26T21:24:21+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/haydentechnology.com\/htblog\/2024\/02\/exceleration-power-apps-get-sharepoint-data-using-power-automate\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/haydentechnology.com\/htblog\/2024\/02\/exceleration-power-apps-get-sharepoint-data-using-power-automate\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/haydentechnology.com\/htblog\/2024\/02\/exceleration-power-apps-get-sharepoint-data-using-power-automate\/#primaryimage\",\"url\":\"https:\/\/i0.wp.com\/haydentechnology.com\/htblog\/wp-content\/uploads\/2024\/01\/Excelerated-e1715376682978.png?fit=1652%2C707&ssl=1\",\"contentUrl\":\"https:\/\/i0.wp.com\/haydentechnology.com\/htblog\/wp-content\/uploads\/2024\/01\/Excelerated-e1715376682978.png?fit=1652%2C707&ssl=1\",\"width\":1652,\"height\":707,\"caption\":\"Excelerate your productivity\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/haydentechnology.com\/htblog\/2024\/02\/exceleration-power-apps-get-sharepoint-data-using-power-automate\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/haydentechnology.com\/htblog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Exceleration: Power Apps Get Sharepoint Data using Power Automate\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/haydentechnology.com\/htblog\/#website\",\"url\":\"https:\/\/haydentechnology.com\/htblog\/\",\"name\":\"Innovative Consulting for banks and credit unions\",\"description\":\"Hayden Technology provides innovative thought leadership, complex program management and Agile technology delivery for banks and credit Unions\",\"publisher\":{\"@id\":\"https:\/\/haydentechnology.com\/htblog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/haydentechnology.com\/htblog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/haydentechnology.com\/htblog\/#organization\",\"name\":\"Innovative Consulting for banks and credit unions\",\"url\":\"https:\/\/haydentechnology.com\/htblog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/haydentechnology.com\/htblog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/i0.wp.com\/haydentechnology.com\/htblog\/wp-content\/uploads\/2022\/09\/HT-full-transparentBG.png?fit=3000%2C800&ssl=1\",\"contentUrl\":\"https:\/\/i0.wp.com\/haydentechnology.com\/htblog\/wp-content\/uploads\/2022\/09\/HT-full-transparentBG.png?fit=3000%2C800&ssl=1\",\"width\":3000,\"height\":800,\"caption\":\"Innovative Consulting for banks and credit unions\"},\"image\":{\"@id\":\"https:\/\/haydentechnology.com\/htblog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/x.com\/mwoollen\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/haydentechnology.com\/htblog\/#\/schema\/person\/21588820fde62f721d7dda8f826fc698\",\"name\":\"Mark Woollen\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/haydentechnology.com\/htblog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/5c4473086f76e17c354f3d960303d0f3?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/5c4473086f76e17c354f3d960303d0f3?s=96&d=mm&r=g\",\"caption\":\"Mark Woollen\"},\"description\":\"Industry leader helping banks and credit unions make decisions that matter and deliver important programs with Agility.\",\"sameAs\":[\"https:\/\/www.linkedin.com\/in\/markwoollen\/\",\"https:\/\/x.com\/mwoollen\"],\"url\":\"https:\/\/haydentechnology.com\/htblog\/author\/mwoollen\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Exceleration: Power Apps Get Sharepoint Data using Power Automate - Innovative Consulting for banks and credit unions","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:\/\/haydentechnology.com\/htblog\/2024\/02\/exceleration-power-apps-get-sharepoint-data-using-power-automate\/","og_locale":"en_US","og_type":"article","og_title":"Exceleration: Power Apps Get Sharepoint Data using Power Automate - Innovative Consulting for banks and credit unions","og_description":"I have explored enhancing Powerapps performance by using caching techniques with SharePoint REST APIs, avoiding the need for premium connectors. By leveraging three phases of logic\u2014validating, updating expired data, and handling new entries\u2014I optimized data retrieval. We implemented a \"Power Automate\" flow for fetching and caching SharePoint data. This facilitates smoother and cheaper operations within Powerapps, using conditions to manage data freshness and validity effectively.","og_url":"https:\/\/haydentechnology.com\/htblog\/2024\/02\/exceleration-power-apps-get-sharepoint-data-using-power-automate\/","og_site_name":"Innovative Consulting for banks and credit unions","article_published_time":"2024-02-04T23:16:25+00:00","article_modified_time":"2024-06-26T21:24:21+00:00","og_image":[{"width":1652,"height":707,"url":"https:\/\/i0.wp.com\/haydentechnology.com\/htblog\/wp-content\/uploads\/2024\/01\/Excelerated-e1715376682978.png?fit=1652%2C707&ssl=1","type":"image\/png"}],"author":"Mark Woollen","twitter_card":"summary_large_image","twitter_creator":"@mwoollen","twitter_site":"@mwoollen","twitter_misc":{"Written by":"Mark Woollen","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/haydentechnology.com\/htblog\/2024\/02\/exceleration-power-apps-get-sharepoint-data-using-power-automate\/#article","isPartOf":{"@id":"https:\/\/haydentechnology.com\/htblog\/2024\/02\/exceleration-power-apps-get-sharepoint-data-using-power-automate\/"},"author":{"name":"Mark Woollen","@id":"https:\/\/haydentechnology.com\/htblog\/#\/schema\/person\/21588820fde62f721d7dda8f826fc698"},"headline":"Exceleration: Power Apps Get Sharepoint Data using Power Automate","datePublished":"2024-02-04T23:16:25+00:00","dateModified":"2024-06-26T21:24:21+00:00","mainEntityOfPage":{"@id":"https:\/\/haydentechnology.com\/htblog\/2024\/02\/exceleration-power-apps-get-sharepoint-data-using-power-automate\/"},"wordCount":485,"commentCount":0,"publisher":{"@id":"https:\/\/haydentechnology.com\/htblog\/#organization"},"image":{"@id":"https:\/\/haydentechnology.com\/htblog\/2024\/02\/exceleration-power-apps-get-sharepoint-data-using-power-automate\/#primaryimage"},"thumbnailUrl":"https:\/\/i0.wp.com\/haydentechnology.com\/htblog\/wp-content\/uploads\/2024\/01\/Excelerated-e1715376682978.png?fit=1652%2C707&ssl=1","keywords":["Excel","Exceleration","Microsoft"],"articleSection":["Exceleration"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/haydentechnology.com\/htblog\/2024\/02\/exceleration-power-apps-get-sharepoint-data-using-power-automate\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/haydentechnology.com\/htblog\/2024\/02\/exceleration-power-apps-get-sharepoint-data-using-power-automate\/","url":"https:\/\/haydentechnology.com\/htblog\/2024\/02\/exceleration-power-apps-get-sharepoint-data-using-power-automate\/","name":"Exceleration: Power Apps Get Sharepoint Data using Power Automate - Innovative Consulting for banks and credit unions","isPartOf":{"@id":"https:\/\/haydentechnology.com\/htblog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/haydentechnology.com\/htblog\/2024\/02\/exceleration-power-apps-get-sharepoint-data-using-power-automate\/#primaryimage"},"image":{"@id":"https:\/\/haydentechnology.com\/htblog\/2024\/02\/exceleration-power-apps-get-sharepoint-data-using-power-automate\/#primaryimage"},"thumbnailUrl":"https:\/\/i0.wp.com\/haydentechnology.com\/htblog\/wp-content\/uploads\/2024\/01\/Excelerated-e1715376682978.png?fit=1652%2C707&ssl=1","datePublished":"2024-02-04T23:16:25+00:00","dateModified":"2024-06-26T21:24:21+00:00","breadcrumb":{"@id":"https:\/\/haydentechnology.com\/htblog\/2024\/02\/exceleration-power-apps-get-sharepoint-data-using-power-automate\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/haydentechnology.com\/htblog\/2024\/02\/exceleration-power-apps-get-sharepoint-data-using-power-automate\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/haydentechnology.com\/htblog\/2024\/02\/exceleration-power-apps-get-sharepoint-data-using-power-automate\/#primaryimage","url":"https:\/\/i0.wp.com\/haydentechnology.com\/htblog\/wp-content\/uploads\/2024\/01\/Excelerated-e1715376682978.png?fit=1652%2C707&ssl=1","contentUrl":"https:\/\/i0.wp.com\/haydentechnology.com\/htblog\/wp-content\/uploads\/2024\/01\/Excelerated-e1715376682978.png?fit=1652%2C707&ssl=1","width":1652,"height":707,"caption":"Excelerate your productivity"},{"@type":"BreadcrumbList","@id":"https:\/\/haydentechnology.com\/htblog\/2024\/02\/exceleration-power-apps-get-sharepoint-data-using-power-automate\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/haydentechnology.com\/htblog\/"},{"@type":"ListItem","position":2,"name":"Exceleration: Power Apps Get Sharepoint Data using Power Automate"}]},{"@type":"WebSite","@id":"https:\/\/haydentechnology.com\/htblog\/#website","url":"https:\/\/haydentechnology.com\/htblog\/","name":"Innovative Consulting for banks and credit unions","description":"Hayden Technology provides innovative thought leadership, complex program management and Agile technology delivery for banks and credit Unions","publisher":{"@id":"https:\/\/haydentechnology.com\/htblog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/haydentechnology.com\/htblog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/haydentechnology.com\/htblog\/#organization","name":"Innovative Consulting for banks and credit unions","url":"https:\/\/haydentechnology.com\/htblog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/haydentechnology.com\/htblog\/#\/schema\/logo\/image\/","url":"https:\/\/i0.wp.com\/haydentechnology.com\/htblog\/wp-content\/uploads\/2022\/09\/HT-full-transparentBG.png?fit=3000%2C800&ssl=1","contentUrl":"https:\/\/i0.wp.com\/haydentechnology.com\/htblog\/wp-content\/uploads\/2022\/09\/HT-full-transparentBG.png?fit=3000%2C800&ssl=1","width":3000,"height":800,"caption":"Innovative Consulting for banks and credit unions"},"image":{"@id":"https:\/\/haydentechnology.com\/htblog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/x.com\/mwoollen"]},{"@type":"Person","@id":"https:\/\/haydentechnology.com\/htblog\/#\/schema\/person\/21588820fde62f721d7dda8f826fc698","name":"Mark Woollen","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/haydentechnology.com\/htblog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/5c4473086f76e17c354f3d960303d0f3?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/5c4473086f76e17c354f3d960303d0f3?s=96&d=mm&r=g","caption":"Mark Woollen"},"description":"Industry leader helping banks and credit unions make decisions that matter and deliver important programs with Agility.","sameAs":["https:\/\/www.linkedin.com\/in\/markwoollen\/","https:\/\/x.com\/mwoollen"],"url":"https:\/\/haydentechnology.com\/htblog\/author\/mwoollen\/"}]}},"jetpack_featured_media_url":"https:\/\/i0.wp.com\/haydentechnology.com\/htblog\/wp-content\/uploads\/2024\/01\/Excelerated-e1715376682978.png?fit=1652%2C707&ssl=1","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p9CfAC-1Zm","jetpack_likes_enabled":true,"jetpack-related-posts":[],"featured_media_urls":{"thumbnail":["https:\/\/i0.wp.com\/haydentechnology.com\/htblog\/wp-content\/uploads\/2024\/01\/Excelerated-e1715376682978.png?resize=150%2C150&ssl=1",150,150,true],"medium":["https:\/\/i0.wp.com\/haydentechnology.com\/htblog\/wp-content\/uploads\/2024\/01\/Excelerated-e1715376682978.png?fit=300%2C128&ssl=1",300,128,true],"medium_large":["https:\/\/i0.wp.com\/haydentechnology.com\/htblog\/wp-content\/uploads\/2024\/01\/Excelerated-e1715376682978.png?fit=768%2C329&ssl=1",768,329,true],"large":["https:\/\/i0.wp.com\/haydentechnology.com\/htblog\/wp-content\/uploads\/2024\/01\/Excelerated-e1715376682978.png?fit=840%2C359&ssl=1",840,359,true],"1536x1536":["https:\/\/i0.wp.com\/haydentechnology.com\/htblog\/wp-content\/uploads\/2024\/01\/Excelerated-e1715376682978.png?fit=1536%2C657&ssl=1",1536,657,true],"2048x2048":["https:\/\/i0.wp.com\/haydentechnology.com\/htblog\/wp-content\/uploads\/2024\/01\/Excelerated-e1715376682978.png?fit=1652%2C707&ssl=1",1652,707,true],"post-thumbnail":["https:\/\/i0.wp.com\/haydentechnology.com\/htblog\/wp-content\/uploads\/2024\/01\/Excelerated-e1715376682978.png?fit=1200%2C514&ssl=1",1200,514,true],"portfolio_item-thumbnail":["https:\/\/i0.wp.com\/haydentechnology.com\/htblog\/wp-content\/uploads\/2024\/01\/Excelerated-e1715376682978.png?resize=600%2C400&ssl=1",600,400,true],"portfolio_item-thumbnail@2x":["https:\/\/i0.wp.com\/haydentechnology.com\/htblog\/wp-content\/uploads\/2024\/01\/Excelerated-e1715376682978.png?resize=1200%2C707&ssl=1",1200,707,true],"portfolio_item-masonry":["https:\/\/i0.wp.com\/haydentechnology.com\/htblog\/wp-content\/uploads\/2024\/01\/Excelerated-e1715376682978.png?fit=600%2C257&ssl=1",600,257,true],"portfolio_item-masonry@2x":["https:\/\/i0.wp.com\/haydentechnology.com\/htblog\/wp-content\/uploads\/2024\/01\/Excelerated-e1715376682978.png?fit=1200%2C514&ssl=1",1200,514,true],"portfolio_item-thumbnail_cinema":["https:\/\/i0.wp.com\/haydentechnology.com\/htblog\/wp-content\/uploads\/2024\/01\/Excelerated-e1715376682978.png?resize=800%2C335&ssl=1",800,335,true],"portfolio_item-thumbnail_portrait":["https:\/\/i0.wp.com\/haydentechnology.com\/htblog\/wp-content\/uploads\/2024\/01\/Excelerated-e1715376682978.png?resize=600%2C707&ssl=1",600,707,true],"portfolio_item-thumbnail_portrait@2x":["https:\/\/i0.wp.com\/haydentechnology.com\/htblog\/wp-content\/uploads\/2024\/01\/Excelerated-e1715376682978.png?resize=1200%2C707&ssl=1",1200,707,true],"portfolio_item-thumbnail_square":["https:\/\/i0.wp.com\/haydentechnology.com\/htblog\/wp-content\/uploads\/2024\/01\/Excelerated-e1715376682978.png?resize=800%2C707&ssl=1",800,707,true]},"_links":{"self":[{"href":"https:\/\/haydentechnology.com\/htblog\/wp-json\/wp\/v2\/posts\/7648","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/haydentechnology.com\/htblog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/haydentechnology.com\/htblog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/haydentechnology.com\/htblog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/haydentechnology.com\/htblog\/wp-json\/wp\/v2\/comments?post=7648"}],"version-history":[{"count":9,"href":"https:\/\/haydentechnology.com\/htblog\/wp-json\/wp\/v2\/posts\/7648\/revisions"}],"predecessor-version":[{"id":7690,"href":"https:\/\/haydentechnology.com\/htblog\/wp-json\/wp\/v2\/posts\/7648\/revisions\/7690"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/haydentechnology.com\/htblog\/wp-json\/wp\/v2\/media\/7600"}],"wp:attachment":[{"href":"https:\/\/haydentechnology.com\/htblog\/wp-json\/wp\/v2\/media?parent=7648"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/haydentechnology.com\/htblog\/wp-json\/wp\/v2\/categories?post=7648"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/haydentechnology.com\/htblog\/wp-json\/wp\/v2\/tags?post=7648"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}