Power Platform Community Forum Thread Details

Good day,

I'd like to ask how would you map the image saved in a document/sharepoint list to image column in another sharepoint list.

So the scenario is a user would upload an image and would set the image name. What I want is create this same image or map it to another sharepoint list based on the name of the image. For example, I uploaded an image named GL Detail - Bal Sht Accts in a sharepoint list called Images. Now, I want it to be saved in a sharepoint list called Master Catalog, specifically in Preview Column where it should map the name of the image to the Report Name column.

This is the sharepoint list Images

This is the Master Catalog

Categories:

Power Automate

Hello, to achieve this in SharePoint, you can use Power Automate (formerly known as Microsoft Flow) to automate the process of copying or mapping the image from one list to another based on the image name. Here's a high-level overview of how you can implement this:

1. **Trigger:** Set up a trigger in Power Automate to start the flow when a new item is added or modified in the "Images" SharePoint list.

2. **Get Image Information:** Use the "Get file metadata" action to retrieve the metadata of the uploaded image from the "Images" list. This will include the file name and other relevant details.

3. **Find Corresponding Item:** Add an action to query the "Master Catalog" SharePoint list to find the item where the "Report Name" column matches the file name of the uploaded image.

4. **Copy or Map Image:** If a corresponding item is found in the "Master Catalog" list, use the "Update item" action to set the "Preview Column" of that item to the URL of the uploaded image. If no corresponding item is found, you can choose to create a new item in the "Master Catalog" list with the "Report Name" set to the file name of the image and the "Preview Column" set to the image URL.

5. **Error Handling:** Implement error handling and logging mechanisms to capture any issues that may arise during the flow execution.

6. **Test and Deployment:** Test the flow thoroughly with various scenarios to ensure it functions as expected. Once tested successfully, deploy the flow to your production environment.

By following these steps, you can automate the process of mapping the image from one SharePoint list to another based on the image name using Power Automate.

I hope this Helps
——————————————————————

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.