Answered

Delete a file in a folder when a file of the same name is created in a different folder

(0) Share

Report

Posted on by M-Herz

Hi,

I have been trying to build a flow so that when a file in folder B is created, folder A is checked for a file with the same name and deletes it.

Any idea how to do it?

Regards,

Categories:

Building flows

I have the same question (0)

All responses (11)

Answers (1)

ChristianAbata 8,951 Most Valuable Professional on at

Like (1)

Report

hi @M-Herz recently delete folder scenario was solved see

https://powerusers.microsoft.com/t5/Building-Flows/delete-empty-folders-in-sharepoint-document-library/m-p/587608#U587608

shure this could help you.

Was this reply helpful? Yes No
M-Herz 21 on at

Like (0)

Report

I want to delete files such as pdf and words documents with the condition of having duplicate names, the post you referred to is about delete folder with the condition of them being empty. Sorry, but I don't see how it can help me in my issue.

Was this reply helpful? Yes No
ChristianAbata 8,951 Most Valuable Professional on at

Like (0)

Report

ohhh @M-Herz ok, mmm what you need to do is use condition action, to find a specific file name then you can delete it with the action delete file (sharepoint).

Like an action to list every file with repeating name does not exist my friend

Was this reply helpful? Yes No
M-Herz 21 on at

Like (0)

Report

I have tried the below:
1- Trigger: When a file is created in a folder.
2- Then: List Folder to get the content of the folder
3- Then: Filter Array to try reach the file I want to delete.
4- Then: Delete file

But it is not working, specifically filter array is not picking up anything.

Was this reply helpful? Yes No
ChristianAbata 8,951 Most Valuable Professional on at

Like (0)

Report

@M-Herz you file name in filter array is from the trigger when a file is created?

Because see Item is an array propertie that means you have lots of values there, so you need to compare File name with file name to get results.

Was this reply helpful? Yes No
M-Herz 21 on at

Like (0)

Report

Still didn't work, unfortunately.

Was this reply helpful? Yes No
ChristianAbata 8,951 Most Valuable Professional on at

Like (0)

Report

@M-Herz do you have now values in filter array?

Was this reply helpful? Yes No
Verified answer

v-bacao-msft on at

Like (1)

Report
Hi @M-Herz ,

Please try the following configuration and check if the body of Filter array is empty array.

@equals(toLower(item()?['DisplayName']), toLower(body('Get_file_metadata')?['DisplayName']))

Hope this helps.

Best Regards,

Was this reply helpful? Yes No
M-Herz 21 on at

Like (0)

Report

Hi,

Your solution solved the problem, and now the flow works as intended, but I don't understand why? is it because of the metadata? I appreciate if you can explain.

Again thanks a lot for the help.

Regards,

Was this reply helpful? Yes No
dmooreii 98 on at

Like (0)

Report

I am trying to accomplish same outcome but not working for me.
It is deleting all files in folder A and then gives a "file not found" error.
I just need some more info on the flow.
Get file metadata would be the path to the new file in folder B correct ?
What info is needed in List folder step ?

Was this reply helpful? Yes No