cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
alietzau
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?

3 REPLIES 3
martinav
Resident Rockstar
Resident Rockstar

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

 

image.png

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.

martinav
Resident Rockstar
Resident Rockstar

@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

Announcements
Process Advisor

Introducing Process Advisor

Check out the new Process Advisor community forum board!

MPA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

Users online (71,864)