Unanswered

A flow to merge SharePoint items containing images as attachment, thumbnail, and picture/hyperlink

(0) Share

Report

Posted on by LisaBowen

Hi folks, creating a flow to manage images in SharePoint is giving me a headache again - I hope someone can help me out.

I finally have a SharePoint list filled with items that were created by a flow for adding thousands of images from OneDrive Business to SharePoint.

The result of the flow is that each image has its own SharePoint item that contains the image in all 3the following columns/formats
1. as an attachment
2. in Thumbnail column
3. as Picture in Hyperlink or Picture column
4. as Hyperlink in Hyperlink or Picture column

I now want to organise these images and merge most of them into single items (where the images are from the same event, for example).

I added extra columns for each image type hoping I could simply copy and paste the Thumbnail, Picture, Hyperlink, and attachments data from one item into another before deleting the original item - how wrong I was!

I am now running into trouble as I attempt to automate the process.

My idea is that each item I want to merge is given a number in a new column I've named "Merge code", then the flow is as follows:
Trigger: when I select a SharePoint item

1. Get item - for selected item (trigger)

2. Get attachment and attachment content - for selected item (trigger)

3. Get items - for items with "Merge code" column matching that of the selected item

4. Get attachment and attachment content - for items with "Merge code" column matching that of the selected item

After this I am stuck figuring out whether to create a new item to add and attach the info to, or to update the original selected item instead. -either way I'm completely lost figuring out how to add the data from up to five separate items into separate columns in a single item.

A loop maybe?

Perhaps there is another way of doing this that you could suggest?

I am inexperienced so simple step by step instructions and screenshots of each step would be very helpful!

Any advice would be greatly appreciated.

Thank you

@annajhaveri you were so helpful with my previous flow, would you have any suggestions for me here?

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (0)

Sort by

annajhaveri 8,531 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

@LisaBowen i am not sure if I understood what you are trying to do. Do you have multiple images stored in SharePoint list item attachment? Are you trying to fetch those images and create a new item from that?

Was this reply helpful? Yes No
LisaBowen 32 on at

Like (0)

Report
Copy link

Link copied!

Thanks @annajhaveri for getting back to me.
I will try to clarify what I am trying to do as simply and concisely as possible.

I have multiple images I am trying to organise

My list contains a separate item for each image

Within its list item, the image is stored/referenced in the following columns:
- Thumbnail (created by rest API using the file stored in Site Assets)
- Attachment to the item
- Picture in Hyperlink or Picture column (linking to the attachment)
- Hyperlink in Hyperlink or Picture column (linking to the attachment)

Want I want is to go through the list and manually select items/images to be grouped together in a new item, up to six images at a time.

I want to create a flow to automate the process of getting the thumbnails, attachments and links from the selected items, then adding them all to a new item.

I have tried many different things and I have succeeded in moving the thumbnail content only - I cannot get the attachments to work properly.

I appreciate any advice you have.

I can screenshot my failed attempts if that's helpful but each flow is so long and full of errors I think it might be simpler to start again from scratch using a new method.

Thank you

Was this reply helpful? Yes No