Answered

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

(0) Share

Report

Posted on by BJ-22072143-0

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.

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

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?

Categories:

Building flows

I have the same question (0)

All responses (5)

Answers (2)

Sort by

Pstork1 69,552 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!
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}

Was this reply helpful? Yes No
BJ-22072143-0 30 on at

Like
a
(0)

Report
Copy link

Link copied!

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 😥.

Was this reply helpful? Yes No
Verified answer

Pstork1 69,552 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Verified answer

BJ-22072143-0 30 on at

Like
a
(0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

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#?

Was this reply helpful? Yes No