Power Platform Community Forum Thread Details

So I have two Excel Files - File A and File B.

File A has four columns, one with data, one with the date, one with the time and one with the source of the data.

File B has multiple columns. One column has the source of the data and contains the same information as File A. The other columns are basically information about the data source.

File A basically has data for ~10 sources but it has data for about a month. So in total, there is easily 1000+ data points. I don't know how much data is there for each data source.

What I want to do is merge the two files together. For every data point in file A, I want the corresponding data source information to be put in the same row but separate columns.

Can I do that in automate

Categories:

Building flows

Hi @Anonymous,

Do you want to merge FileA and FileB as a single table based on the data column?

Could you please share your data sample with me?

If this Data column is the primary key column in your excel table, I think you could list both of these 2 tables firstly and you can then use the Union() function to combine those two arrays. If they have the same column it should just add the records from the second to the first. Here's the documentation on Union()

Reference guide for functions in expressions - Azure Logic Apps | Microsoft Docs

In addition, here is a similar thread that may fit your scenario:

Create a single table from multiple tables - Power Platform Community (microsoft.com)