Power Automate - get link to a file I created

(0) Share

Report

Posted on by glitter1234567

125

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 (5)

All responses (6)

Answers (1)

CU-18081211-6 9,270 Moderator on at

Like (0)

Report

@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 125 on at

Like (0)

Report

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 on at

Like (0)

Report
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
@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 125 on at

Like (0)

Report

Thanks so much - I got this working 🙂

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

Like (0)

Report

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