Substring

[mj07]

Hi! I have a flow where I have to substring a specific data from the file name also have a master list of data the compares who employee that has this employee number. My concern is that my condition always result to false, I'm trying to equal it on the substring that I did. Your response is highly appreciated, Thank you!

[mj07]

Wrong file in wrong folder

[v-yueyun-msft]

Hi , @mj07 

You need to check the folder path in your create file action in your run historty. And what is your configuration in your folder path in your create file action ?

Best Regards,

Yueyun Zhang

[mj07]

Hi! Thanks for your response

So this is my get files properties then create file

So first column Name is from main create folder this:

And then the second Name column is from this 

Then i have the same condition above if it matches the substring then personnel number

[v-yueyun-msft]

Hi , @mj07 

Thanks for your reply, for your question, you can try to check the actual value of the Folder Path in the Run history, and see if it is caused by the value not being matched.
I'm a little unwell and may need to get back to you tomorrow.

Best Regards,

Yueyun Zhang

[mj07]

Hello, sorry to hear but the condition matched and still created the wrong file in the wrong folder

[mj07]

So this is the folder path on run history

[mj07]

Hi!

I hope all is well, sorry I may able to move the files but it keeps on moving both with the same document type. Seeking for your help please

[mj07]

Hi @v-yueyun-msft 

I hope all is well, sorry I may able to move the files but it keeps on moving both with the same document type. Seeking for your help please

[v-yueyun-msft]

Hi, @mj07 

Thanks for your response ! What do you mean " it keeps on moving both with the same document type"?

Best Regards,

Yueyun Zhang

[mj07]

Hi!

This. The same personnel number should be only move in this folder but it keeps moving the not same personnel number.

[v-yueyun-msft]

Hi , @mj07 

Can you share which the folder path you use in your move file action?

Best Regards,

Yueyun Zhang

[mj07]

Hi!

So this is my folder path in SharePoint

So in power automate this is my actions

First create folder is for Employee folder then second create new folder is for the sub folder which is Employee Contract

Then this is how i move my documents to the create employee folder

[v-yueyun-msft]

Hi , @mj07 

Thanks for your quick response !

According to your screenshot , You create the folder first, and then use create file to move your files.
So the question is, did you make a judgment when you created the folder? Do you create the folder based on the prefix of the file that is currently being read?
If you want to move to a specific folder, you'll need to read the corresponding file name before creating a folder and then moving it.
You seem to have put the folder creation step at the top?

Best Regards,

Yueyun Zhang

[mj07]

Hi @v-yueyun-msft 

can i msg you directly? 

[v-yueyun-msft]

Hi, @mj07 

Thank you for your quick reply! If you want to troubleshoot the problem remotely and quickly, you can request a support tickect in the admin center to help you solve the problem! Microsoft engineers will contact you as soon as they receive your tickect and help you solve the problem!

Help + support | Power Platform admin center (microsoft.com)

We're sorry, as a forum engineer, I can't work with you remotely to solve the problem! Thank you for your understanding and support.

Best Regards,

Yueyun Zhang

[mj07]

Hi!

So this is my whole flow right now

First I get the files to be read then the get items to my employee master list in SharePoint. Next is to substring the file name which is the 8 digit personnel number then compare it to my master list if that personnel number is existing. Then I'll use a condition to match those 2 values

Second is to create the first folder which is personnel number_personnel name then its sub folder which is Employee Contract. After that I did try to get files again which is to filter all documents types (eg. EC which is for Employee Contract) then substring again the file name that I've got then compared to my second substring contains the folder name. Then condition comparing both 

Last is to move the corresponding file that has the same personnel number and folder name and correct document type.

[mj07]

Hi!

The recurring issue is that not same personnel number is moving on the wrong personnel folder 

[v-yueyun-msft]

HI , @mj07 

What is this you put here ? you can check this in the run history if this will make the duplication?

Best Regards,

Yueyun Zhang

[mj07]

Hi!

value from Get files properties above apply to each 5

[v-yueyun-msft]

Hi, @mj07 

So you can check if this “Get files 2” return all the files in your flow run history?  This should be the file that needs to be created in the current folder.