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]

Hi!

Oh god, I've been looking the condition wrong. I just saw the one that has the result to true. I'm really sorry for this

[v-yueyun-msft]

Hi, @mj07 

Sure! I think your flow has no problem due to you get the output in the screenshot !

Best Regards,

Yueyun Zhang

[mj07]

Hi! 

Sorry last question, how do i copy the files that I've created a substring based on its name?

For example: 

_EC meaning Employment Contract, I have to copy this file to Employment Contract folder

[v-yueyun-msft]

Hi , @mj07 

You can try to use the "Get file content" action to get the file content and then use the "create file" action to create the same file in your destination folder.

Best Regards,

Yueyun Zhang

[mj07]

Hello

Sorry i need help again, I'm trying to get files then get file content to get the pdf file but i got an error

[v-yueyun-msft]

Hi , @mj07 

I test it in my side , you can check if you put the right field in the "File Identifier"?

And this is the result , this Get FIle content can not get the folder content .

If I misunderstand what you mean, you can describe your needs and your expected outcomes in detail so that we can better help you.

Best Regards,

Yueyun Zhang

[mj07]

Hi!

Get file content now is working but i got new error in creating a file

[v-yueyun-msft]

Hi , @mj07 

The fileName need to include the corresponding suffix, like the "400830001_BC.pdf" .

You can try to use one field include the corresponding suffix to try .

Best Regards,

Yueyun Zhang

[mj07]

Hello

Sorry what do you mean one field include the corresponding suffix, do i need to create field in sharepoint?

[v-yueyun-msft]

Hi , @mj07 

 I mean you can try to use filed in the "Create file" action:

Best Regards,

Yueyun Zhang

[mj07]

Hello

I'm still getting the error message even though i edit the create file portion

[v-yueyun-msft]

Hi , @mj07 

You can try use the file content field in the create file action which works good in my side :

Best Regards,

Yueyun Zhang

[mj07]

Hello

sorry still got error 😔

[v-yueyun-msft]

Hi , @mj07 

Thanks for your quick response , can you give me the error message in your run history and what the input parameter you pass to the create file?

Best Regards,

Yueyun Zhang

[v-yueyun-msft]

Hi , @mj07 

You may try to check if the "Site Address " and the "Folder Path" is the correct value in your side ?

You can check if the folder path exist in your site ? You can see the run history to check it .

For  example like this , we need to be able to find this file in SharePoint document:

And if the flow result is fail, this is not worry , in my side my flow is fail due to it exist the folder instead of the file, but when it is a file , this flow will also work .

And you can also see if the current loop error message here:

And also you can check if the file have been created in your SharePoint document?

Best Regards,

Yueyun Zhang

[mj07]

Hi!

this is what I'm getting. 

[mj07]

My create file folder path is same as the create folder 2 path

[v-yueyun-msft]

Hi , @mj07 

As searched , you can try to disable the "Allow chunking" in create items:

And for your error code , your error code is the root folder is not exist. So i think you can first do not use the dynamic value in your "Folder Path" to test if can run, you can just create a test folder in your SharePoint to test if it can run successfully.

For the same error code , you can refer to :
Solved: Create File in SharePoint - Root Folder is not fou... - Power Platform Community (microsoft....

Best Regards,

Yueyun Zhang

[mj07]

Hello, good morning. New error now 😕

[mj07]

I have moved the file, but not inside the folder itself