Sharepoint move data in folders

SharePoint – How you can Move data from one list to another List in Folder and Subfolders?

in ,

This article will explain how to move data from one list to another list and save the data in the folders and subfolders by Power Automate Flow.

Step 1: Get Items from share point list as below:

Step 2: Initialize Variables

We should initialize the variables to help us to find the correct path of the list, folders, and subfolders.

  • Here we are initializing the variable for the list Name

  • Here we are initializing variables for subfolders assuming we have a static folder named, for example, 2022, So we should determine the subfolder dynamically as below:

  • If assuming the flow will trigger monthly on the first day of each month, for example (2022-June-1)

We should format the value of the variable as this:

* formatDateTime(addDays(utcNow(),-1,’yyyy-MM-dd’),’MMMM’)

In this format, if today 2022-June-1 will reduce the day 1 and format the date to month name to determine the folder name because we want to distribute the data per month, So the result will be (May).

  •  Here we should initialize the variable to determine the full path of the subfolder in SharePoint as below:

Put your code like this code below:

https://Contoso.com /sites/FT/lists/@{variables(‘ListName’)}/2022/@{variables(‘Month’)}

Note:

  • 2022: Consider the Folder.
  • @{variables(‘Month’): Consider the Subfolder.

Step 3: Send HTTP request to SharePoint   

You should follow the screenshot below to fill in the parameters correctly:

  • Fill the site address you want to move to.
  • Method POST.
  • Fill in the URI this code (Change the parameter based on your parameters) _api/web/lists/GetByTitle(‘@{variables(‘ListName’)}’)/AddValidateUpdateItemUsingPath .
  • Fill in the Header as the screenshot.
  • Fill in the body as below format :
{
 “listItemCreateInfo”: {
   “FolderPath”: {
     “DecodedUrl”: “@{variables(‘FolderAndSub’)}”
   },
   “UnderlyingObjectType”: 0
 }, “formValues”: [
   {
     “FieldName”: “Title”,
     “FieldValue”: “@{items(‘Apply_to_each’)?[‘Title’]}”
},
{
     “FieldName”: “Source”,
     “FieldValue”: “@{items(‘Apply_to_each’)?[‘Source/Id’]}”
},
{
     “FieldName”: “Company”,
     “FieldValue”: “@{items(‘Apply_to_each’)?[‘Company/Value’]}”
}
 ]
 ,
 “bNewDocumentUpdate”: false
}

Note: in the Field name put the name of the column (Correct Name is important as SharePoint) and in the Field value

Item value that is given from Get Items step

I found this pattern the easiest way to move the data and save the data in folders and subfolders dynamically.

Other Resources: