Skip to main content

Notifications

Power Automate - General Discussion
Unanswered

How to add an item to a column of a list that does not yet exist

(0) ShareShare
ReportReport
Posted on by 449

Hello,

I want to duplicate a SharePoint list and copy all the items from a template using Power-Automate.
Here is the story:
1. I create a new list called "Project Copy" with the same columns as the template called "Project".
2. Now I want to copy items from "Project" and paste them into "Project Copy".
My problem is that I can't dynamically paste items into columns of a list that doesn't yet exist.

dkayt_0-1702567020438.png

 

Do you have any idea how to achieve this?

If I'm not being clear, please let me know.

  • dkayt Profile Picture
    dkayt 449 on at
    Re: How to add an item to a column of a list that does not yet exist

    Hi @v-yueyun-msft 

    Thanks for replying.

    But the problem is, the columns can't be loaded because the "Project Copy" will be created from another flow. That means with one Trigger, I want to create the Project Copy with columns and put the values of Project into it. Is there a way to say to a flow wait of the created flow, look at all the columns and paste all the values from the "Project"?

    Best Regards, dkayt 

  • Re: How to add an item to a column of a list that does not yet exist

    Hi , @dkayt 

    According to your description, you have created two SharePoint List , and you want to copy the items to "Project Copy" list.

    You need to select the SharePoint List in your "Create Item" action,Then it will load the column in your list:

    vyueyunmsft_0-1702604675097.png

    You can re-selected the List Name in your side , and you need to check if your Site Address has selected the right one.

    And then you can put the value in your column you want to move:

    vyueyunmsft_1-1702604745692.png

     

    Best Regards,

    Yueyun Zhang



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

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,580

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,909

Leaderboard