copy item from one list which has more number of lookup columns to another list

[Aishwarya10]

I've two lists. I've to copy list1 item to list2. Since I've some hundreds of columns in both the list, it is tedious task to limit these much columns in particular number of views in "GetItem" action.

I tried another way using "Send an HTTP Request to SharePoint" action. I am able to retrieve all the values but it would again be a tedious task to split them into individual column values.

These are the two methods that I found to retrieve values of list1 item and then thought of using "CreateItem" action to have the copy of list1 item in list2. Since this requires lot of manual work, it would be really helpful if someone suggest a better solution.

[annajhaveri]

@Aishwarya10  there isnt a direct option to copy item from one list to another, so you need to use Create Item action or Rest API using Send HTTP Request to SharePoint action. I think if you do by using Send HTTP Request to SharePoint action that would be more manageable and you can modify the json in a visual studio code or any online json editor to easily create json payload and then paste it in body parameter of the action.

[Aishwarya10]

Thanks for the solution. Instead of using "Get Item", I retrieved column values from list1 using "Send HTTP Request in SharePoint". Then I tried creating item in list2 using "Send HTTP Request in SharePoint". I'm getting an error if I attempt to create an item in list2 with values of list1 item which has null value in it. I've attached the error image below for reference. If someone can come up with solution to this, it would be really helpful.

[annajhaveri]

@Aishwarya10 Please make below changes:

1. Change odata=verbose in headers to odata=nometadata

2. Why there is no value for Number_x0020_Coln? 

3. Remote __metadata from json so the json will be as follows, replace value with dynamic content

{
"Title":"value",
"Number_x0020_Coln":value
}

[Aishwarya10]

Thanks for the suggestions. The reason why I gave null values is, both list1 and list2 have optional columns. To test such cases, I provided empty inputs. I've attached screenshot for reference. If anyone have solution to this, it would really helpful.

[annajhaveri]

@Aishwarya10  you can use following expression to provide null value for number column, null value syntax will be dependent on the type of the column.

if(empty(body('Send_an_HTTP_request_to_SharePoint')['d']['Percent']),-1,body('Send_an_HTTP_request_to_SharePoint')['d']['Percent'])

[Aishwarya10]

Thanks for the suggestion. I tried the above solution as well. Since we gave "-1" in condition, it assigns "-1" as value to the number column, which is actually a null valued field. Please find the attached image for reference. 

As I mentioned already, I've multiple lines of text ,date or time , person or group (with multiple selections and person and groups), number type columns and lookup columns. I tried giving null values for these columns too. I'm getting an error "Bad Gateway". I've attached image of that as well for reference. We find difficulty in updating null values to these columns also. If anyone can suggest solutions, it would be really helpful. 

  

[annajhaveri]

@Aishwarya10 one other way is to exclude the fields from the body parameter if those fields dont have a value to be assigned.

[Aishwarya10]

Thanks for the suggestion. We are not sure which column will have value and which column will be given as empty, because it is based on the user preference. For example: Out of 10 columns if User A is giving values to first 5 columns and User B may give values to next 5 columns. Hence, we need to copy all the 10 columns from list 1 to list2.