Forum Discussion

Copper Contributor

Jun 08, 2020

Link to file

Hi, I hope I am in the right forum, I have created an automation to create a file in sharepoint when a new item is created in a sharepoint list However after this, I want to have a link creat...

Microsoft Flow

sharepoint

Vikram_Samal

MCT

Jun 08, 2020

ShayneTSGTried to replicate your use case and it seems to work for me: I am populating the URL in 2 columns in one as a string and other in hyperlink

Then the following is the flow structure:

I have declared a variable and set the value by concatenating the Folder site URL + FullPath. One tthing read the Full Path from Create New Folder Action

The formula is

concat('https://yourtenant.sharepoint.com/sites/SiteName/',body('Create_new_folder')?['{FullPath}'])

Then once you have the full path set it in your list item. This is the flow structure you need to follow:

Thanks,
Vik
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

ShayneTSG

Copper Contributor

Jun 08, 2020

Vikram_Samal I have tried what you have put, thank you btw.

I have put in the below, bit I keep getting the follow error

and

{

"status": 404,

"message": "Could not find list item.\r\nclientRequestId: 0d275442-dbe7-47e4-8836-087eb334a125\r\nserviceRequestId: 0d275442-dbe7-47e4-8836-087eb334a125"

}

my concat is

concat('https://XXX.sharepoint.com/sites/Coconnect/Lists/XXX%20Information/',body('Create_new_folder')?['{https://XXX.sharepoint.com/sites/XXX/Site%20Folders/}'])

Thanks in advanced.

Vikram_Samal
MCT
Jun 08, 2020
ShayneTSGI think there is some issue with your concat formula:

It should look something like this:
concat('https://YourTenant.sharepoint.com/sites/YourSite/',body('Create_new_folder')?['{FullPath}'])

Replace the things in red only and check.

Thanks,
Vik
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.