cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Mattw112IG
Level 8

Comparing Excel Files

I would consider myself an intermediate Flow user.  I've created several basic ones and they work fine.  I'm having a hard time getting this latest request working.

 

For our Projct Managers (let's say 7 of them).  They have a weekly spreadsheet that each of them completes that lists seveal details of various projects and other things.  This spreadsheet has multiple tabs.  This spreadsheet is uploaded to OneDrive for Business in a specific folder.

 

Currently, the Tableau guys manually kick off a Query that can combine these spreadsheets into one consolidated spreadsheet that Tableau is pointed at to colelct data and visually represent it.

 

But these spreadsheets get updated manually all the time and so they would always like the latest data in Tableau.  But they don't want to have to manually go out every 15 min and run the query to combine everything.

 

So in flow, I would like to say every time a file is modified or created in a specific folder, compare the changed entries (or new entries) to the consolidated spreadsheet and if different update them. 

 

Now we could also just delete the main consolidated spreadsheet and then consolidate all the existing reports in that folder into one again...

 

I've tried building this out in Flow several different ways but just not getting how to do this?

 

So looking for some advice on approaches to this? Or if it is even possible.

 

Thanks,

Terry

5 REPLIES 5
Community Support Team
Community Support Team

Re: Comparing Excel Files

Hi @ Mattw112IG,

 

 

Do you want to update the consolidated spreadsheet with date from a spreadsheet in a specific folder in OneDrive for Business?

 

If you want to update the consolidated spreadsheet with date from a spreadsheet in a specific folder in OneDrive for Business,and the spreadsheet in a specific folder isn't a specific file,I afraid that there is no way to achieve your needs in Microsoft Flow currently. The "Get rows" action of excel connector could only get a excel file from the Picker as below:

Capture.PNG

You couldn't get the excel file from mannually enter the file path or a dynamic content in the "File name" field.

 

 

So if you would like to achieve your need, you should make sure you could only update the specific spreadsheet in a specific folder, to trigger the flow to update the consolidated spreadsheet.

 

I would create a flow to update the consolidated spreadsheet in foder "b" with the specific modified spreadsheet in folder "a".

 

I have created a consolidated spreadsheet in foder "b" and a same specific modified spreadsheet in folder "a" as below:

Capture.PNG

 

You could refer to screenshot below to create the flow:

 

 

 

Capture.PNG

 Capture.PNG

 Capture.PNG

Capture.PNG

 

 

 

 

Please let me know if your problem could be solved

 

 

 

Regards,
Alice Zhang

Mattw112IG
Level 8

Re: Comparing Excel Files

Wow, thanks this will take me a little bit to digest then I will let you know.

 

You had a couple follow on questions in your response, I will try to answer those:

 

"Do you want to update the consolidated spreadsheet with date from a spreadsheet in a specific folder in OneDrive for Business?" - wouldn't be just dates, would be all sorts of data across multiple tabs.

 

Specific folders and specific files... the consolidated file would always stay the same name since Tableau is assigned to it as a data source.  The input files from the PMs I think would change names but I could ask them not to and just always use the same names.

 

Thanks,

Terry

 

 

Administrator
Administrator

Re: Comparing Excel Files

Hello, @Mattw112IG!

 

Have you had a chance to apply @v-yuazh-msft ‘s recommendation to adapt your Flow? If yes, and you find that solution to be satisfactory, please go ahead and click “Accept as Solution” so that this thread will be marked for other users to easily identify!

 

 

Thank you for being an active member of the Flow Community!

 

-Gabriel

Flow Community Manager

-Gabriel
Microsoft Power Automate Community Manager
Are YOU a member of your local Power Automate User Group?
Fill out This Form to claim your Community User Group Member Badge!
Highlighted
Mattw112IG
Level 8

Re: Comparing Excel Files

I haven't yet, but will try to get to it today.

Thanks,

Terry

clydec3
Level: Power Up

Re: Comparing Excel Files

I have a somewhat similar use case, and it's really disappointing that there is no way to dynamically load the latest Excel file in a library, for example.  I can imagine use cases based on a constantly-updating workbook, but it's very limiting to hardcode the filename!  I currently have 100+ Nintex workflows in SharePoint 2013, and I would like to use Flow as an alternative going forward, but at this point I keep running into limitations that quickly turn into roadblocks.   

Helpful resources

Announcements
thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

firstImage

Incoming: New and improved badges!

We've given our badges an overhaul and also added some brand new ones!

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Power Automate Community Video Gallery!

Top Kudoed Authors
Users Online
Currently online: 128 members 5,311 guests
Please welcome our newest community members: