Answered

Corrupt attachments uploading to a SharePoint list

(0) Share

Report

Posted on by hhuynhfm

Hello,

In my flow, I create an item in a second sharepoint list using information and attachments from an item in a first sharepoint list. Here is my flow:

I get these errors when I attempt to open any form of attachments for an item in the second sharepoint list where I am creating the new item. I am able to view the attachments with no problem from the first sharepoint list.

Screenshot 2024-05-08 145401.png Screenshot 2024-05-08 145740.png

I have seem some posts regarding this same issue but after trying to attach something to an email which is not my case. Could it be an issue with Get attachment content?

Categories:

Building flows

I have the same question (0)

All responses (9)

Answers (1)

creativeopinion 10,508 Moderator on at

Like (0)

Report
Copy link

Link copied!

@hhuynhfm You are using the wrong dynamic content here. It should be the Attachment Content dynamic content—not Id.

You might be interested in this YT Tutorial: How to Send SharePoint List Attachments 📎 via Email with Power Automate

In this Microsoft Power Automate tutorial, I’ll cover how to create a Power Automate flow to send SharePoint list attachments in an email.

This flow will check the SharePoint list to see if an item is marked as Ready to Send and has attachments. I will also cover how to combine multiple attachments to send in a single email.

IN THIS VIDEO:

✅ How to attach a single SharePoint list attachment to an email

✅ How to use the Filter Query to Filter SharePoint List Items by a Single Choice Column

✅ How to use the Filter Array action to Filter SharePoint List Items that have an Attachment

✅ How to use turn on Pagination and Set a Threshold in the Get Items action

✅ How to us the Top Count field in the Get Items action

✅ How to use the Get Attachments Action

✅ How to avoid the Apply to Each Action

✅ How to use the Get File Content Action

✅ How to Edit an Expression

✅ How to use the Compose Action

✅ How to Get Multiple SharePoint Attachments

✅ How to use the Append to Array Variable Action

Hope this helps!

If I helped you solve your problem—please mark my post as a solution ✅.
Consider giving me a 👍 if you liked my response!

👉 Level up your Power Automate skills by checking out my tutorials on YouTube
👉 Tips and Tricks on TikTok and Instagram

Was this reply helpful? Yes No
hhuynhfm on at

Like (0)

Report
Copy link

Link copied!

Hello @creativeopinion ,

Thanks for your response! Unfortunately, I do not get the dynamic content option for "Attachment content" in Add Attachments for the File Content field. What actions should I include before this to be able to select this option? Do I have to use "Has attachments" like you did in the video?

Was this reply helpful? Yes No
creativeopinion 10,508 Moderator on at

Like (0)

Report
Copy link

Link copied!

@hhuynhfm The logic of your flow is incorrect. Can you explain why you have two for each loops? The reason you don't have access to the Attachment Content dynamic content is because the Get attachment content action is in a completely different for each loop.

Was this reply helpful? Yes No
hhuynhfm on at

Like (0)

Report
Copy link

Link copied!

Hi @creativeopinion,

The "Select An Output From Previous Steps" value for the first for each loop is Body from my Get item action. The output for the second for each loop is Body from Get attachments.

When I was adding both actions, power automate automatically put my actions in a loop - specifically when I chose Id for the file identifier field for Get Attachments, and when I chose DisplayName for the file name in Add Attachment.

I assumed this was because it was getting the content and adding it to the item for each attachment from my first sharepoint list (since the user is able to attach multiple attachments). I am not able to make the output from previous steps the same value for both for each loops.

Was this reply helpful? Yes No
hhuynhfm on at

Like (0)

Report
Copy link

Link copied!

Hello @creativeopinion,

I have since put my Get attachment content and Add attachments in the same loop that pulls from Get attachments. I am now able to see the Attachment content dynamic content for Add attachments, but my attachments are still giving me the same errors when I try to open them on the item they are added to.

Was this reply helpful? Yes No
creativeopinion 10,508 Moderator on at

Like (0)

Report
Copy link

Link copied!

@hhuynhfm Please share a screenshot of your full flow in the Classic Designer (toggle off the new designer). Click on all actions to expand them and ensure you are in edit mode.

Was this reply helpful? Yes No
hhuynhfm on at

Like (0)

Report
Copy link

Link copied!

Hi @creativeopinion,

Thank you for your continued help!

Was this reply helpful? Yes No
Verified answer

creativeopinion 10,508 Moderator on at

Like (1)

Report
Copy link

Link copied!

@hhuynhfm It's important to ensure you are using the ID dynamic content from the correct action. It should be from the Get Item action.

Pay attention to the tips listed in each field. The ID field requires the Id dynamic content from the Get Item action.

Again, ensure you are selecting the correct dynamic content.

The File Identifier field is expecting the Id dynamic content from the Get attachments action.

Ensure you insert the appropriate ID dynamic content into the ID field.

You need to ensure you insert the Attachment Content dynamic content into the File Content field (as mentioned previously)

Hope this helps!

If I helped you solve your problem—please mark my post as a solution ✅.
Consider giving me a 👍 if you liked my response!

👉 Level up your Power Automate skills by checking out my tutorials on YouTube
👉 Tips and Tricks on TikTok and Instagram

Was this reply helpful? Yes No
hhuynhfm on at

Like (0)

Report
Copy link

Link copied!

Thank you for your help!

Was this reply helpful? Yes No