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.

@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!

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

New Ideas Forum MPA.jpg

A new place to submit your Ideas for Power Automate

Announcing a new way to share your feedback with the Power Automate Team.

MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

MPA Licensing.jpg

Ask your licensing questions at the Power Automate AMA!

Join Priya Kodukula and the licensing team, super users and MVPs to find answers to your questions on Power Automate licensing.

Users online (1,874)