Save Microsoft Lists Item Attachments to SharePoint Document Library
Vložit
- čas přidán 27. 08. 2024
- in this demo you will learn how to save Microsoft Lists attachments to SharePoint document library using the power of power automate flows. This power automate will navigate through all list items in a Microsoft List and extract all the attachments and save them to s SharePoint document library.
Website: www.keapoint.com/
Follow us on Twitter: / kea_point
Like our Facebook page: / keapointuk
Follow our company page on Linkedin: / 18782324
WHOW! ABSOLUTELY AMAZING!!!
This is the best STEP by STEP of EXACTLY how to export attachments from a SharePoint Online LIST.
Thanks for taking the time to record and share this.
Thank you John!
Cheers for this. Helped a lot.
You are welcome!
EXACTLY what I needed! Thank you for being clear and to the point!
Glad it was helpful Caroline!
This video is great I love when you explain what happens when you add a step thank you
Glad it was helpful!
This was perfect, thank you!
You're so welcome!
So simple and so powerful! thanks for sharing, really useful to get hundreds of files attached in one shot
You are welcome!
This is pure gold my brother ...this is exactly what I was looking for .
Thank you very much 👍
No problem 👍
@@KeaPointTechTips I want to extract for just when new item is saved
i have changed the Manual Trigger to "When a new item is added" however, should i remove the loop as i dont want it to go through all the items just the new item saved ?
The loop is there because you could have multiple attachments with one record. Hence this solution will process all the attachments for a specific record to Document library.
Extremely useful! Gold!
Glad it was helpful!
Bhai JazakAllah Khair for the video. I got what I want.
Thank you.
great video, love your content keep them coming
Thanks, will do!
Big thanks. This was perfect.
You're welcome!
This was so helpful! Straight to the point. Do you know how I can add the list column info as file metadata in the library? Thank you!
Use update file (Properties only) action in power automate.
hi, how about the other way to copy files/attachment from Sharepoint Document Library to Sharepoint List?
Hi, yes possible. You can get documents from the document library and attach them to SharePoint list records using Power Automate.
Thank you! :)
You're welcome!
I demo'd this on a small scale and it works great. It there a limit on the number of records? I have to tried this on a list containing over a 300 records with attachments, and although the flow ran successfully, not all attachments have been exported..ideas?
So if we wanted to make that automatic do I just follow same steps but at the start select the automated flow option?
yes, please.
Thank you for this. Is there a way to filter and check attached documents straight from the List using JSON formatting?
If I would like another column carried over from my list to the document library in addition to the attachment how do I add that into the flow?
Create metadata column in document library and then use "update file (properties only)" action of power automate,
Great video. How can we automatically create New Folder by row ID or any other sort of ID and save all relevant documents in there?
Thanks. Follow this link to check different ways to generate the unique ID's using power automate flow.
Great video. Thank you. Would it be possible to create a folder for each list record under the Expenses Doc Library and in them add the attachments?
Yes, you can. Create an additional column in the document library to store list record id so you know which document belongs to which list records.
@@KeaPointTechTips Great idea. And directly through power automate when creating the file under Folder Path/ use an identifier from the GetAttachment process?
Is it possible to group attachments by list item, like in subfolders in the library?
yes, you can save attachments to a folder and add a link to the list
If i add a new attachment and lets say there is already 3 docs attached to my item on my list, it will copy all 4 documents. I dont want that. I only want the new doc that i just attached. I dont want the loop
You can try to compare current version of the item with previous version using power automate and only process the documents which are new. I have not tried it, but it is possible.
nice video but i want exact opposite of this from document library to sharepoint list attachment column, plz suggest
Hi How can we add a validation condition to check if file already exists in document we need to replace it or else we need to create a new file in document library this is some kind of validation i need can please make a video on this?
You can query SharePoint library via flow Using filter query on name column to determine if the same file name already exist, if does, get the id and update it otherwise create a new one. Or simply choose replace option if already exists when adding a create file action.
I have a column that lists the name of the attachment. When I export the data to Excel, the column just shows "Attachments" instead of the actual file name. Because it's a hyperlink to the document, it is considering it an image. I just want a column with the name of the attachment. Any thoughts?
Just create a text column in list and update it with attachment name using same power automate flow.
Hi, great video! I'm wondering if you can help? I have over 1000 items in Microsoft lists, each list requires a document attaching to it based on the document title. How can I do this in a fast way? Thanks
Upload all documents to a SharePoint document library. Write a simple power automate flow to fetch all document from library and attach it to the list if document title and list title matches. Hope this helps you.
@@KeaPointTechTips thank you so much for replying!
I'm going to give this a go later and feedback! 😀
In my original message I meant to write 'each item' requires a document attaching to it. That shouldn't make a difference in terms of the approach you have given me should it?
Hi Friend,
It's possible to add an attachment to an specific item in microsoft list using power automate?
Example:
My microsoft lists contains two rows
Row | Description | attach
1 Item 1 Item 1.pdf
2 Item 2
So I put in a folder a PDF file called "Item 1"
What I wanted is that in power automate, when a file is copied in the folder, power automate identifies the name of the file called "Item 1" and attaches the PDF into the microsoft list item in it's respective item automatically.
It's possible?
Yes, it is possible.
@@KeaPointTechTips Do a vídeo about that. (hehehe) just kidding
That's very helpful, but I have one query, how we can store each attachment under the folder name of the list items so all the attachments for the particular list items stored in respected folder.
first create a folder with same id as list using power automate, and then save attachments there
@@KeaPointTechTips shukran
how can i add the link of the file created back to the sharepoint list?
Yes, you can get the file URL once it is create via flow and update it to hyperlink column of SharePoint list.
hi! amazing video! im having difficulties to do something else. I want that attachment to be moved to a created folder name of one category column of the form. Im getting error all the time! Can you please help?
Thanks Adriano, Are you creating folders as part of the flow as well? Someone else mentioned that their power automate flow can only detect the new folders in the next day or so.
@@KeaPointTechTips thanks for ur reply! I could manage to create the folder automatically with the name I wanted, but im struggling now is to send the files to that specific folder.
What error you are getting?
Great video... How do I convert list attachment to PDF after approved?
Possible but you need to sign up for Power automate premium to get this feature.
@@KeaPointTechTips Could you tell me what kind of features?
You need to use premium actions like populate word template to convert a file to pdf
@@KeaPointTechTips Thank you very much
Excelent! What if I want to create a folder for each list and in those folders get the attachments for the correspondent list? Thank you!
Yes you can write a schedule flow to navigate through multiple lists and route the attachment to teh designated folder. it is possible indeed.
@@KeaPointTechTips can you make a tutorial on how to do this please?
Hi. Thank you for creating this video as I find it very useful. I only have one concern as when I try to run and if the both Sharepoint list items has the same attachment, I got an error message, "An action failed. No dependent actions succeeded."
How do I go about this?
You can append a guid using power automate Guid() function with the file name before saving it to document library. this will guarantee unique value for each file
Very useful! But, how to manage duplicate ou files who already exist in the Document library?
You can generate a guid using power automate and append with file name to make sure that each file goes in the library have a unique name.
@@KeaPointTechTips How do you do this?
Check my video on how to generate unique ID using power automate czcams.com/video/vX8Vf06AH_o/video.html
Hi there, is there a way to copy a file from a document library and attach it to a SharePoint list item as an attachment? - Thanks!
Yes, it is possible using the power automate flow. You can loop though a library and take each file and attach it with the corresponding list record.
Nice video. I want to import multiple attachment to multiple lists from my desktop. Is it possible to do it. At present i am doing it manually
Yes, you can. But you will need to have some metadata around each attachment so it can go to the correct list.
@@KeaPointTechTips can you please make a video on it. It would help so many people in my organisation
Good video but after certain numbers it's not fetching the attachments. My flow is working fine no errors but I am able to get only 60 attachments wherein I have 500 sharepoint items but I am getting only 60 attachments in the folder
Update the "item limit" of "get items" action of flow to fetch more folders and files.
did you manage to fix it ?
@@KeaPointTechTips Thanks for the video I'm also having the same issue. Can you elaborate more on the solution ?