Showing results for 
Search instead for 
Did you mean: 
Level: Powered On

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

Re: Different data sources into a single table

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



Level: Powered On

Re: Different data sources into a single table

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.

Super User
Super User

Re: Different data sources into a single table

@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


Microsoft Flow Online Conference

Join us for a FULL day of FREE Microsoft Flow Sessions from some of the best minds in the industry!


Watch Sessions On Demand!

Continue your learning in our online communities.

Power Platform 2019 Release Wave 2 Plan

Power Platform 2019 Release Wave 2 Plan

Features releasing from October 2019 through March 2020


Flow Community User Group Member Badge

Fill out a quick form to claim your user group badge now!


New Flow Community Board!

Check out the new Microsoft Flow Community Blog Topic Suggestion board!


Microsoft Learn

Learn how to build the business apps that you need


Power Platform World Tour

Find out where you can attend!


Webinars & Video Gallery

Watch & learn from the Flow Community Video Gallery!

Top Kudoed Authors
Users Online
Currently online: 205 members 4,693 guests
Recent signins:
Please welcome our newest community members: