How to check if filename excist in folder and move to different

(0) Share

Report

Posted on by EmilieNybo1

Hello,

I want to make a flow, that says:

"If i move a file to a folder, and there already is a file containing part of the name, move the old file to a different folder"

But i am having trouble with doing the containing. All the files is named by their name + det approval request date, and therefore it should only be the documentname (and not the date) that is identical.

I have tried some different things, also considered to make a seperate flow, but it does not seem to work for me

Is anyone having some ideas of how i should build this?

Thank you in advance!

Emilie

Categories:

Building flows

I have the same question (0)

All responses (5)

Answers (0)

grantjenkins 11,063 Moderator on at

Like (0)

Report
You can try the following Filter Query:

For Starts with:

startswith(Column, 'value') Example: startswith(FileLeafRef, 'ABC123')

For Contains:

substringof('value', Column) Example: substringof('ABC', FileLeafRef)

Was this reply helpful? Yes No
EmilieNybo1 75 on at

Like (0)

Report

Thank you for your answer @grantjenkins

I tried to put in:
substringof(outputs('Hent_filmetadata')?['body/Name'], FileLeafRef)
but it says it is invalid, i need the name to be dynamic, therefore the text as "value" 🙂

Do you know if i should do anything specific, when i want the experession to be dynamic?

Was this reply helpful? Yes No
grantjenkins 11,063 Moderator on at

Like (0)

Report

You need to include your dynamic text inside quotes in the Filter Query. Something like the following.

However, I'm not sure if substringof will work in you case after looking at it more closely at it will see if your FileLeafRef contains your dynamic expression value. But you want it the other way around.

Another option is to return all files initially, then use a Filter array which has a Contains option.

Was this reply helpful? Yes No
EmilieNybo1 75 on at

Like (0)

Report

Thank you! I am still very new to Power Automate, so i am trying to learn the different expressions.

Unfortunatly subspringof does not return my desired output, nor does
Which is what i assume you mean by "Return all files initially" ?

Best Regards,
Emilie

Was this reply helpful? Yes No
grantjenkins 11,063 Moderator on at

Like (0)

Report

Sorry for the late reply. You can return all files using Get files, then use a Filter array using the contains option as shown below:

Was this reply helpful? Yes No