List solution details and their components using Power Automate Flow

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.

We can achieve this using Solution and Solution Components entity records in Dynamics CRM.

Below are the steps to achieve this requirement.

Step 1: Initialize the Array variable

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.

The above array contains the following details of the solution component types:

• ComponentType – The type value of the component from the documentation.
• EntityName – The logical name of the component type.
• FilterRowName – The field name to filter the component type.
• SelectColumn – The field name to…

Source link