{"id":7215,"date":"2024-10-28T13:20:32","date_gmt":"2024-10-28T13:20:32","guid":{"rendered":"https:\/\/softreetechnology.com\/blog\/?p=7215"},"modified":"2024-10-28T13:23:28","modified_gmt":"2024-10-28T13:23:28","slug":"getting-number-of-row-data-from-dataverse-and-sending-as-response-to-powerapps-using-power-automate","status":"publish","type":"post","link":"https:\/\/softreetechnology.com\/blog\/power-platform\/getting-number-of-row-data-from-dataverse-and-sending-as-response-to-powerapps-using-power-automate\/","title":{"rendered":"Getting number of Row Data from Dataverse and Sending as Response to PowerApps using Power Automate"},"content":{"rendered":"\n

This is one of the requirements we faced for PowerApps solution. Where we will get the number of items required and from which item Id.<\/strong><\/strong><\/p>\n\n\n\n

First step <\/strong><\/p>\n\n\n\n

We used a connector which collects data from PowerApps about page size means how many items it needs to retrieve, and what is the starting item id.<\/strong><\/p>\n\n\n\n

Second Step<\/strong><\/p>\n\n\n\n

We will add a compose action which takes page input size<\/strong><\/p>\n\n\n\n

\"\"\/<\/figure>\n\n\n\n

Again we used Compose action to store Starting item Id<\/strong><\/p>\n\n\n\n

\"\"\/<\/figure>\n\n\n\n

Then we used a Dataverse connector which will retrieve data from Dataverse, We need to provide Table Name, columns internal names in select column section, Filter query i.e we needs to check if provided page size is greater then serial ID then it will return rows. Again we can set Row count means how many rows we want to retrieve from Dataverse at once.<\/strong><\/p>\n\n\n\n

\"\"\/<\/figure>\n\n\n\n

In the next step we will use Select Action<\/strong><\/p>\n\n\n\n

Select action allows you to transform the shape of objects in an array.<\/strong><\/p>\n\n\n\n

\"\"\/<\/figure>\n\n\n\n

We will Map those values from Dataverse with Key Value Pair.<\/strong><\/p>\n\n\n\n

\"\"\/<\/figure>\n\n\n\n

We again send the response to Power Apps, Power Apps will again request data for Next Page if next button is clicked.<\/strong><\/p>\n\n\n\n

This flow will run for every click on next and previous button on Power Apps Gallery.<\/strong><\/p>\n","protected":false},"excerpt":{"rendered":"

This is one of the requirements we faced for PowerApps solution. Where we will get the number of items required and from which item Id. First step  We used a connector which collects data from PowerApps about page size means how many items it needs to retrieve, and what is the starting item id. Second Step We will add a […]<\/p>\n","protected":false},"author":1,"featured_media":7216,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[338],"tags":[373,374,341,323,375],"class_list":["post-7215","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-power-platform","tag-dataverse-data-retrieval-in-powerapps","tag-dataverse-integration-with-powerapps","tag-power-automate","tag-powerapps","tag-powerapps-and-dataverse-integration"],"yoast_head":"\nGetting number of Row Data from Dataverse and Sending as Response to PowerApps using Power Automate - Softree Technology<\/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:\/\/softreetechnology.com\/blog\/power-platform\/getting-number-of-row-data-from-dataverse-and-sending-as-response-to-powerapps-using-power-automate\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Getting number of Row Data from Dataverse and Sending as Response to PowerApps using Power Automate - Softree Technology\" \/>\n<meta property=\"og:description\" content=\"This is one of the requirements we faced for PowerApps solution. Where we will get the number of items required and from which item Id. First step  We used a connector which collects data from PowerApps about page size means how many items it needs to retrieve, and what is the starting item id. Second Step We will add a […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/softreetechnology.com\/blog\/power-platform\/getting-number-of-row-data-from-dataverse-and-sending-as-response-to-powerapps-using-power-automate\/\" \/>\n<meta property=\"og:site_name\" content=\"Softree Technology\" \/>\n<meta property=\"article:published_time\" content=\"2024-10-28T13:20:32+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-10-28T13:23:28+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/softreetechnology.com\/blog\/wp-content\/uploads\/2024\/10\/Getting-number-of-Row-Data-from-Dataverse-and-Sending-as-Response-to-Power-Apps-using-Power-Automate.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1080\" \/>\n\t<meta property=\"og:image:height\" content=\"1080\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"admin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"admin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Getting number of Row Data from Dataverse and Sending as Response to PowerApps using Power Automate - Softree Technology","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:\/\/softreetechnology.com\/blog\/power-platform\/getting-number-of-row-data-from-dataverse-and-sending-as-response-to-powerapps-using-power-automate\/","og_locale":"en_US","og_type":"article","og_title":"Getting number of Row Data from Dataverse and Sending as Response to PowerApps using Power Automate - Softree Technology","og_description":"This is one of the requirements we faced for PowerApps solution. Where we will get the number of items required and from which item Id. First step  We used a connector which collects data from PowerApps about page size means how many items it needs to retrieve, and what is the starting item id. Second Step We will add a […]","og_url":"https:\/\/softreetechnology.com\/blog\/power-platform\/getting-number-of-row-data-from-dataverse-and-sending-as-response-to-powerapps-using-power-automate\/","og_site_name":"Softree Technology","article_published_time":"2024-10-28T13:20:32+00:00","article_modified_time":"2024-10-28T13:23:28+00:00","og_image":[{"width":1080,"height":1080,"url":"https:\/\/softreetechnology.com\/blog\/wp-content\/uploads\/2024\/10\/Getting-number-of-Row-Data-from-Dataverse-and-Sending-as-Response-to-Power-Apps-using-Power-Automate.png","type":"image\/png"}],"author":"admin","twitter_card":"summary_large_image","twitter_misc":{"Written by":"admin","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/softreetechnology.com\/blog\/power-platform\/getting-number-of-row-data-from-dataverse-and-sending-as-response-to-powerapps-using-power-automate\/#article","isPartOf":{"@id":"https:\/\/softreetechnology.com\/blog\/power-platform\/getting-number-of-row-data-from-dataverse-and-sending-as-response-to-powerapps-using-power-automate\/"},"author":{"name":"admin","@id":"https:\/\/softreetechnology.com\/blog\/#\/schema\/person\/98740297642f06debccdcee2de84086b"},"headline":"Getting number of Row Data from Dataverse and Sending as Response to PowerApps using Power Automate","datePublished":"2024-10-28T13:20:32+00:00","dateModified":"2024-10-28T13:23:28+00:00","mainEntityOfPage":{"@id":"https:\/\/softreetechnology.com\/blog\/power-platform\/getting-number-of-row-data-from-dataverse-and-sending-as-response-to-powerapps-using-power-automate\/"},"wordCount":230,"commentCount":0,"publisher":{"@id":"https:\/\/softreetechnology.com\/blog\/#organization"},"image":{"@id":"https:\/\/softreetechnology.com\/blog\/power-platform\/getting-number-of-row-data-from-dataverse-and-sending-as-response-to-powerapps-using-power-automate\/#primaryimage"},"thumbnailUrl":"https:\/\/softreetechnology.com\/blog\/wp-content\/uploads\/2024\/10\/Getting-number-of-Row-Data-from-Dataverse-and-Sending-as-Response-to-Power-Apps-using-Power-Automate.png","keywords":["Dataverse Data Retrieval in PowerApps","Dataverse Integration with PowerApps","Power Automate","PowerApps","PowerApps and Dataverse Integration"],"articleSection":["Power Platform"],"inLanguage":"en","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/softreetechnology.com\/blog\/power-platform\/getting-number-of-row-data-from-dataverse-and-sending-as-response-to-powerapps-using-power-automate\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/softreetechnology.com\/blog\/power-platform\/getting-number-of-row-data-from-dataverse-and-sending-as-response-to-powerapps-using-power-automate\/","url":"https:\/\/softreetechnology.com\/blog\/power-platform\/getting-number-of-row-data-from-dataverse-and-sending-as-response-to-powerapps-using-power-automate\/","name":"Getting number of Row Data from Dataverse and Sending as Response to PowerApps using Power Automate - Softree Technology","isPartOf":{"@id":"https:\/\/softreetechnology.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/softreetechnology.com\/blog\/power-platform\/getting-number-of-row-data-from-dataverse-and-sending-as-response-to-powerapps-using-power-automate\/#primaryimage"},"image":{"@id":"https:\/\/softreetechnology.com\/blog\/power-platform\/getting-number-of-row-data-from-dataverse-and-sending-as-response-to-powerapps-using-power-automate\/#primaryimage"},"thumbnailUrl":"https:\/\/softreetechnology.com\/blog\/wp-content\/uploads\/2024\/10\/Getting-number-of-Row-Data-from-Dataverse-and-Sending-as-Response-to-Power-Apps-using-Power-Automate.png","datePublished":"2024-10-28T13:20:32+00:00","dateModified":"2024-10-28T13:23:28+00:00","breadcrumb":{"@id":"https:\/\/softreetechnology.com\/blog\/power-platform\/getting-number-of-row-data-from-dataverse-and-sending-as-response-to-powerapps-using-power-automate\/#breadcrumb"},"inLanguage":"en","potentialAction":[{"@type":"ReadAction","target":["https:\/\/softreetechnology.com\/blog\/power-platform\/getting-number-of-row-data-from-dataverse-and-sending-as-response-to-powerapps-using-power-automate\/"]}]},{"@type":"ImageObject","inLanguage":"en","@id":"https:\/\/softreetechnology.com\/blog\/power-platform\/getting-number-of-row-data-from-dataverse-and-sending-as-response-to-powerapps-using-power-automate\/#primaryimage","url":"https:\/\/softreetechnology.com\/blog\/wp-content\/uploads\/2024\/10\/Getting-number-of-Row-Data-from-Dataverse-and-Sending-as-Response-to-Power-Apps-using-Power-Automate.png","contentUrl":"https:\/\/softreetechnology.com\/blog\/wp-content\/uploads\/2024\/10\/Getting-number-of-Row-Data-from-Dataverse-and-Sending-as-Response-to-Power-Apps-using-Power-Automate.png","width":1080,"height":1080},{"@type":"BreadcrumbList","@id":"https:\/\/softreetechnology.com\/blog\/power-platform\/getting-number-of-row-data-from-dataverse-and-sending-as-response-to-powerapps-using-power-automate\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/softreetechnology.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Getting number of Row Data from Dataverse and Sending as Response to PowerApps using Power Automate"}]},{"@type":"WebSite","@id":"https:\/\/softreetechnology.com\/blog\/#website","url":"https:\/\/softreetechnology.com\/blog\/","name":"Softree Technology","description":"Celebrating 10+ Years in SharePoint Consulting !","publisher":{"@id":"https:\/\/softreetechnology.com\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/softreetechnology.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en"},{"@type":"Organization","@id":"https:\/\/softreetechnology.com\/blog\/#organization","name":"Softree Technology","url":"https:\/\/softreetechnology.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en","@id":"https:\/\/softreetechnology.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/softreetechnology.com\/blog\/wp-content\/uploads\/2023\/03\/cropped-white-logo-soft.png","contentUrl":"https:\/\/softreetechnology.com\/blog\/wp-content\/uploads\/2023\/03\/cropped-white-logo-soft.png","width":844,"height":230,"caption":"Softree Technology"},"image":{"@id":"https:\/\/softreetechnology.com\/blog\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/softreetechnology.com\/blog\/#\/schema\/person\/98740297642f06debccdcee2de84086b","name":"admin","image":{"@type":"ImageObject","inLanguage":"en","@id":"https:\/\/softreetechnology.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/6fc78c8a7aa3fb0bf43c3b9a2e3962d7?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/6fc78c8a7aa3fb0bf43c3b9a2e3962d7?s=96&d=mm&r=g","caption":"admin"},"sameAs":["https:\/\/softreeconsulting.com"],"url":"https:\/\/softreetechnology.com\/blog\/author\/admin\/"}]}},"_links":{"self":[{"href":"https:\/\/softreetechnology.com\/blog\/wp-json\/wp\/v2\/posts\/7215","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/softreetechnology.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/softreetechnology.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/softreetechnology.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/softreetechnology.com\/blog\/wp-json\/wp\/v2\/comments?post=7215"}],"version-history":[{"count":1,"href":"https:\/\/softreetechnology.com\/blog\/wp-json\/wp\/v2\/posts\/7215\/revisions"}],"predecessor-version":[{"id":7217,"href":"https:\/\/softreetechnology.com\/blog\/wp-json\/wp\/v2\/posts\/7215\/revisions\/7217"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/softreetechnology.com\/blog\/wp-json\/wp\/v2\/media\/7216"}],"wp:attachment":[{"href":"https:\/\/softreetechnology.com\/blog\/wp-json\/wp\/v2\/media?parent=7215"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/softreetechnology.com\/blog\/wp-json\/wp\/v2\/categories?post=7215"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/softreetechnology.com\/blog\/wp-json\/wp\/v2\/tags?post=7215"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}