Update List with URL to SharePoint Folders (Multiple)

[tbrock_troc]

TLDR: our existing flow creates a SharePoint folder structure when a new item is created in a SharePoint list - is it possible to have to flow update the source list with URLs/Descriptions for the newly created folders on SharePoint?

***

We have created a flow that generates corresponding folders for each new item added to a SharePoint list - specifically an event tracker. In addition to creating the event-specific folder, the flow also adds 5 subfolders which are the same for each event. These subfolders correspond to columns on the SharePoint List.

Basically, anytime a new event (Event Name) is created, the following folder structure is created on the SharePoint:

• Events/FY23 - Event Name
  • Events/FY23 - Event Name/Event Photos-Videos
  • Events/FY23 - Event Name/Shipping-Logistics
  • Events/FY23 - Event Name/Post Event Recap
  • Events/FY23 - Event Name/Shipping-Logistics Files
  • Events/FY23 - Event Name/Team Itinerary

My flow currently achieves this.

Ideally, once these folders for a new event are created, we would also want this flow to update the SharePoint list with the URL and a Description for each of these folders in the appropriate column in the SharePoint List.

I ran across this thread, however it seems limited to updating the SharePoint list with a single newly created folder URL - https://powerusers.microsoft.com/t5/Using-Flows/Update-List-Item-Hyperlink-with-Folder-URL-and-descr...

From, what I can gather, I may need to run an HTTPS Request for each column I want updated with a folder URL but I cannot figure out how to apply the examples I've seen to my situation where the folders are "dynamically" created:

HTTPS Request Method

Post

HTTPS Request Header

{

"Content-Type": "application/json;odata=verbose",

"X-HTTP-Method": "MERGE",

"IF-MATCH": "*"

}

HTTPS Request Body

{

"__metadata": {

"type": "SP.Data.Hyperlink_x0020_TestListItem"

},

"Link": {

"Description": "Microsoft",

"Url": "https://www.microsoft.com"

}

}

How do I update the red URL portion in the HTTPS Request Body to reference the dynamic content used by the flow to generate the folders in the first place?

Here is my flow:

[tbrock_troc · Accepted solution]

Although I haven't been able to figure out how to update my SharePoint list with hyperlink text linked to the newly created folder, I was able to update the flow so that SharePoint list is updated with the URL from the newly created folders.

Essentially, I split the initialize variable into separate steps so that I can use each variable individually to update different fields with different URLs for the same SharePoint List item.

The 'Apply to Each' steps all contain a folder creation action and all but the EventParent also contain an 'Update Item' action which updates the corresponding field on the SharePoint list.

As this functionally achieves what I was looking to do - update list with link to newly created folders triggered by a new item creation - I will mark this as solved.