Skip to main content
Community site session details

Community site session details

Session Id : O8FzfpkPg2SgswweSiRp6h
Power Automate - Building Flows
Answered

array or string Multiple hyperlinks

Like (0) ShareShare
ReportReport
Posted on 24 Sep 2020 03:51:15 by 116

Hi,

 

I have sharepoint list with the following info Image Link 1 is a plain text multiline text and image link 2 is hyperlinks

 

IDColumn (single text)Image Link (multiline text)Image Link 2 (Hyperlink)Other

ID22

http:// rand com /image1.jpghttp:// rand com /image1.jpgrandom info1

ID22

http:// rand com /image2.jpg

http:// rand com /image2.jpg

random info2

ID22

http:// rand com /image3.jpg

http:// rand com /image3.jpgrandom info3
ID33http:// rand com /image4.jpghttp:// rand com /image4.jpgrandom info4
ID44http:// rand com /image5.jpghttp:// rand com /image5.jpgrandom info5

 

I wish to have another list that looks like the following with just one ID that concatenates the links and other info, i can figure the other column out by building a string variable etc,

 

however i cannot get the Image link 1 and 2 to work, the hyperlinks just wont copy over with an array variable?

 

IDColumn (single text)Image Link (multiline text)Image Link 2 (Hyperlink)Other
ID22http:// rand com /image1.jpg 
http:// rand com /image2.jpg
http:// rand com /image3.jpg
http:// rand com /image1.jpg 
http:// rand com /image2.jpg
http:// rand com /image3.jpg
random info1 ; random info2 ; random info3

ID33

http:// rand com /image4.jpg http:// rand com /image4.jpgrandom info 4
ID44http:// rand com /image5.jpg http:// rand com /image5.jpg random info 5

 

Could someone tell me or show me a link with the information i need to do this?

 

i cannot find anything helpful regarding multiple hyperlinks?

 

 

  • Verified answer
    v-litu-msft Profile Picture
    on 25 Sep 2020 at 03:39:27
    Re: array or string Multiple hyperlinks

    Hi @Questionasking,

     

    The native "Hyperlink or Picture" column can have only one hyperlink. For multiple, you need to use the "Multiple lines of text" column with the "Enhanced rich text" option and append changes to the existing column. Also, you could consider create a custom field type of SharePoint: Custom Field Types 

    Screenshot 2020-09-25 113403.jpg

    Insert links into the SharePoint column directly is impossible since there is such action could do it. But I think use Send HTTP request to SharePoint you could have a try. There is a blog about 5-Common-HTTP-Hacks-with-SharePoint, 

     

    and there is a method is about Edit Hyperlink Display Name at 19:10. Hope these could help you something.

     

    Best Regards,
    Community Support Team _ Lin Tu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Announcing our 2025 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for…

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Loading complete