Power Automate - get link to a file I created

(0) Share

Report

Posted on by glitter1234567

129

Hi,

I am trying to do something that I think should be quite easy but I can't quite get it to work! I have created a flow that creates an excel file and saves it in a SharePoint location using the 'Create file' action. This is working fine. However I want to then get the full link to that file to email to my users, so they can just click on the link in the email and open the file (my users will have access to that sharepoint folder as standard). But I can't seem to get the full URL. I have tried Get file metadata but that also doesn't have the 'link to item' output.

Any ideas of what I am missing or what I can try to do this?

Thanks

Categories:

General topics

I have the same question (9)

All responses (6)

Answers (1)

Sort by

CU-18081211-6 9,270 Moderator on at

Like (0)

Report
Copy link

Link copied!

@glitter1234567 ,

Actually there is a special action for it.

Inside body of Send of Email use output link from previous action as link target.

Hope it helps !

1 people found this reply helpful.

Was this reply helpful? Yes No
glitter1234567 129 on at

Like (0)

Report
Copy link

Link copied!

thanks for you reply - sorry I should have mentioned I tried that also but got the error "Forbidden"

The 'Create sharing link for a file or folder' operation failed because sharing has been disabled on the site. To fix this error, you need to enable sharing on the SharePoint site. Check the site settings and make sure that sharing is allowed for the site. Once sharing is enabled, the operation should work successfully.

The users who will access this file are owners of the site so I shouldn't need to enable sharing of anything

Was this reply helpful? Yes No
v-yetonggu-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @glitter1234567 ,

I did a test for your reference.

In my scenario:

First, go to the original SharePoint library and check the ID of the file you want to copy.

My SharePoint List:

My Flow:

Please use the 'Get file properties' control to get file link.

Fill in the file ID in the 'Get file properties' control.

<p>This is a File Link</p> <p><a href="@{outputs('Get_file_properties_2')?['body/{Link}']}">FileLink</a></p>

My Outlook Inbox:

Best Regards,

Sunshine Gu

1 people found this reply helpful.

Was this reply helpful? Yes No
Verified answer

CU-18081211-6 9,270 Moderator on at

Like (1)

Report
Copy link

Link copied!
@glitter1234567 ,

Use a 'Get file properties' action after 'Create file' action (ID parameter from Create file outputs) and the link can be found using:

@{body('Get_file_properties')?['{Link}']}

Was this reply helpful? Yes No
glitter1234567 129 on at

Like (0)

Report
Copy link

Link copied!

Thanks so much - I got this working 🙂

Was this reply helpful? Yes No
HK-10081949-0 2 on at

Like (0)

Report
Copy link

Link copied!

Thanks for this post. Does anyone know how to get the url/link to the folder of the file created? I'm using a similar flow but to copy attachments into a generated folder inside a library list (generated by using a combination of ticket# and location ID).

Was this reply helpful? Yes No