cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
charafRef
Level 8

Copy files from one library to another based on a value in a column

Hello Community , 

I'm trying to build a workflow around a particular field in a SharePoint list.  I want to copy files from one library to another based on a value in a column associated with the file.

So , i created a blank template started with " When a file is created or modified (properties only) ". Then ,  I can read the value of a specific column , well ! 

However, the Create file action dosn't have the File name and the File content values. So , the flow work  in my Sharepoint Librairy he copied the item but without his extension. (a blank item with same size , same name but you can't open it). There , i add a new action "Get file Content" , to try if i can get the file content  in order to use it on my Create file.

See the picture bellow : flow1.JPG

 

flow2.JPG

 

 

 

 

I don't know if it's a Flow limit or i miss something ? 

tnx for you help ! 

12 REPLIES 12
Community Support Team
Community Support Team

Re: Copy files from one library to another based on a value in a column

Hi charafRef,

 

I can reproduce this issue on my side.

 

I will help report it and back to you once I got any updates.

 

Best regards,
Mabel Mao

Community Support Team _ Mabel Mao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Community Support Team
Community Support Team

Re: Copy files from one library to another based on a value in a column

Hi charafRef,

 

I have some updates for you.

 

When using the trigger “When a file is created(properties only)”, you need to use the action “Get file content” to get the content of the file. At here, you need to another action “Get file properties” to get the file name that contains the extension. Then in the action “Create file”, use dynamic content from the action “Get file properties” for the filed File Name.


Please take the following screenshot for a reference. I have tested it on my side, the file saved to the second library has its extension and can be opened without issue.

3.PNG


Best regards,
Mabel Mao

Community Support Team _ Mabel Mao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
charafRef
Level 8

Re: Copy files from one library to another based on a value in a column

Hi @v-yamao-msft Mabel  ,

Thank you for your replay. 

i add Get file Properities action , but the problem still remain ! On my "create file " i don't find the file name attribut of "get properties"  like you , i have only tha name value of my " When  a file is created .." & " Get file Properities" .

 

What do you think ? 

 

Best Regards ,

TNX 🙂 

 

flow3.JPG

charafRef
Level 8

Re: Copy files from one library to another based on a value in a column

So ? @v-yamao-msft

i'm waiting for your updates Thank you !

Omi
Level: Powered On

All the identical columns are not getting copied to another list using flow

I am unable to copy all the column values from one list to another sharepoint list. Few of the identical columns are gettings copied but not all.

Please suggest why this is happening

Community Support Team
Community Support Team

Re: Copy files from one library to another based on a value in a column

Hi charafRef,

 

The dynamic content is in the middle of the dynamic contents. It seems that you are trying to find it at the bottom of the dynamic contents.
3.PNG


Best regards,
Mabel Mao

Community Support Team _ Mabel Mao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Super User
Super User

Re: Copy files from one library to another based on a value in a column

I have the same problem, I don't see the filename neither. i'm pretty sure it was available in the past; It looks like we might have differents builds ?

 

Serge

charafRef
Level 8

Re: Copy files from one library to another based on a value in a column

 

Yes , maybe we have a diffrents version @sergeluca , could you tell me wich version of your SP ? 

 

Hi @v-yamao-msft , i don't see anywhere filename on my dynamic content.  Wich version of SharePoint you are using ? Server 2013 , 2016 or online. ? The second question , do you use the classic mode of SharePoint or the modern one ? 

On my case , i'm using SharePoint Online with the classic view.

 

Regards , 

 

 

Super User
Super User

Re: Copy files from one library to another based on a value in a column

I meant @v-yamao-msft has probably a different build of Flow.

I'm in west Europe, where are you chararRef?

charafRef
Level 8

Re: Copy files from one library to another based on a value in a column

i'm in north America @sergeluca , your version of SharePoint ? 

i don't think the geoghraphical zone make a sens with this issue. It's all about version or flow building of @v-yamao-msft.

Super User
Super User

Re: Copy files from one library to another based on a value in a column

I use O365. Sometimes we might have different Flows builds in different geographical regions (patching in some regions first)

charafRef
Level 8

Re: Copy files from one library to another based on a value in a column

Yes probalby you're right ! 

So , no one have a solution of this issue which seem so simple to resolve it.

Helpful resources

Announcements
thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

firstImage

Incoming: New and improved badges!

We've given our badges an overhaul and also added some brand new ones!

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Power Automate Community Video Gallery!

Top Kudoed Authors
Users Online
Currently online: 290 members 6,376 guests
Recent signins:
Please welcome our newest community members: