Answered

How to create an .URL File in SharePoint with PowerAutomate

(1) Share

Report

Posted on by jleystral

Hi guys,

I am trying to create an .URL File (Link File) in SharePoint with Power Automate. What I want to do is getting a folder link in a previous flow step and then create an .URL File in another library to access the folder from step 1.

Has anyone an idea on how to get this done?

Thanks in advance.

Categories:

Building flows

I have the same question (0)

All responses (6)

Answers (1)

Sort by

Verified answer

abm abm 32,985 Most Valuable Professional on at

Like (2)

Report
Copy link

Link copied!

Hi

Not sure I understood your question fully. Say for example if the link is

https://mysharepointsite.com/doclib/folder1/ExampleFile.txt

If you looking to get the folder link then use the split() expression using delimiter as '/'

split('https://mysharepointsite.com/doclib/folder1/ExampleFile.txt', '/')

This will product an array of values

If you use last(split('https://mysharepointsite.com/doclib/folder1/ExampleFile.txt', '/')) you will get ExampleFile.txt

If you just the folder name then use the index.

eg:

split('https://mysharepointsite.com/doclib/folder1/ExampleFile.txt', '/')?[index]

index will be starting from 0 to n numbers depending on your folder structure.

Thanks

Was this reply helpful? Yes No
Suggested answer

Michael E. Gernaey 53,963 Moderator on at

Like (2)

Report
Copy link

Link copied!

Hi

I understand what you are asking for and abm_abm is there 99% of it.

At this point you need to use Create File, pointing it at the other SharePoint Document Library, or if you want it to be an Attachment its a little different.

But using Create File will then allow you to put the link and its necessary formatting inside the file.

Just remember if you use [InternetShortcut] starting line then your URL=the URL you received per abm's message.

Now you have your internet shortcut in the other library pointing back to this one, assuming whomever clicks it will have permission.

The other part however, is, how do you want this create by what mechanism? Is its manual? is it after something has changed etc? Whats the trigger condition to do this?

Was this reply helpful? Yes No
jleystral 97 on at

Like (0)

Report
Copy link

Link copied!

Hi guys,

Thank you so much for your fast reply.

Getting the folder path or the url is not a problem. I was wondering how to create a .URL File (hyperlink file) in a library.

For example I tried this (Action is 'Create file'):

But this isn't working. Do I need to use HTTP request?

In the end I just need a working link file like this:

Was this reply helpful? Yes No
abm abm 32,985 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi jleystral

Not sure who marked this a verified answer. The file you are trying to create via another link is that exists in another SharePoint library? Let me know. I could provide some answers for that.

Thanks

Was this reply helpful? Yes No
jleystral 97 on at

Like (0)

Report
Copy link

Link copied!

Hi abm abm,

Thanks for your reply. No the .URL File doesn't exist in another library. Otherwise I could just use the "Get file content" and create the new .URL file.

I just have an URL internet adress and need to create a .URL File in a library.

Thanks

Was this reply helpful? Yes No
jleystral 97 on at

Like (1)

Report
Copy link

Link copied!

I did the [internetshortcut] and it works perfect. Thanks guys

Was this reply helpful? Yes No