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

Community site session details

Session Id :
Power Apps - Building Power Apps
Unanswered

COPY ITEM IN ONE SHAREPOINT LIST TO ANOTHER WITH ATTACHMENT WITHOUT POWER AUTOMATE

(4) ShareShare
ReportReport
Posted on by

I want to copy an item in one sharepoint list with attachment to another without power automate

I have the same question (0)
  • indhaa Profile Picture
    on at
    Re: COPY ITEM IN ONE SHAREPOINT LIST TO ANOTHER WITH ATTACHMENT WITHOUT POWER AUTOMATE

    Hi,

     

    How about in one screen you add two Forms, Form1 and Form2 etc. You can hide the Form 2.

    In Form 2, you can make the attachment field default as the attachment datacard of Form1.

    In the submit button you can submit both Forms. 

     

     

  • Community Power Platform Member Profile Picture
    on at
    Re: COPY ITEM IN ONE SHAREPOINT LIST TO ANOTHER WITH ATTACHMENT WITHOUT POWER AUTOMATE

    Thanks @indhaa  for your response, 

     

    The item already exist in a SharePoint list, so i want to copy the selected item into the second list (both have the same column heading)

  • indhaa Profile Picture
    on at
    Re: COPY ITEM IN ONE SHAREPOINT LIST TO ANOTHER WITH ATTACHMENT WITHOUT POWER AUTOMATE

    Hi,

     

    Are you trying to update manually one record at a time via PowerApps?

  • Community Power Platform Member Profile Picture
    on at
    Re: COPY ITEM IN ONE SHAREPOINT LIST TO ANOTHER WITH ATTACHMENT WITHOUT POWER AUTOMATE

    am only working on the sharepoint, with the 2 lists.

     

    I want to copy 15 items from List A to list B (both having the same column names) without using power automate. 

     

    Note: The record exist, am not trying to add via powerapp

  • indhaa Profile Picture
    on at
    Re: COPY ITEM IN ONE SHAREPOINT LIST TO ANOTHER WITH ATTACHMENT WITHOUT POWER AUTOMATE

    Hi

     

    The  issue posted in here should relate to PowerApps.

     

    I don't know if you can update another SP list without Power Automate too, which is also another community in here.

  • HEATFreight Profile Picture
    1,024 on at
    Re: COPY ITEM IN ONE SHAREPOINT LIST TO ANOTHER WITH ATTACHMENT WITHOUT POWER AUTOMATE

    I am trying to do the same thing!

     

    WITHOUT USING FLOW (Power Automate), I want to copy the attachments from an item in a particular SharePoint list to an existing item in a totally different SharePoint list.

    I have no trouble adding and removing attachments from a SharePoint list item in my canvas app.

    The problem arises when I want to copy attachments from an item in list A to an existing item in list B. The lists are entirely different. The collection I am attempting to copy to list B is a collection of attachments filled using something like:

    Collect(colAttachments, ThisItem.Attachments)


    This method works fine if you want to collect attachments for the item in list A and show them in the form for list A, as well as to add new attachments or remove attachments from list A. If you do this same thing but instead populate a collection for the form that edits list B, you will be able to see the attachments, but you will not be able to save them to the existing list item from list B!

    You can try:

    SubmitForm(FormB)

    or you can try:

    Patch(ListB,{ID:itemID},FormB.Updates)

    but you will be unsuccessful!

    Unless I'm missing something.... What is going on here? Is this not allowed? Why is there so much basic functionality broken in PowerApps, and folks are just ok with using Power Automate as a workaround? I should not have to make a flow for everything. I have too many flows. Flows are getting out of hand. I just want PowerApps to do the thing I programmed it to do!

    The issue, it seems, is that if a collection of attachments was created from list A, then it cannot be used to save attachments to list B. That is to say, I want this to happen programmatically, but it seems it can only be done manually or with a flow. I have an existing list item with attachments in list A. I want to create a new record in list B that contains those attachments. I first create the record, then try to patch the attachments to the newly created record in list B (using the above patch code). But nothing happens.  If I want to try the SubmitForm method, then I must create the new item in list B, then set the FormB.Item parameter to a collection created from the record I just created (so that FormB knows which record it's currently pointed at). Then I should be able to run SubmitForm(FormB) and have the list item referenced by FormB.Item update with the attachments collected into the FormBAttachments_DataCard.Default parameter. But nothing happens!

  • Rusk Profile Picture
    1,369 Super User 2024 Season 1 on at
    Re: COPY ITEM IN ONE SHAREPOINT LIST TO ANOTHER WITH ATTACHMENT WITHOUT POWER AUTOMATE

    Saying "I don't want to use Power Automate, I have too many flows" is like saying "I have too many SharePoint Lists!  How can I do this without SharePoint or Excel"

     

    You can probably do it... but why? 🤣  It doesn't make sense to me.  I know that's not the answer you want but I think your ask doesn't make sense 😬

  • HEATFreight Profile Picture
    1,024 on at
    Re: COPY ITEM IN ONE SHAREPOINT LIST TO ANOTHER WITH ATTACHMENT WITHOUT POWER AUTOMATE

    I did it without using a flow...

    Figured out how to patch attachments from an item in one list to an item in a DIFFERENT list without using flow. If you need to patch attachments from an item in one SharePoint list to an item in a totally different SharePoint list, you must first remove the Attachments.Id parameter from the attachments collection!

     

    I used the following code:

    ClearCollect(colAttachments,AddColumns(DropColumns(colAttachments,"Id"),"Id",""));
    ResetForm(AttachmentsForm);
    //Alternatives to SubmitForm() commented out
    //Patch(SharePointList,LookUp(SharePointList,ID=ThisItem.ID),AttachmentsForm.Updates);
    //Patch(SharePointList,{ID:ThisItem.ID},AttachmentsForm.Updates);
    SubmitForm(AttachmentsForm);


    Why try to do PowerApps stuff directly in PowerApps instead of Power Automate?

    Because
    • It's faster
    • It's easier to write the code that will work

    • It's easier to maintain, edit, and improve the code that you write

    • It's easier to debug code running directly in the canvas app, rather than having to send some data to Power Automate, to manipulate the data in Power Automate, to then send some response back to the canvas app, and finally to figure out why it's not working at first or why it stopped working later on

    • It doesn't require any connectors (other than what's already in the app)
    • It doesn't require making a Parent flow and Child flow so the user can run the parent flow which triggers a child flow which has connectors in Maker's context (I try to avoid adding dependencies on run-only user connections, which is what would be required for this to work in a flow that runs in the user's context)

    • Did I mention it's faster? Yeah, a whole lot faster

     

    Never do in Power Automate that which can be done in a canvas app (unless you don't have a canvas app or have some valid reason for not running the code directly in the app).

    I have plenty of flows that need to be flows. I'd like to avoid superficially inflating that number because it's a form of technical debt. Figuring out how to do something directly in PowerApps is the low-code/no-code equivalent of code golfing. Power Automate is a way to cheap out on the intellectual rigor of learning PowerApps. If some code in PowerApps, like the one line I added to my solution above, gets the job done, then that's obviously preferable to adding a whole 'nother flow to my already overflowing list of flows.

    Also, it's faster.

  • HEATFreight Profile Picture
    1,024 on at
    Re: COPY ITEM IN ONE SHAREPOINT LIST TO ANOTHER WITH ATTACHMENT WITHOUT POWER AUTOMATE

    @Anonymous Let me know if I need to elaborate on my above solution!

    The reason your SharePoint list item attachments were failing to save to a list item in a different SharePoint list is probably the "Id" parameter of the attachments collection. Removing "Id" was the trick that worked for me.

    ClearCollect(colAttachments,AddColumns(DropColumns(colAttachments,"Id"),"Id",""));
  • CleanAndClear Profile Picture
    on at
    Re: COPY ITEM IN ONE SHAREPOINT LIST TO ANOTHER WITH ATTACHMENT WITHOUT POWER AUTOMATE

    Hi,

    @HEATFreightI just stumbled upon this thread while looking for a solution for the exact same case and it helped me a ton, thanks a lot!

     

    Cheers 

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Chiara Carbone – Community Spotlight

We are honored to recognize Chiara Carbone as our Community Spotlight for November…

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 766 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 419 Super User 2025 Season 2

#3
developerAJ Profile Picture

developerAJ 235

Last 30 days Overall leaderboard