Power automate to copy files from one drive to different share point folders in different sites based on filename content

[RV_KONDRA]

Hi all, i am trying to build a flow to copy excel files from one drive to share point folders which are located in different share point sub sites.

I am trying to use switch function but all files are going into only one folder in a sub site that i included under default branch of switch control.

Please see below the flow.

 

Regards,

PW

[RezaDorrani]

Hi @RV_KONDRA 

The data returned is encoded.

Try the following.

The Name property from "Get file metadata" will have your file name so you can use it in Switch.

Note: the Name will also have the file extension.

--------------------------------------------------------------------------------
If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.

Thanks,
Reza Dorrani, MVP
YouTube
Twitter

[RV_KONDRA]

Hi Riza, thanks for the response. But still, it is copying all files into default branch of the switch control.

Below is how i tried in switch control.

[RezaDorrani]

@RV_KONDRA 

When the flow is running, you can check the value of the compose action.

See if that value exactly matches one of the cases that you have provided.

--------------------------------------------------------------------------------
If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.

Thanks,
Reza Dorrani, MVP
YouTube
Twitter

[RV_KONDRA]

Hi Reza, you are right the excel reports in one drive have below file names. So is it we need to get compose with current date-name of the company - report name.xlsx

[RV_KONDRA]

Hi Reza, i think it is reading the correct value. Please see below screen shot.

[RezaDorrani]

@RV_KONDRA 

That is correct, you would need an exact match

--------------------------------------------------------------------------------
If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.

Thanks,
Reza Dorrani, MVP
YouTube
Twitter

[RV_KONDRA]

Hi Reza, i got for each company 4 to five reports with different dates and report names something like below. So it we need to create 4 to 5 compose expressions?