How to copy the URL enter in Microsoft Form to SharePoint List using Flow?

%3CLINGO-SUB%20id%3D%22lingo-sub-1879858%22%20slang%3D%22en-US%22%3EHow%20to%20copy%20the%20URL%20enter%20in%20Microsoft%20Form%20to%20SharePoint%20List%20using%20Flow%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1879858%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3EI%20in%20the%20middle%20of%20creating%20flow%20to%20copy%20all%20the%20data%20from%20M.%20Form%20to%20SharePoint%20using%20Flow%2C%20one%20of%20the%20field%20in%20the%20Form%20is%20to%20ask%20user%20to%20enter%20the%20URL%2C%20and%20i%20would%20like%20to%20copy%20the%20URL%20to%20the%20SharePoint%20column%20using%20Flow%2C%20but%20the%20link%20copied%20is%20non-clickable%20(text).%20Kindly%20advise%20what%20is%20the%20code%20should%20i%20use%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1879858%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EMicrosoft%20Flow%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EPowerApps%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1880007%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20copy%20the%20URL%20enter%20in%20Microsoft%20Form%20to%20SharePoint%20List%20using%20Flow%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1880007%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F866469%22%20target%3D%22_blank%22%3E%40Debbie_Wong%3C%2FA%3E%26nbsp%3Ball%20you%20need%20to%20do%20is%20to%20make%20sure%20the%20column%20in%20the%20SharePoint%20list%20is%20a%20%3CSTRONG%3Ehyperlink%3C%2FSTRONG%3E%20column%20then%20as%20long%20as%20the%20url%20is%20properly%20formatted%20in%20the%20form%20it%20will%20be%20clickable%20in%20the%20list%3A%3CBR%20%2F%3E%3CBR%20%2F%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20image-alt%3D%221-form.png%22%20style%3D%22width%3A%20726px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F233130i2819FF9E6F140DA5%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%221-form.png%22%20alt%3D%221-form.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20image-alt%3D%222-flow.png%22%20style%3D%22width%3A%20566px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F233132i4FF953B6A02F4DF0%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%222-flow.png%22%20alt%3D%222-flow.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20image-alt%3D%224-list-settings.png%22%20style%3D%22width%3A%20568px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F233133i02439F6A95DDAE62%2Fimage-dimensions%2F568x438%3Fv%3D1.0%22%20width%3D%22568%22%20height%3D%22438%22%20role%3D%22button%22%20title%3D%224-list-settings.png%22%20alt%3D%224-list-settings.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20image-alt%3D%223-list.png%22%20style%3D%22width%3A%20594px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F233131i957C8A9E87DC8320%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%223-list.png%22%20alt%3D%223-list.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERob%3CBR%20%2F%3ELos%20Gallardos%3CBR%20%2F%3E%3CFONT%20size%3D%222%22%20color%3D%22%23006400%22%3EMicrosoft%20Power%20Automate%20Community%20Super%20User%3C%2FFONT%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

Hi,

I in the middle of creating flow to copy all the data from M. Form to SharePoint using Flow, one of the field in the Form is to ask user to enter the URL, and i would like to copy the URL to the SharePoint column using Flow, but the link copied is non-clickable (text). Kindly advise what is the code should i use?

1 Reply

@Debbie_Wong all you need to do is to make sure the column in the SharePoint list is a hyperlink column then as long as the url is properly formatted in the form it will be clickable in the list:

1-form.png

 

2-flow.png

 

4-list-settings.png

 

3-list.png

 

Rob
Los Gallardos
Microsoft Power Automate Community Super User