web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Copying SharePoint Lis...
Power Automate
Unanswered

Copying SharePoint List items with attachments AND multi-select choice columns from one SharePoint List to another using a single PowerAutomate flow

(0) ShareShare
ReportReport
Posted on by 8

I would like to copy SharePoint List items with attachments AND multi-select choice columns from one SharePoint List to another using a single PowerAutomate flow. I've figured out how to perform these tasks in 2 separate flows:

 

Flow 1 [Manually Triggered Flow to Copy Items With Attachments From One SharePoint List to Another]

 

be2feae4-d634-4bac-8541-7588bb2db113.png

b5df27b4-e9bf-4022-9d84-c632ba5c0c4e.png

Flow 1 B.PNG

Flow 2 [When an Item or File is Modified to Copy Items With Multi-Select Columns From One SharePoint List to Another]

0b86aa98-92ba-4cfa-a48b-d930eaacbfe7.png

Flow 2B.PNG

I replicate the above 'Initialize Variable', 'Apply to Each' w/ 'Append to Array Variable' and 'Select' action for each multi-select choice column (4 total). Then, I have the following 'Create Archive Item' as my last action step:

 

Flow 2 D.PNG

db2d5e4e-4479-423a-96b8-df552860fc8f.png

Flow 2 F.PNG

However, when I try to combine the actions of these 2 flows into a single 'When an item or a file is modified' Flow, the flow only copies non-multi-select columns, doesn't copy the attachments, and errors at the final step 'Update Item' action step. Is there a way to successfully combine the tasks of the above flows into a single flow? *Note: I am not trying to replicate the manually triggered flow from Flow 1. I just found an example for how to accomplish my goal by using a manually triggered flow and thought that if I could get it to work in my scenario, which I did, I could possibly use the other components of that flow, along with the components of Flow 2, in a 'When an item is modified' flow instead of a manually triggered flow to accomplish my goal.

Categories:
I have the same question (0)
  • tartech2 Profile Picture
    8 on at

    Update: I've managed to build a flow, beginning with a 'When an item or file is modified' step,
    that copies multi-select choice fields and attachments from one Sharepoint List to another
    to archive data on an Archive List. However, when the flow copies and adds the data from the original list to the
    archive list, the flow is copying items that have not been modified and for each additional
    item that it copies to the new list, those items' multi-select choice fields mimic the item that was modified. (So, in addition to the item that was modified, several other items are copied along with the item that was modified and the multi-select choice field data is the same as the modified items. The rest of the data for those items not in a multi-select choice field is unique.)  I understand how to set up conditional triggers, but those don't seem to change this issue either.

    My goal is to copy items with a certain set of criteria and add each one with its unique data to the archive list when that item is modified.

    Can anyone help me figure out how to fix this issue?

     

    Here's what my flow looks like right now:


    General Overview:

    General Flow.PNG

    Specific Steps:

    Step1a.PNG

    Step2.PNG

    Step3a.PNG

    Step4a.PNG

    Step5.PNG

    Step6.PNG

    Step7.PNG

  • tartech2 Profile Picture
    8 on at

    I have been able to resolve the issue and now have a fully functioning flow.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Automate

#1
trice602 Profile Picture

trice602 398 Super User 2025 Season 2

#2
David_MA Profile Picture

David_MA 331 Super User 2025 Season 2

#3
Expiscornovus Profile Picture

Expiscornovus 203 Most Valuable Professional

Last 30 days Overall leaderboard