how to send pdf file with date and time as part of its name via email in power automation?

(0) Share

Report

Posted on by Sebey

127

I am sending email notifications along with a a generated pdf.

here is the attached link in send email automation:

In sharepoint online folder it looks like this:

When I open the file in web browser from SharePoint online folder, the URL looks like this

...../IssueVoucher-2023-05-12T13_53_08.6111710Z.pdf

..../IssueVoucher-2023-05-09T14_34_08.6102965Z.pdf

So Now what I want is put UTCNOW() experession as the end of my file name and link that to email.

but when it arrives in email, it doesn't open the link because it doesn't have similar file name like this .../ IssueVoucher-2023-05-12T13_53_08.6111710Z.pdf "

here is the screen shoot of the email:

when I click the link, it doesn't open the file, because the date and time format is not equal as it is in the share-point folder.

your help is appreciated.

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (0)

Sort by

wskinnermctc 6,519 Moderator on at

Like (0)

Report
Copy link

Link copied!

You need to make a Variable and put the utcNow() in that variable as a string.

Then use the variable at the end of the file name. Use the same variable for creating the link.

This way the utcNow() expression is called only once at the time it is put into the variable. The variable string will stay the same everywhere else you use it in the flow.

I made an example putting utcNow() in a variable. Then I put some time delays to show that the variable stays the same when it is used in other steps.

Here is the example flow:

Here are the results that show the Compose steps keep the same value.
Variable Results

Another approach would be to use the "Create sharing link for a file or folder"
So after you create the file, you put the new item Id into this step and create a link to use elsewhere.

Was this reply helpful? Yes No
wskinnermctc 6,519 Moderator on at

Like (0)

Report
Copy link

Link copied!

You could also use the action "Create sharing link for a file or folder"

So after you create the file, you put the new item information into this step and create the link to use elsewhere.

Was this reply helpful? Yes No
Sebey 127 on at

Like (0)

Report
Copy link

Link copied!

method 1: the link in the sharepoint site, its format is: /IssueVoucher-2023-05-15T08_08_59.4089381Z.pdf but in the email: IssueVoucher-2023-05-15T08:09:07.1143470Z.pdf
I noticed to problem: 1) the format is not same,look the red color, 2) the file send to email and the file created in the SharePoint have different time(at least there is some minutes different, I dont know why).
method 2: I could not find the Item id row while adding create a link for file and folder share
your help is appreciated.

Was this reply helpful? Yes No