![\"List](\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2024\/06\/Technical-blog-1.png\")
<\/p>\n<\/p>\n
As Microsoft is providing us more flexibility with Power Automate (MS Flow), now we can retrieve List of solution details and their components <\/strong>directly within Power Automate flows.<\/p>\n Recently, we got a requirement to retrieve the list of solutions and their components from specific environments and store this information in an Excel file on SharePoint.<\/p>\n We can achieve this using Solution and Solution Components entity records in Dynamics CRM.<\/p>\n Below are the steps to achieve this requirement.<\/p>\n This array variable should include the details of the solution component types you want to retrieve from the solution, as shown in the screenshot below.<\/p>\n The above array contains the following details of the solution component types:<\/p>\n You can find all solution component types information in Microsoft Documentation<\/a><\/p>\n Add the ‘List rows from selected environment’ step to retrieve the solutions from the specific environment. Use a filter query to retrieve the visible solutions and exclude the default solution.<\/p>\n Step 3: Retrieve Solution Components<\/u><\/strong><\/p>\n Now, proceed to retrieve the solution component for the previously obtained solution. Utilize an ‘Apply to Each’ step to iterate through each solution, and within that, add a ‘List rows’ action to retrieve the solution component using the filter rows.<\/p>\n Step 4: Filter Array step to check the Component Type<\/u><\/strong><\/p>\n For each solution component, implement an ‘Apply to Each’ loop. Inside this loop, use a Filter Array step to check that the Component Type of the current solution component matches the type specified in the array variable we set up earlier.<\/p>\n Expressions from the above image:<\/p>\n Add the ‘List rows’ step to retrieve the solution component if the Component Type matches and add a row into the Excel table.<\/p>\n Expressions from the above image:<\/p>\n Expressions from the above image:<\/p>\n By following these steps, you can retrieve Solutions and their component details using Power Automate flow.<\/p>\n From customizing Microsoft Dynamics 365<\/a> to developing Copilot-enabled Power Platform Apps<\/a>, our outsourced development services ensure top-notch solutions tailored to your needs. Let our experts handle the technicalities while you focus on your core business. Email us at crm@inogic.com<\/a> to get started today.<\/p>\n <\/p>\n About Sam Kumar<\/strong><\/p>\n Sam Kumar is the Vice President of Marketing at Inogic, a Microsoft Gold ISV Partner renowned for its innovative apps for Dynamics 365 CRM and Power Apps. With a rich history in Dynamics 365 and Power Platform development, Sam leads a team of certified CRM developers dedicated to pioneering cutting-edge technologies with Copilot and Azure AI the latest additions. Passionate about transforming the CRM industry, Sam\u2019s insights and leadership drive Inogic\u2019s mission to change the \u201cDynamics\u201d of CRM.<\/p>\n More about\u00a0Sam Kumar<\/a><\/p>\n","protected":false},"excerpt":{"rendered":" As Microsoft is providing us more flexibility with Power Automate (MS Flow), now we can retrieve List of solution details and their components directly within Power Automate flows. Recently, we got a requirement to retrieve the list of solutions and their components from specific environments and store this information in an Excel file on SharePoint.\u2026 Read More »<\/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":[36,1985],"tags":[2542],"class_list":["post-38322","post","type-post","status-publish","format-standard","hentry","category-microsoft-flow","category-power-automate","tag-power-automate-flow"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/posts\/38322","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=38322"}],"version-history":[{"count":0,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/posts\/38322\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/media?parent=38322"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/categories?post=38322"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/tags?post=38322"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}Step 1: Initialize the Array variable <\/u><\/strong><\/h3>\n
![\"List](\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2024\/06\/List-solution-details-and-their-components-1.png\")
<\/p>\n\n
Step 2: Retrieve solutions <\/u><\/strong><\/h3>\n
![\"List](\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2024\/06\/List-solution-details-and-their-components-2.png\")
<\/p>\n![\"List](\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2024\/06\/List-solution-details-and-their-components-3.png\")
<\/p>\n![\"List](\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2024\/06\/List-solution-details-and-their-components-4.png\")
<\/p>\n\n
Step 5: Retrieve Solution Components Summary<\/u><\/strong><\/h3>\n
![\"List](\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2024\/06\/List-solution-details-and-their-components-5.png\")
<\/p>\n\n
![\"List](\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2024\/06\/List-solution-details-and-their-components-6.png\")
<\/p>\n\n
![\"List](\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2024\/06\/List-solution-details-and-their-components-7.png\")
<\/p>\nConclusion:<\/strong><\/h2>\n
Outsource Development Made Easy for Dynamics 365 CRM and Power Platform! <\/strong><\/div><\/div>\n