Power Platform Community Forum Thread Details

Hi,

I haven't tried this specifically, but this looks pretty good. Check this out!

Initialize Two Arrays:
- Use the "Initialize variable" action to create two array variables (Array1 and Array2).
- Populate each array with the respective list data. If the lists are dynamic (e.g., from a SharePoint list or SQL query), use the appropriate actions to retrieve the data.
Example for Array1:
```
 
```
[ { "Column1": "Value1A", "Column2": "Value1B" }, { "Column1": "Value2A", "Column2": "Value2B" } ]

Example for Array2:
```
 
```
[ { "Column1": "Value3A", "Column2": "Value3B" }, { "Column1": "Value4A", "Column2": "Value4B" } ]
Initialize a Combined Array Variable:
- Add another "Initialize variable" action to create an array variable (CombinedArray).
- Set the type to Array and leave the value blank.
Append the First Array:
- Use the "Append to array variable" action to append Array1 to CombinedArray.
Append the Second Array:
- Use another "Append to array variable" action to append Array2 to CombinedArray.
Output the Combined Array:
- Use the "Compose" action or another action (e.g., create an Excel file, update a SharePoint list) to use the CombinedArray for further processing.