How to check the entire SharePoint site that there are no more files with the name of the selected file?

[Pavel48n0sh]

Hi! 
I've a library, where I upload a files. And I want to check are there any other files with the same name through out the SharePoint site.
After verification, I will send notifications by mail.
Please tell me how this can be done using Power Automate?
Thank you! 

[Rhiassuring]

Hi there, 

You can use the "Get All Lists and Libraries" action. 
After, you can use the "Filter Array" to bring back only Type 101 (libraries.) 

( item()?['Type'] on the left, and string(101) on the right.) 

From there, all you need to do is search your Filename (name, right? Not title? Is that what you want?) through those libraries. That looks like this. 

As soon as you put in the Get Files (Properties Only) and put the "DisplayName" into the Library from  your Filtered Array output, it will turn it into an "Apply to Each", which means it is going to run the query on every library that came back in your list.

If you want an email for each match, you would put it within your Apply to Each loop.

If you want a single email (which is the typical want!), then you will want to build a string or array variable (using the "Append to X Variable" action (X = whichever type you want), within the loop, so you can put it into your email outside of the loop.

Cheers,

Rhia