Forum Discussion

slocpc's avatar
slocpc
Copper Contributor
Sep 16, 2021

Microsoft Lists - How to duplicate a record?

Hi, all. I'd like to duplicate a record (or row) in Microsoft Lists. Is there a way to do this? Thanks for any help provided.
Lists
SvenSieverding's avatar
SvenSieverding
Bronze Contributor
Feb 03, 2023

slocpc 

If you have a view with all fields then you can

 

  • edit the date in grid view
  • mark the whole row you want to copy
  • press CTRL-C
  • Click on "Add a new Item"
  • press CTRL-V
  • exit grid view

Best Regards,
Sven

  • BluePetal's avatar
    BluePetal
    Copper Contributor
    Jul 04, 2024

    SvenSieverding 
    Nope, doesn't work.  Pastes the value in the last column I copied into the first column of the new row.

    Have you done this yourself?  

    • gsmith770's avatar
      gsmith770
      Copper Contributor
      Aug 22, 2024

      BluePetal 

      What is frustrating is that this USED to work or rather, used to work intermittently.

      Now it just doesn't work, period.

      • gsmith770's avatar
        gsmith770
        Copper Contributor
        Aug 22, 2024
        Ugh.
        Now it is working -- the telltale sign that you are on the right path will be that the row forms a dashed border when your Ctrl-C has taken hold.
  • Marcus_Pohl's avatar
    Marcus_Pohl
    Copper Contributor
    Mar 02, 2023

    SvenSieverding This doesn't work, it just pastes all the content into the first field.

    • ganeshsanap's avatar
      ganeshsanap
      MVP
      Mar 03, 2023

      Marcus_Pohl It is possible using edit in grid view. Follow these steps: 

      Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. If the post was useful in other ways, please consider giving it Like.

      For SharePoint/Power Platform blogs, visit: Ganesh Sanap Blogs

      • User901084052304's avatar
        User901084052304
        Copper Contributor
        Aug 22, 2025

        This method works, but only if none of the columns in the table have "require that this field contain data" selected.  If any columns require data, there will be a warning when the new row is created and you will be unable to paste the information across the row.

    • SvenSieverding's avatar
      SvenSieverding
      Bronze Contributor
      Mar 02, 2023

      Marcus_Pohl 

      You need to select the whole row, including the field with the selection circle to paste the data into



      Best Regards,
      Sven

      • Marcus_Pohl's avatar
        Marcus_Pohl
        Copper Contributor
        Mar 03, 2023
        Hi Sven - your original written instructions say to do another step "Click on "Add a new Item"" which is what was making your solution not work.

Resources