Unanswered

Checking if a file already exist from the start of the naming

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi All,

I have created a flow that checks if a file already exist in a folder, and if so it move it and replaces it with the new file which works fine. However, rather than checking against the whole file name I would like to check if a file already exist in a folder based off the start of the naming as the first 7 character will never change i.e. ABC 227. For example :

Current file: ABC 227 02 Testing Document

New file: ABC 227 03 Testing Document

What my flow is currently doing is treating it as separate document which i can understand, but regardless of whatever the second number is i would like it to treat it as the same document and move the ABC 227 02 Testing Document document and replace it with ABC 227 03 Testing Document rather than having them together in the library.

Example of the flow:

Thank you

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (0)

eric-cheng 5,171 on at

Like (0)

Report
Copy link

Link copied!

Hi @Anonymous ,

Use substring to get the first 7 characters and match that in your condition

@substring('ABC 123 02 Testing Document', 0, 7)

Will return 'ABC 123'

You will need to add some logic to get 02 and increment by one. You could use substring again but the challenge will be if you get to three or four digits

E.g.ABC 123 200 Testing Document or ABC 123 2000 Testing Document

--------------------------------------------------------------------------
If I have answered your question, please mark my post as a solution
If you have found my response helpful, please give it a thumbs up

Connect on LinkedIn

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @eric-cheng,

Thank you for the swift reply!

Sorry i should of posted it in my original post that I have already played around with the
@substring('ABC 123 02 Testing Document', 0, 7).

I am just struggling on how to use this to carry out the check if that file already exists using the substring an using it to move the file it regardless of the second number.

Thank you

Was this reply helpful? Yes No