Auto Delete part of file name on sharepoint

(0) Share

Report

Posted on by Rob29

Hi,

I am completely new to flows and it's logic so apologies if this is a stupid question...

I have jobs automatically uploading to a sharepoint via email, however they are saved with a random number in the file name, something which I am unable to change currently, so thought flows may be able to do it for me.

Sharepoint file name number.JPG

Is there a way in which I can move the .eml files to a separate folder whilst removing the "_number" from the file name?

Categories:

Building flows

I have the same question (0)

All responses (6)

Answers (1)

abm abm 32,858 Most Valuable Professional on at

Like (0)

Report

Re: Auto Delete part of file name on sharepoint

Hi @Rob29

Are you planning to move the file to another SharePoint library folder or One Drive? Also to remove the _number is possible. There are different ways you could do this. One way is use expression split to split the filename using underscore. Then construct the filename.

If you any futher help let me know.

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up.

Thanks

Was this reply helpful? Yes No
Verified answer

v-alzhan-msft on at

Like (0)

Report
Re: Auto Delete part of file name on sharepoint

Hi @Rob29 ,

You could refer to screenshot below to create the flow to move .eml files to another folder:

If you also want to remove the "_number" from the file name of the .eml files, you could only create a new file with the new name and delete the original file, you could refer to screenshot below to create the flow:

The expression for the file name as below:
concat(first(split(items('Apply_to_each')?['{FilenameWithExtension}'],'_')),'.eml')

Please let me know if your problem could be solved.

Best regards,
Alice

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

Was this reply helpful? Yes No
Rob29 4 on at

Like (0)

Report

Re: Auto Delete part of file name on sharepoint

Hi @abm

I would like to move the file to another folder within the same SharePoint.

Are you able to share more specific instructions for the split function?

Many thanks

Was this reply helpful? Yes No
Rob29 4 on at

Like (0)

Report
Re: Auto Delete part of file name on sharepoint

Hi @v-alzhan-msft

Thanks for taking time to answer but I couldn't get the below to work. Just to be clear, should I use exactly what you showed e.g.
concat(first(split(items('Apply_to_each')?['{FilenameWithExtension}'],'_')),'.eml')
Or should I replace 'FilenameWithExtension' with the actual file name?

In terms of getting it to work, is it an issue that the files are saved in the same top level folder (different sub folders)? Do I need to differentiate at a higher level?

Many thanks

Was this reply helpful? Yes No
v-alzhan-msft on at

Like (0)

Report

Re: Auto Delete part of file name on sharepoint

Hi @Rob29 ,

Yes, please save the files in different library so the flow would easier to create and work, please take a try and let me knwo if your problem could be solved.

Best regards,
Alice

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

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

Like (0)

Report

Re: Auto Delete part of file name on sharepoint

I have this file name:

export_company_tasks_overview_20211015073353

How can I make it:

export_company_tasks_overview

Was this reply helpful? Yes No