cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
JPdarling9
Advocate I
Advocate I

Join data in multiple arrays based on an ID column

I am working on a process for getting a consolidated view of data from multiple SharePoint lists into a CSV file that will get emailed to my staff when they run this flow from PowerApps. The majority of this I can handle, but where I'm struggling is how to join data between my SharePoint lists (creating an array of each for now as well).

 

My first list (volumes) has a column called projects which I am filtering based on an ID number I pass to the flow from PowerApps (easy, done).

 

The second list (volume_iterations) is contains a volume_id field which corresponds to a volume in the first list, and has extended data about each volume.

 

My final CSV should have a series of row items, each which contain columns from the volumes and volume_iterations lists.

 

What is the best way to make this happen?

2 ACCEPTED SOLUTIONS

Accepted Solutions

Hi @JPdarling9 ,

 

Please refer to screenshot below to create the flow:

1.png2.png

 

Best regards,

Alice       

 

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

@v-alzhan-msft This did it! It was a slightly different result because I end up having a nested apply to each at the append to array step, but it works.

 

Also gives me a nice, clean set of column headers and values in the order I want.

 

Thank you very much for the help!

View solution in original post

4 REPLIES 4
v-alzhan-msft
Community Support
Community Support

 Hi @JPdarling9 ,

 

I would suggest that you could share more details about the lists with data in to and please share an example of the combined array that you want to create the csv table so we could better understand the issue and provide a proper workaround for you.

 

Best regards,

Alice       

 

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

@v-alzhan-msft 

 

Here are some of the key columns I'm interested in my two lists:

 

cpVolumes:

ID, Title, sort_id, sorted, sorted_level, volume_sort

 

cpVolumeIterations:

ID, volume_ID, area_net_sm, arean_net_sf, volume_capacity, volume_count

 

For each cpVolumes.ID, there are one or more records in cpVolumeIterations. When I obtain my final array of data, I want to have all records in cpVolumeIterations with their corresponding values from cpVolumes.

 

Here's the final array I am looking for:

ID, Title, sort_id, sorted, sorted_level, volume_sort, vi_ID,  area_net_sm, arean_net_sf, volume_capacity, volume_count

Hi @JPdarling9 ,

 

Please refer to screenshot below to create the flow:

1.png2.png

 

Best regards,

Alice       

 

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

@v-alzhan-msft This did it! It was a slightly different result because I end up having a nested apply to each at the append to array step, but it works.

 

Also gives me a nice, clean set of column headers and values in the order I want.

 

Thank you very much for the help!

View solution in original post

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Solution Authors
Top Kudoed Authors
Users online (1,065)