web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate - Building Flows / Comparing File Propert...
Power Automate - Building Flows
Unanswered

Comparing File Properties in SharePoint?

(1) ShareShare
ReportReport
Posted on by Muphin 4

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?

I have the same question (0)
  • abm abm Profile Picture
    abm abm 32,585 Most Valuable Professional on at
    Re: Comparing File Properties in SharePoint?

    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

  • Muphin Profile Picture
    Muphin 4 on at
    Re: Comparing File Properties in SharePoint?

    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.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Welcome to the Power Platform Communities

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Chiara Carbone – Community Spotlight

We are honored to recognize Chiara Carbone as our Community Spotlight for November…

Congratulations to the October Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 647 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 350 Moderator

#3
developerAJ Profile Picture

developerAJ 256

Last 30 days Overall leaderboard

Featured topics

Share your ideas and struggles with building Power Automate flows!
Start and wait for an approval action

Product updates

Microsoft Power Platform Community release plans