Re: Copy attachment URL to hyperlink/picture column in share point list
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:
2. Next, using 'Apply to each' action, we will iterate each list item and check if it has any attachment using 'Condition' action:
3. Now, inside 'Yes' add an action 'Get attachments' to fetch the attachment URL of the current iterated item:
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:
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
