Appending two files where one of the files is generated using a flow.

(0) Share

Report

Posted on by d0zxe

Hi All,

I am new to power automate and would need some help in creating a flow.

So in my case, I have two files I would like to combine. They have same properties etc etc. One of the files is generated via an API using power automate, however it only creates 2 months worth of data when the flow runs once every month. My second file is a master file that contains historical data. At the moment, I do this manually once every month where I copy/paste the new data generated from the API flow to the master file. Is there a way to automate the process of appending the API generated file to the master file, master file should only have new API generated data added to it. Any help would be appreciated, thanks.

Categories:

General topics

I have the same question (0)

All responses (2)

Answers (0)

Andrew_J 1,962 Moderator on at

Like (0)

Report
Copy link

Link copied!

@d0zxe

What file type are you refering to, is this Word, Excel or other.
Where is the source data from the API coming from

Andrew

Was this reply helpful? Yes No
d0zxe 2 on at

Like (0)

Report
Copy link

Link copied!

The file type is Excel csv, the API data source is a software that stores fuel consumption figures for the firm I work with. it literally gives us backend access to their database to download csv files. so I created a flow that downloads this data and stores in one drive for our monthly analytics reporting.

Was this reply helpful? Yes No