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 / Problem Copying One Sh...
Power Automate
Unanswered

Problem Copying One SharePoint List to Another SharePoint List including all Attachments. Flow creates multiple entries.

(0) ShareShare
ReportReport
Posted on by 64

Hi Guys, I am having a problem with my flow.

 

So I have a PowerApps Application, that Creates an entry in a SharePoint List, in what I call here, List 1. That triggers my Flow, which creates a copy of List 1, into List 2, and gets all the attachments from List 1, and copies them over to List 2. It then deletes the entry from List 1. Essentially moving the List 1 Entry to List 2. Then it sends an email from a Shared Mailbox to a designated user, and to me.

 

Originally we were just using 1 attachment, so this flow worked perfectly for that. However I have been asked to allow up to 10 attachments. Now is where we have a problem. The flow works, however instead of putting all the attachments into a single entry in the sharepoint list, it is actually is creating muliple entries into List 2, and sending multiple emails.

 

I have looked at various solutions, and tried a few things including delay, absoluteuri, etc, but so far no dice.

 

So I need; When a New Item is created in List 1, that Entry including all attachments is then created in List 2, delete the List 1 entry. So in practical terms its List 1 to List 2.

 

As a bonus; if anyone can help. I'd like to attach the attachments to the email I send. I looked into Initializing Var, and appending, but that does not seem to work with the "Send an email from a shared mailbox (V2)", but I presume I did something wrong with my array. So if you can add that to the step, it would be great. I'd imagine the attachment copy would likely be similar.

I created per this tutorial; https://flow.microsoft.com/en-us/blog/multiple-attachments-single-email/

 

This is a copy of my flow;

Microsoft Flow Error Multiple Attachments.png

Categories:
I have the same question (0)
  • v-litu-msft Profile Picture
    on at

    Hi @Phillip-JCI,

     

    1. Please move the Create item action in the middle of Get attachments and Apply to each actions:Annotation 2019-10-16 133835.png

       

    2. Send an email with attachments, you need to click the switch button (red circle), then put the attachment array into it.

      Annotation 2019-10-16 133640.png

       

      Annotation 2019-10-16 134303.png

       

    Best Regards,
    Community Support Team _ Lin Tu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • Phillip-JCI Profile Picture
    64 on at

    @v-litu-msft Thanks for the reply, I built the flow as per your instructions, however the flow failed. It ran fine until the Apply to each 2 on the Send from Shared Mailbox.

     

    Also multiple attachments still cause the issue of creating multiple entries.

     

    Flow Error Attached:

    Microsoft Flow Error 2.png

  • v-litu-msft Profile Picture
    on at

    Hi @Phillip-JCI,

     

    Could you please share the configuration of Send an email from shared mailbox?

    Best Regards,
    Community Support Team _ Lin Tu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • Phillip-JCI Profile Picture
    64 on at

    Hi @v-litu-msft, absolutely. It is attached. All the fields are from List 1. They worked fine before. Thanks!

     

    Microsoft Flow Error 3.png

  • Phillip-JCI Profile Picture
    64 on at

    @v-litu-msft, please don't forget about me!

     

    Perhaps @RezaDorrani  you can help as well? I added the flow per your recomendation on securing SharePoint Lists.

     

    Thanks!

  • v-litu-msft Profile Picture
    on at

    Hi @Phillip-JCI,

     

    Sorry for the delay, it is caused the wrong dynamic content input because of you restructured your Flow, please make sure these Dynamic content in Send email action have no parts of modified. It is better to recreate it, please make sure they correct.

    Best Regards,
    Community Support Team _ Lin Tu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • Phillip-JCI Profile Picture
    64 on at

    @v-litu-msft , I don't understand your statement, I have not made any changes to the flow. The only parts changed, were the ones you advised me to change. Can you please clarify?

  • Phillip-JCI Profile Picture
    64 on at

    @v-litu-msft please see above, still having issues.

     

    Anyone can chime in as well?

     

    Thanks!

  • Phillip-JCI Profile Picture
    64 on at

    Final Check in, before having to create a new thread.

     

    @v-litu-msft  or anyone else can help?

     

    Thanks!

  • v-litu-msft Profile Picture
    on at

    Hi @Phillip-JCI,

     

    Please delete all the content of email body, then have a test.

    1. -If it has error report, the issue will be caused by SharePoint list 1  - Please confirm the NotifyEmail column whether it exists value, if not, please add a Get item action before the send email and get the newly created item again.
    2. -If it not report issue, please check the output of Get attachments action.

    Best Regards,
    Community Support Team _ Lin Tu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

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…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 538 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 405 Moderator

#3
abm abm Profile Picture

abm abm 252 Most Valuable Professional

Last 30 days Overall leaderboard