Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Automate - Building Flows
Answered

flow to create sharepoint list and then copy tasks from existing sharepoint list

(0) ShareShare
ReportReport
Posted on by 30

Hello, I have a list of 76 tasks that need assigned every time someone joins the company. We have those 76 tasks in a SharePoint List "Onboarding Template." I've created a flow that will take the new employee's name (i.e. Test McTest) and create a new SharePoint List named "Onboarding Test McTest" and then creates all the same columns needed to import the tasks from the Onboarding Template list.

 

I'm getting stuck at populating the new SharePoint List with the 76 tasks. I should be able to "Get Items" from "Onboarding Template" and then "Create Items" in "Onboarding Test McTest" but since the Test McTest List was created in the same flow, it doesn't show up as a drop down in the "Create Items" step. I can use "Onboarding [Employee's Name]" as I've been doing in other steps but the only field is "Items" instead of populating all of the fields from "Onboarding Test McTest" that I can pair up with "Onboarding Template"

 

This is what I actually see.

jacobb3_0-1662578871214.png

 

These are the options I'd like to see but don't because the SharePoint List isn't created until the flow runs:

jacobb3_1-1662579080676.png

Note: "Onboarding Another Name" would be "Onboarding Testy McTest" in my example. It's just the word "Onboarding [Employee's Full Name]."

 

Is there a way I can create a SharePoint list and then copy a SharePoint list all in the same flow?

 

  • Community Power Platform Member Profile Picture
    on at
    Re: Hi Jacobb3

    This is exactly what I would like to do and reading your post I am less experienced than you are. Would you mind terribly posting screenshots of your whole flow from start to finish? redacting sensitive names etc....? It would help me very much as I kind of understand where your at but not sure how to set the first part of the flow.... 😕 I would be MOST grateful thank you#?

  • Verified answer
    BJ-22072143-0 Profile Picture
    30 on at
    Re: flow to create sharepoint list and then copy tasks from existing sharepoint list

    Hello, thanks for your help. With your guidance I was able to identify a solution. Below is a screenshot on the final solution.

     

    jacobb3_0-1662648285319.png

     

     

  • Verified answer
    Pstork1 Profile Picture
    66,836 Most Valuable Professional on at
    Re: flow to create sharepoint list and then copy tasks from existing sharepoint list

    Here's a screenshot from a working sample I did a while ago.  Two things that are different in mine.  I'm using double quotes and you are using single quotes. I know that's what I suggested, but I think the double quotes are needed.  I would also check to make sure the list name is correct since you are building it on the fly.  An extra space in the list name will cause an issue.  But I suspect its the double quotes vs single.

    image.png

  • BJ-22072143-0 Profile Picture
    30 on at
    Re: flow to create sharepoint list and then copy tasks from existing sharepoint list

    Hi Pstork1, you made it sound like I would put the fields in the Item field? I'm getting invalid parameters as it's not a valid json. I tried a couple variations but clearly don't know what I'm doing 😥.

     

    jacobb3_0-1662581737067.png

     

    jacobb3_1-1662581812644.png

    jacobb3_2-1662581853109.png

     

  • Pstork1 Profile Picture
    66,836 Most Valuable Professional on at
    Re: flow to create sharepoint list and then copy tasks from existing sharepoint list

    Because the list is new the flow can't read the schema when you are building the flow. You can still do it, but you need to create a record with all the fields necessary in the item field that you see on the create item action.  Something like

     

    {Title: 'Title Value', Description: 'value', Fieldname: 'value', etc}

     

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

Michael Gernaey – Community Spotlight

We are honored to recognize Michael Gernaey as our June 2025 Community…

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 566 Super User 2025 Season 1

#2
David_MA Profile Picture

David_MA 516 Super User 2025 Season 1

#3
stampcoin Profile Picture

stampcoin 492