Create Flow to copy link of image in document library to other SP list

(0) Share

Report

Posted on by phearin

162

Dear Team,

Could you please assist to show how can we create flow to copy link of image in document library to other SP list?

I have a document library which is store the image. and I have another SP list which contains column photo and type as URL.

Please advise.

Thanks,

Phearin

Categories:

General topics

All responses (16)

Answers (0)

Sort by

yashag2255 24,769 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @phearin

Please have a look at the flow below:

I am updating the title with the URL, you just have to put the link to item value in the URL type column of the SP list in the update/create item action.

Hope this Helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!
phearin 162 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @yashag2255 ,

Thank for quick response.
However, I have followed your suggestion, but I couldn't find my photo field listed down.
yashag2255 24,769 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @phearin

Just a quick update: Columns of type Photo will not be displayed in the Flow actions of create and update items. Please make your column of type multi lines of text or Hyperlink and then you can try adding the link over there. You can create a column of type multi lines of text and another of picture and set the picture to caluclated and the value will be of the multi line of text.

Also, the ID field points to the ID of the item in the sharepoint list (for th elist related action) and the ID of the file in the doument libraray for the file action.

Hope this helps!
phearin 162 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @yashag2255 ,

I was wondering as the column already contains that type of hyperlink or picture.
yashag2255 24,769 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@phearin

Yes! And if you check the Create Item/ Update item action in flow, you will not see a column of that data type. So you have to create the column as multiple lines of text and on more settings, you will be able to select the option of photo/url. Now on this multiple lines of text column you can add json schema (more on the schema here)

https://sharepoint.stackexchange.com/questions/255389/in-a-sharepoint-list-display-an-image-field-type-hyperlink-or-picture

Hope this Helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!
phearin 162 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @yashag2255 ,

I have changed my Photo filed to Multiple Line with URL properties. I found the Photo filed is available in the Update Item in flow. However, I still couldn't get the point of the ID field and title field.

Thanks,
Phearin
phearin 162 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @yashag2255 ,

I didn't get any further updates.

1. I have a library name: Bank Deposit

2. I have a list call TESTSP which contains photo column type Hyperlink/Picture as properties

I want to make a flow when an item is create in Bank Deposit library, then it will fectch the image link to field in photo column.

Thanks,
Phearin
yashag2255 24,769 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

HI @phearin

My Bad! I missed this somehow. So the ID fields in my flow correspond to the ID of the file and the item ID of the item list respectively.

If you can share what is the exact configuration you want to buil, I might be able to assist you better.

From the screenshots I see that the bank deposit library has the files and then you wnat to get the url on the list items. My question is do you want to create a new list item everytime a file is added in the bank deposits library?

if so, you can see the flow below:

Replace the document library pointings and replicate accordingly. This flow will trigger everytime a file is added on the library and create an item in the list with a URL of that file.

Hope this Helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!
phearin 162 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @yashag2255 ,

I am currently built an powerapps which capture image from the app and store the image file in the SP list. "This is the main reason".
However, there is no way to add image directly to SP list. Yet I found sth on web by convert image to store in library instead. I have followed some video and finally we can get image capture to store in the library as example I provided.

Still it is not sactisfy, I want to store those image to SP List. I thought only get the image link in library will help in the case.

Could you think of anything beside this?

Thanks,
Phearin
yashag2255 24,769 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @phearin

So do you want to add multiple image attachments on one item in the SP List or create an Item everytime you click a photo and add that photo as an attachment to the new item in the SP List?