Get SharePoint folder link when new item is created and send link to item

[Anonymous]

Hi all,

I have created a Flow when a MS Form is submitted it creates a new item in a SharePoint list. I have also created a Flow that creates a folder structure in a designated SharePoint site whenever a new item is created as well.

So essentially what I would like to do is:

When a new SharePoint item is created, create a folder in SharePoint site and GET the link of that folder and update the SharePoint list item with that link.

Does this make sense? I have tried lots of videos and articles but none of them worked - keep in mind the only thing I need help with is getting the folder link and sending that back to the relevant SharePoint item.

Thanks!

[hemrhk]

@Anonymous 

Once you created a folder it will return "LinktoItem" property. Update that property back to SharePoint list.

------------------------------------------------------------------------------------------------- 

If it solved your problem give a kudo and accept it as a solution. 

Follow and Subscribe 365 Stack for more updates. 

[Anonymous]

Thanks for responding!

I couldn't find a 'LinkToItem' property. 

I could only find a '{Link}' property, but am unsure of how to get Power Automate to grab that value and update the SharePoint list item accordingly. I have added another 'Update Item' action, but it does not give me an option for the Link in Dynamic Content.

[hemrhk · Accepted solution]

@Anonymous 

Link to item will look like below

Pass this value to "Update item" action

------------------------------------------------------------------------------------------------- 

If it solved your problem give a kudo and accept it as a solution. 

Follow and Subscribe 365 Stack for more updates. 

[Anonymous]

I get an error in the 'Update Item action' - "Invalid URL value". In SharePoint List I have set this column as a hyperlink, which I think might be causing the problem? Would I have to set the column as a text column?

For reference, this is my Flow (first time using Automate).

Form submitted, grabs details, creates a row in spreadsheet, creates SharePoint item, creates folder directory, updates Item with link to directory, uploads attachments submitted with form to item

[Anonymous]

EDIT:

I have changed the column to 'Multiple Lines of Text' and ensure to allow for HyperLinks but I get an error saying that the max characters is 255 and the hyperlink for the folder location is 259. I can't see a way to increase the limit.

[Anonymous]

EDIT:

Okay so I got it working! Thanks for the help. Is there a way to condense the Hyperlink? Otherwise it takes up a lot of space like this. Is it possible to set a custom Hyperlink text?

[Anonymous]

This link is a Link back to the SharePoint item - I need a link for the folder I created that is on a different site.

[Anonymous]

Did you ever get this resolved? I am trying to do this right now and have the exact same issue. Thanks!