Export csv file, compare to other csv file, and create csv file with changes

(1) Share

Report

Posted on by md7

232

Hi all,

I have been tasked to find a way to compare two reports (one from the current month, one from the previous month), find any changes and then create a excel file with those changes on.

My data is in dataverse and exports monthly using a flow so I always have a monthly back up.

Is there a way of doing this? There's about 60-70 columns in the csv files.

Thanks!

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (0)

Robby_WW 115 on at

Like (0)

Report

Hi,

There is a way to compare 2 .csv files but it will take a very long time on big datasets.

I'm afraid there's no real good way of doing this.

Creating a new .csv file is not possible, i believe.

Was this reply helpful? Yes No
takolota1 4,974 Moderator on at

Like (0)

Report

It is possible to efficiently get your CSV data from both files into JSON arrays with something like...
https://community.powerplatform.com/galleries/gallery-posts/?postid=189733b3-bea9-41b3-bc01-ec0fa209005d

Then once both the CSVs are in JSON arrays you can use a series of intersect( ) expressions, union( ) expressions, & Filter array actions along with primary keys to identify the rows with changes.
This build contains an example of such a set-up...
https://community.powerplatform.com/galleries/gallery-posts/?postid=e1e47e8f-9bfd-4d9c-9b43-68ced3a6cbfb

From there you can get both the new version of the row from the new CSV & the old version of the row from the preceding CSV.

Was this reply helpful? Yes No