Power Platform Community Forum Thread Details

Hi All,

I have A.xlsx which has a worksheet with 3 columns with data and B.xlsx has a worksheet with 5 columns (first 3 column headers are identical in both the excel).

I need to have a master excel which is C.xlsx which should have all the data in A.xlsx and B.xlsx in a single worksheet with additional columns which is in B.xlsx.

Could you please help me with the Power automate flow details as I am a newbie to the Power automate.

Categories:

Building flows

Hi @gopimadhu ,

Is your data from files A and B organized into Excel tables? If yes, we can try to use some Excel actions to generate this Master file; if not, we will need to use Office Scripts to execute this migration.

As you are new to Power Automate, I'm sharing some introductory articles about some of the topics that we will need to explore for this solution.