Forum Discussion

ShayneTSG's avatar
ShayneTSG
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 created to this new folder in a defined column. I've looked and hunted high and low and can't seem to find an option.

 

Any help would be great.

 

Thanks in advance  

Microsoft Flow
sharepoint

6 Replies

Sort By
  • Vikram_Samal's avatar
    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's avatar
      ShayneTSG
      Copper Contributor
      Jun 08, 2020

      Vikram_Samal 

      I have changed my string to

      concat('https://XXX.sharepoint.com/sites/XXX/',body('Create_new_folder')?['{FullPath}'])
       
      My update item is as below
       
       
      However I am now getting this
      • ShayneTSG's avatar
        ShayneTSG
        Copper Contributor
        Jun 09, 2020

        Vikram_Samal 

         

        I have managed to get the concat to work, and it completes when tested. However it is filling the information into another record within the list instead of the one I am creating. Any advice?

         

        Thanks in advance

         

    • ShayneTSG's avatar
      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's avatar
        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.

Resources