Link to file

%3CLINGO-SUB%20id%3D%22lingo-sub-1448677%22%20slang%3D%22en-US%22%3ELink%20to%20file%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1448677%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3EI%20hope%20I%20am%20in%20the%20right%20forum%2C%20I%20have%20created%20an%20automation%20to%20create%20a%20file%20in%20sharepoint%20when%20a%20new%20item%20is%20created%20in%20a%20sharepoint%20list%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Sharepoint.PNG%22%20style%3D%22width%3A%20631px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F197300i1B02C23EC163D2A9%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22Sharepoint.PNG%22%20alt%3D%22Sharepoint.PNG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EHowever%20after%20this%2C%20I%20want%20to%20have%20a%20link%20created%20to%20this%20new%20folder%20in%20a%20defined%20column.%20I've%20looked%20and%20hunted%20high%20and%20low%20and%20can't%20seem%20to%20find%20an%20option.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20help%20would%20be%20great.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20in%20advance%20%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1448677%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EMicrosoft%20Flow%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1449048%22%20slang%3D%22en-US%22%3ERe%3A%20Link%20to%20file%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1449048%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F692857%22%20target%3D%22_blank%22%3E%40ShayneTSG%3C%2FA%3ETried%20to%20replicate%20your%20use%20case%20and%20it%20seems%20to%20work%20for%20me%3A%26nbsp%3B%20I%20am%20populating%20the%20URL%20in%202%20columns%20in%20one%20as%20a%20string%20and%20other%20in%20hyperlink%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Vikram_Samal_0-1591637978312.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F197343i9B1E6347B2321726%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22Vikram_Samal_0-1591637978312.png%22%20alt%3D%22Vikram_Samal_0-1591637978312.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EThen%20the%20following%20is%20the%20flow%20structure%3A%3C%2FP%3E%3CP%3EI%20have%20declared%20a%20variable%20and%20set%20the%20value%20by%20concatenating%20the%20Folder%20site%20URL%20%2B%20FullPath.%20One%20tthing%20read%20the%20Full%20Path%20from%20Create%20New%20Folder%20Action%3C%2FP%3E%3CP%3EThe%20formula%20is%3C%2FP%3E%3CDIV%3E%26nbsp%3B%3C%2FDIV%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CPRE%20class%3D%22lia-code-sample%20language-applescript%22%3E%3CCODE%3Econcat('https%3A%2F%2Fyourtenant.sharepoint.com%2Fsites%2FSiteName%2F'%2Cbody('Create_new_folder')%3F%5B'%7BFullPath%7D'%5D)%3C%2FCODE%3E%3C%2FPRE%3E%3CP%3E%3CSPAN%3EThen%20once%20you%20have%20the%20full%20path%20set%20it%20in%20your%20list%20item.%20This%20is%20the%20flow%20structure%20you%20need%20to%20follow%3A%3CBR%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CDIV%3E%3CDIV%20class%3D%22mceNonEditable%20lia-copypaste-placeholder%22%3E%26nbsp%3B%3C%2FDIV%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%222020-06-08_1043.png%22%20style%3D%22width%3A%20482px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F197347i7D45F85C0BEEB46C%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%222020-06-08_1043.png%22%20alt%3D%222020-06-08_1043.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EThanks%2C%3CBR%20%2F%3EVik%3CBR%20%2F%3EIf%20this%20post%20helps%2C%20then%20%3CSTRONG%3Eplease%20consider%20Accept%20it%20as%20the%20solution%3C%2FSTRONG%3E%20to%20help%20the%20other%20members%20find%20it%20more%20quickly.%3C%2FP%3E%3C%2FDIV%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1449279%22%20slang%3D%22en-US%22%3ERe%3A%20Link%20to%20file%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1449279%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F394813%22%20target%3D%22_blank%22%3E%40Vikram_Samal%3C%2FA%3E%26nbsp%3BI%20have%20tried%20what%20you%20have%20put%2C%20thank%20you%20btw.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20put%20in%20the%20below%2C%20bit%20I%20keep%20getting%20the%20follow%20error%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22ShayneTSG_0-1591642862923.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F197382i5E8812AF23365D6E%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22ShayneTSG_0-1591642862923.png%22%20alt%3D%22ShayneTSG_0-1591642862923.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eand%26nbsp%3B%3C%2FP%3E%3CDIV%3E%3CDIV%3E%3CSPAN%3E%7B%3C%2FSPAN%3E%3C%2FDIV%3E%3CDIV%3E%3CSPAN%3E%26nbsp%3B%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%3E%22status%22%3C%2FSPAN%3E%3CSPAN%3E%3A%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%3E404%3C%2FSPAN%3E%3CSPAN%3E%2C%3C%2FSPAN%3E%3C%2FDIV%3E%3CDIV%3E%3CSPAN%3E%26nbsp%3B%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%3E%22message%22%3C%2FSPAN%3E%3CSPAN%3E%3A%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%3E%22Could%26nbsp%3Bnot%26nbsp%3Bfind%26nbsp%3Blist%26nbsp%3Bitem.%5Cr%5CnclientRequestId%3A%26nbsp%3B0d275442-dbe7-47e4-8836-087eb334a125%5Cr%5CnserviceRequestId%3A%26nbsp%3B0d275442-dbe7-47e4-8836-087eb334a125%22%3C%2FSPAN%3E%3C%2FDIV%3E%3CDIV%3E%3CSPAN%3E%7D%3C%2FSPAN%3E%3C%2FDIV%3E%3CDIV%3E%26nbsp%3B%3C%2FDIV%3E%3CDIV%3E%3CSPAN%3Emy%20concat%20is%3C%2FSPAN%3E%3C%2FDIV%3E%3CDIV%3E%26nbsp%3B%3C%2FDIV%3E%3CDIV%3E%3CDIV%3E%3CDIV%3E%3CSPAN%3Econcat(%3C%2FSPAN%3E%3CSPAN%3E'%3CA%20href%3D%22https%3A%2F%2FXXX.sharepoint.com%2Fsites%2FCoconnect%2FLists%2FXXX%2520Information%2F%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2FXXX.sharepoint.com%2Fsites%2FCoconnect%2FLists%2FXXX%2520Information%2F%3C%2FA%3E'%3C%2FSPAN%3E%3CSPAN%3E%2Cbody(%3C%2FSPAN%3E%3CSPAN%3E'Create_new_folder'%3C%2FSPAN%3E%3CSPAN%3E)%3F%5B%3C%2FSPAN%3E%3CSPAN%3E'%7B%3CA%20href%3D%22https%3A%2F%2FXXX.sharepoint.com%2Fsites%2FXXX%2FSite%2520Folders%2F%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2FXXX.sharepoint.com%2Fsites%2FXXX%2FSite%2520Folders%2F%3C%2FA%3E%7D'%3C%2FSPAN%3E%3CSPAN%3E%5D)%3C%2FSPAN%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FDIV%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20in%20advanced.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1449353%22%20slang%3D%22en-US%22%3ERe%3A%20Link%20to%20file%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1449353%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F692857%22%20target%3D%22_blank%22%3E%40ShayneTSG%3C%2FA%3EI%20think%20there%20is%20some%20issue%20with%20your%20concat%20formula%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIt%20should%20look%20something%20like%20this%3A%3C%2FP%3E%3CP%3Econcat('https%3A%2F%2F%3CFONT%20color%3D%22%23FF0000%22%3E%3CSTRONG%3EYourTenant%3C%2FSTRONG%3E%3C%2FFONT%3E.sharepoint.com%2Fsites%2F%3CFONT%20color%3D%22%23FF0000%22%3E%3CSTRONG%3EYourSite%3C%2FSTRONG%3E%3C%2FFONT%3E%2F'%2Cbody('Create_new_folder')%3F%5B'%7BFullPath%7D'%5D)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EReplace%20the%20things%20in%20red%20only%20and%20check.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%2C%3CBR%20%2F%3EVik%3CBR%20%2F%3EIf%20this%20post%20helps%2C%20then%20%3CSTRONG%3Eplease%20consider%20Accept%20it%20as%20the%20solution%3C%2FSTRONG%3E%20to%20help%20the%20other%20members%20find%20it%20more%20quickly.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1449519%22%20slang%3D%22en-US%22%3ERe%3A%20Link%20to%20file%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1449519%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F394813%22%20target%3D%22_blank%22%3E%40Vikram_Samal%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20changed%20my%20string%20to%3C%2FP%3E%3CDIV%3E%3CDIV%3E%3CSPAN%3Econcat(%3C%2FSPAN%3E%3CSPAN%3E'%3CA%20href%3D%22https%3A%2F%2FXXX.sharepoint.com%2Fsites%2FXXX%2F%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2FXXX.sharepoint.com%2Fsites%2FXXX%2F%3C%2FA%3E'%3C%2FSPAN%3E%3CSPAN%3E%2Cbody(%3C%2FSPAN%3E%3CSPAN%3E'Create_new_folder'%3C%2FSPAN%3E%3CSPAN%3E)%3F%5B%3C%2FSPAN%3E%3CSPAN%3E'%7BFullPath%7D'%3C%2FSPAN%3E%3CSPAN%3E%5D)%3C%2FSPAN%3E%3C%2FDIV%3E%3CDIV%3E%26nbsp%3B%3C%2FDIV%3E%3CDIV%3E%3CSPAN%3EMy%20update%20item%20is%20as%20below%3C%2FSPAN%3E%3C%2FDIV%3E%3CDIV%3E%3CSPAN%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Capture.PNG%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F197406iA68B2FCA74FD2F29%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22Capture.PNG%22%20alt%3D%22Capture.PNG%22%20%2F%3E%3C%2FSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FDIV%3E%3CDIV%3E%26nbsp%3B%3C%2FDIV%3E%3CDIV%3E%3CSPAN%3EHowever%20I%20am%20now%20getting%20this%3C%2FSPAN%3E%3C%2FDIV%3E%3CDIV%3E%3CSPAN%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Capture1.PNG%22%20style%3D%22width%3A%20283px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F197407i84DB6AFFFB5830A3%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22Capture1.PNG%22%20alt%3D%22Capture1.PNG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1450266%22%20slang%3D%22en-US%22%3ERe%3A%20Link%20to%20file%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1450266%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F394813%22%20target%3D%22_blank%22%3E%40Vikram_Samal%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20managed%20to%20get%20the%20concat%20to%20work%2C%20and%20it%20completes%20when%20tested.%20However%20it%20is%20filling%20the%20information%20into%20another%20record%20within%20the%20list%20instead%20of%20the%20one%20I%20am%20creating.%20Any%20advice%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20in%20advance%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1451623%22%20slang%3D%22en-US%22%3ERe%3A%20Link%20to%20file%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1451623%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F692857%22%20target%3D%22_blank%22%3E%40ShayneTSG%3C%2FA%3EI%20think%20the%20ID%20you%20are%20selecting%20to%20update%20might%20be%20the%20wrong%20ID%2C%20please%20make%20sure%20you%20select%20the%20ID%20of%20the%20SharePoint%20Item.%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Vikram_Samal_0-1591721711416.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F197644iDB330541FAC02897%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22Vikram_Samal_0-1591721711416.png%22%20alt%3D%22Vikram_Samal_0-1591721711416.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EThanks%2C%3CBR%20%2F%3EVik%3CBR%20%2F%3EIf%20this%20post%20helps%2C%20then%20%3CSTRONG%3Eplease%20consider%20Accept%20it%20as%20the%20solution%3C%2FSTRONG%3E%20to%20help%20the%20other%20members%20find%20it%20more%20quickly.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

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

Sharepoint.PNG

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  

6 Replies
Highlighted

@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

Vikram_Samal_0-1591637978312.png

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:

 

 

2020-06-08_1043.png

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

 

Highlighted

@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

 

ShayneTSG_0-1591642862923.png

 

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
 

 

Thanks in advanced.

Highlighted

@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.

Highlighted

@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
Capture.PNG 
 
However I am now getting this
Capture1.PNG
Highlighted

@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

 

Highlighted

@ShayneTSGI think the ID you are selecting to update might be the wrong ID, please make sure you select the ID of the SharePoint Item.

Vikram_Samal_0-1591721711416.png

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