Copy the contents of a list to a folder just created from a response in Forms

[Ingella]

Feels like I'm so close.....

What I have now that works in Power Automate:

1. A response comes from Forms
2. A folder is created in a SharePoint list that is named after fields from the Form
3. All lines are then copied over from another list to the location where the new folder is located

Problem:

Everything copied is placed at the same level as the folder I just created. Want to get all the lines into the new folder but can't get it to work.

Anyone kind enough to help?

[Heartholme]

Hi @Ingella, 

This worked for me (you can download the picture for better resolution): 

Here's the body of my HTTP request: 

{
"listItemCreateInfo": {
"FolderPath": {
"DecodedUrl": "@{variables('SubFolderUrl')}"
},
"UnderlyingObjectType": 0
},
"formValues": [
{
"FieldName": "Title",
"FieldValue": "@{items('Apply_to_each')?['Title']}"
},
{
"FieldName": "Antall",
"FieldValue": "@{items('Apply_to_each')?['Antall']}"
}
],
"bNewDocumentUpdate": false
}

It looks a bit much at first, but it's actually quite easy to setup. Look at this post from @Expiscornovus where he goes into the details.

https://powerusers.microsoft.com/t5/Building-Flows/Create-an-item-inside-a-folder-in-sharepoint-list...

Hopefully this helps you out!

✔ Marking my post as a solution not only confirms that your question has been answered, but also helps others find solutions to similar problems.
By doing so, you'll be making a valuable contribution to the community.

Best Regards
Heartholme

[Ingella]

@Heartholme  - you are beautiful but I think I'm to much of a beginner  😨

Just to make sure you doing the same thing as I want to, here you see my flow so far. What's left is the part that get all items from another list into that folder. 

Onboarding scenario:

1. Manager fills in a form when a new person starts, "First name" "Last name" "Starting date" - this will be the name of the folder

2. PowerAutomate creates the folder top level with name "First name + Last name + Starting date"

3. PowerAutomate goes to another list, a template with all tasks for the onboarding process -> copy all tasks into that new folder 

Is this is what you are showing me, then I will really dig into this. Thank you so much for your fast reply!!!!

[Heartholme · Accepted solution]

@Ingella , that is indeed what I'm showing you. 

So you have to do the following:

1. Create a new string variable in the start of your flow with this input (change yourtentanthere with what you blanked out): 

https://YOURTENTANTHERE.COM/sites/AXInterIT/lists/Employee  Cycle/@{outputs('Create_new_folder')?['body/{Name}']} 

2. Remove your apply to each 2, create a "Send an HTTP Request to Sharepoint". 

Fill it out like this: 

Site adress: CHOOSE YOUR SITE HERE

Method: Post

URI: _api/web/lists/GetByTitle('Employee Cycle')/AddValidateUpdateItemUsingPath

Headers: Don't add anything here

Body: 

First section: 

{
"listItemCreateInfo": {
"FolderPath": {
"DecodedUrl": "PUT IN THE VARIABLE FROM POINT 1 HERE IN DYNAMIC CONTENT"
},
"UnderlyingObjectType": 0
},
"formValues":

[
{
"FieldName": "Title",
"FieldValue": "MARK THIS SECTION AND CHOOSE 'TITLE' from get items here (THIS WILL AUTOMATICALLY PUT your post HTTP to sharepoint inside an Apply to each, which is what you want"
},
{
"FieldName": "CompletebyValue",
"FieldValue": ""
},

{
"FieldName": "StatusValue",
"FieldValue": "Ongoing"
}
]

,"bNewDocumentUpdate": false
}

####################

Between the brackets you put all the values for the columns in your new Employee list

[
{
"FieldName": "Column 1",
"FieldValue": "Dynamically click the value you want to put in there from get items"
},
{
"FieldName": "Column 2",
"FieldValue": "Dynamically click the value you want to put in there from get items"
},

{
"FieldName": "Column 3",
"FieldValue": "Dynamically"
}
]

You can add as many as you have columns, you just have to put a dot between every item, except the last one, both between each value and each item, green is where to put commas, red is where you don't have commas in a json: 

Try this out and report back to me 🙂 

[Ingella]

@Heartholme - I'm so sorry for my late reply 😣

I had a more skilled colleague of mine and thanks to your reply we manage to do this.

Super thank you!!!!!! 💖

[Heartholme]

@Ingella Glad to hear! 

No worries 🙂