Saving PDF attachments with customise name to SharePoint

(0) Share

Report

Posted on by memento

How do I save a pdf attachment with generic name and save it as "attachment name_yy-mm-dd.pdf" ?

currently the file name only shows "attachment name.pdf"

This is a problem as i will receive the email daily with the same attachment name but the contents vary each day.

So if the name remains the same then the current day attachment will overwrite the previous day.

I tried checking out this Renaming a File in SharePoint Online using Flow - Power Platform Community (microsoft.com)

but doesn't work.

NOTE: I did not delete the file as I would like to see the 2 files first (ie. "attachment name.pdf" and "attachment name_yy-mm-dd.pdf") before adding the deletion action.

Anyone can provide a step-by-step guide? Thanks!

Categories:

Building flows

I have the same question (0)

All responses (16)

Answers (2)

SudeepGhatakNZ 14,394 Most Valuable Professional on at

Like (0)

Report
Re: Saving PDF attachments with customise name to SharePoint

In the file name property specify an expression like this

concat(first(split('Your Word file name goes here'),'.'),utcnow('yy-MM-dd'),'.pdf')

Was this reply helpful? Yes No
memento on at

Like (0)

Report

Re: Saving PDF attachments with customise name to SharePoint

But the expression is invalid:

Was this reply helpful? Yes No
memento on at

Like (0)

Report

Re: Saving PDF attachments with customise name to SharePoint

@v-zhos-msft can help ? This is similar to Renaming a File in SharePoint Online using Flow - Power Platform Community (microsoft.com), i tweaked accordingly (see my initial post) but doesn't work.

Was this reply helpful? Yes No
SudeepGhatakNZ 14,394 Most Valuable Professional on at

Like (0)

Report
Re: Saving PDF attachments with customise name to SharePoint

Here is the modified expression

concat(first(split(outputs('Get_file_properties')?['body/{FilenameWithExtension}'],'.')),utcnow('yy-MM-dd'),'.pdf')

Was this reply helpful? Yes No
memento on at

Like (0)

Report

Re: Saving PDF attachments with customise name to SharePoint

Hi @SudeepGhatakNZ
the expression has no error when saving, but when run the following error occured:

Error
Action 'Get_file_metadata' failed

Error Details
Route did not match
clientRequestId: 5c62c39f-50e5-464b-89ed-aa73a76dddb1
serviceRequestId: 5c62c39f-50e5-464b-89ed-aa73a76dddb1

Was this reply helpful? Yes No
SudeepGhatakNZ 14,394 Most Valuable Professional on at

Like (0)

Report

Re: Saving PDF attachments with customise name to SharePoint

You might not have set the Get file metadata action properly. Screenshot?

Was this reply helpful? Yes No
memento on at

Like (0)

Report

Re: Saving PDF attachments with customise name to SharePoint

Hi @SudeepGhatakNZ

Please see screen shot:

Was this reply helpful? Yes No
SudeepGhatakNZ 14,394 Most Valuable Professional on at

Like (0)

Report

Re: Saving PDF attachments with customise name to SharePoint

@memento File identifier accepts the File ID field. What value does items('apply_to_each') return in your case?

Was this reply helpful? Yes No
memento on at

Like (0)

Report

Re: Saving PDF attachments with customise name to SharePoint

@SudeepGhatakNZ
Which id should i choose?

Was this reply helpful? Yes No
Verified answer

SudeepGhatakNZ 14,394 Most Valuable Professional on at

Like (1)

Report

Re: Saving PDF attachments with customise name to SharePoint

@memento I think you are overcomplicating your flow. Try the attached flow and see if it fits your use case.

Createfilefromatt...

Was this reply helpful? Yes No