Showing results for 
Search instead for 
Did you mean: 
Advocate II
Advocate II

Different data sources into a single table

I'm trying to take multiple data sources and merge them into a single table in flow that will be used to update another list. My issues is that I can't get the the array to have multiple columns, and when I try to label one column, the output looks like this. 


Flow Issue 1.PNG





Is there a way for me to make an array of items that has different columns? Is this what the object type is the initialize variable action?

Super User
Super User

@alietzau ,


I think you are close.  I think you can do your column naming with Filter Array, then cram the output of that into an array variable.  That should get you where you want to go.  Here is an example.



Hi @martinav!


I think that helped me get closer but I can't seem to get the different get items to merge into the array variable I made. When I try add it, I get this error.


I'm just trying the IDs to see if I can get it to work, and it doesn't seem to be able to do that.

@alietzau ,


There is something else going on here.  I have done this not long ago, I will look into my Flow to see what I did.  I think you may have to represent every variable in the array when you post your append.  I dont recall exactly, but I will check into it.

Helpful resources

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.

May UG Leader Call Carousel 768x460.png

June User Group Leader Call

Join us on June 28 for our monthly User Group leader call!

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.

Power Automate Designer Feedback_carousel.jpg

Help make Flow Design easier

Are you new to designing flows? What is your biggest struggle with Power Automate Designer? Help us make it more user friendly!

Top Solution Authors
Top Kudoed Authors
Users online (3,286)