Save List Data to Another List as an Attachment Using Power Automate

Introduction

Power Automate is a tool that helps you automate tasks and processes. One common task is moving data from one SharePoint list (List A) to another (List B) as an attachment. This is useful for saving a backup, keeping records in an organized way, or gathering data from multiple places.

With Power Automate, you can easily set up a flow that takes data from List A, turns it into a file, and attaches it to a new item in List B, saving time and effort.

Here are the steps.

Step 1. Create List A with Name, Department fields, and some data.

Step 2. Create a blank List B.

Step 3. Now we will create a Power Automate flow with 'Manually trigger'.

Step 4. Add the 'Get Items' action.

Step 5. Add the 'Create Csv' action as per the below image and add From value as @{outputs('Get_items')?['body/value']}

Step 6. Add the 'Create Item' action and insert the site and List B to it.

I have added Title as Item_utcNow() so that we can have a Unique value in the Title fields.

Step 7. Add the 'Add Attachment' action to add the file content as a file attachment in List B. Add the file name and content as you wish, which we get from the output from Step 5.

Step 8. Now, run the flow manually. After a successful flow run, let's check in List B. A List Item should be created with an attachment.

If we open the item, we will see the attachment file that we have created with the Power Automate workflow.

Conclusion

Using Power Automate, you can easily move data from one SharePoint list to another as an attachment. This process helps you automate the task of saving and organizing data, saving time, and reducing manual effort. Once set up, the flow will automatically create and attach files whenever items are added or updated in the first list, keeping everything in order without you having to do it manually.