web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Copy attachment URL to...
Power Automate
Answered

Copy attachment URL to hyperlink/picture column in share point list

(0) ShareShare
ReportReport
Posted on by 5

I have an asset management share point list, to which items can be added via a power app. Photos of the items get uploaded to the list as attachments. I have just discovered the ability to display the attachment URLs as images within the share point list by using a ‘hyperlink/picture’ column. The share point list currently contains over 2500 items so manually porting over each attachment URL is not a viable option. Is there a way using a power automate flow to find the attachment URLs for each item, then copy that link into the corresponding ‘hyperlink/picture’ column for each item? 

Categories:
I have the same question (0)
  • Verified answer
    ManishSolanki Profile Picture
    15,091 Super User 2025 Season 2 on at

    Hi @RCAleXLR 

     

    Here is the sample flow which you can refer for performing the automation task:

    In the below example, I have taken list name as 'Test123' and hyperlink/picture column as 'hyperlinkpictureCol'

    1. Create a manual trigger flow with 'Get items' as the first step which will fetch all the list items:

    ManishSolanki_0-1687981353572.png

     

    2. Next, using 'Apply to each' action, we will iterate each list item and check if it has any attachment using 'Condition' action:

    ManishSolanki_1-1687981595407.png

     

    3. Now, inside 'Yes' add an action 'Get attachments' to fetch the attachment URL of the current iterated item:

    ManishSolanki_2-1687981701178.png

     

    4. Continue inside 'Yes' path, add another 'Apply to each' action to iterate all the attachments and within 'Apply to each 2' action using 'Send an HTTP request to SharePoint' to update the hyperlinkpictureCol of each item:

    ManishSolanki_3-1687981926793.png

    ManishSolanki_4-1687982014878.png

     

    The text used in Body of POST request is:

    {
    "formValues":[
    {
    "FieldName":"hyperlinkpictureCol",
    "FieldValue":"@{item()?['AbsoluteUri']}"
    }
    ]
    }

    Note: Please replace 'hyperlinkpictureCol' field name with the actual column name.

     

    If this helps & solves your problem, please remember to give a 👍 and accept my solution as it will help others in the future.

     

    Thanks

  • RCAleXLR Profile Picture
    5 on at

    This is exactly what I needed and functioned perfectly. Thank you!

  • SAIDO Profile Picture
    4 on at

    Nice job, thank you very much for this input !

  • Poetje_Ba Profile Picture
    10 on at

    this solution works with 1 attachment only !
    Only the last attachmentlink will be stored into the columnfield.

  • ManishSolanki Profile Picture
    15,091 Super User 2025 Season 2 on at

    Hi @Poetje_Ba 

     

    In hyperlink picture column only one link is allowed to store. Are you looking to store link of any particular attachment (lets say first in order) in that column? Or are you using multiline text for storing hyperlinks of multiple attachments? 

     

     

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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 503 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 321 Moderator

#3
abm abm Profile Picture

abm abm 237 Most Valuable Professional

Last 30 days Overall leaderboard