cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Muphin
Frequent Visitor

Comparing File Properties in SharePoint?

I'm looking to compare the version properties of two different files in SharePoint, with both files being in the same library. The only difference is the language contents of the files.

 

File A would be named F1_CH01_EN_NAME.

File B would be named F1_CH01_DE_NAME.

 

Issue is, I can only figure out how to manage one file per flow by triggering when File A is modified and getting the data for that File A with no way to relate to File B. 

 

Is there a way I can create a conditional statement that if the version numbers are not equal, email myself there is a difference in version numbers?

2 REPLIES 2
abm
Super User
Super User

Hi @Muphin 

 

If the all files are static then you can build an array for related files. Then once the flow is triggered then look the array to find the related file. So in your case  file F1_CH01_EN_NAME related file is  F1_CH01_DE_NAME. Once you find the related file use the Get Properties of SharePoint flow action to get version number or last modified date to determine which one is the latest modified and construct your business logic to send email notification. 

 

If the file is dynamic then you need to build the related files using string manipulation (Replace expression to change the EN to DE and so on) to construct all the related files and Get properties of the file using SharePoint flow action to compare.

 

Hope it make sense.

 

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up.

 

Thanks



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blog
Power Automate Video Tutorials
Muphin
Frequent Visitor

Hi @abm 

 

I'd like to do this dynamically and have been able to build a string using the replace expression that changes EN to DE, but I'm not sure how to use this string to reference the file. Could you clarify what you mean by "construct all the related files and Get properties of the file using SharePoint flow action to compare."? 

 

Get properties only allows me to refer to the trigger event file being modified. In other words, how do I change that allow me to dynamically refer to either file when I need it?

 

Thank you for your help.

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

New Ideas Forum MPA.jpg

A new place to submit your Ideas for Power Automate

Announcing a new way to share your feedback with the Power Automate Team.

Carousel_PP_768x460_Wave2 (1).png

2022 Release Wave 2 Plan

Power Platform release plan for the 2022 release wave 2 describes all new features releasing from October 2022 through March 2023.

MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

365 EduCon 768x460.png

Microsoft 365 EduCon

Join us for two optional days of workshops and a 3-day conference, you can choose from over 130 sessions in multiple tracks and 25 workshops.

Users online (5,482)