Power Platform Community Forum Thread Details

Hi,

I used Power Automate to bulk upload thousands of records but this has resulted in several columns missing data. I wanted to the following without changing / messing up the existing data.

1. Copy values from one field to another (i.e. copying email addresses in a text column to a People column).

2. Copy values from an excel sheet into a SharePoint field without changing existing data.

How can I do this please?

Categories:

General topics

Hi @Nehal3 ,

See: 🚹SharePoint People Column : How to Update and Patch in Power Automate and Power Apps

(1) You can use a HTTP request to just update a People column without changing other values. Specify the item id in the URI, and then specify the email address as the key value as shown below. In your case the value would be the column name of the text column containing the email address:

Uri:
_api/web/lists/GetByTitle('Acronyms')/items(66)/validateUpdateListItem
 
Method: POST
 
Body:
 
{
 "formValues":[
 {
 "FieldName": "AddedBy",
 "FieldValue": "[{'Key':'AlexW@dev365.com'}]"
 }
 ]
}

(2) You can also use the HTTP request to update other columns (fields) without changing other value:

Uri:
_api/web/lists/GetByTitle('<list-name>')/items(<item-ID>)/validateUpdateListItem
 
Method: POST
 
Body:
 
{
 "formValues":[
 {
 "FieldName": "<Column-name>",
 "FieldValue": "<Column-value>"
 }
 ]
}

Example:

You should use what is called the "Internal" name of the SharePoint column (field) in the HTTP request.

See: 🔍How to Find the Internal Name of a SharePoint Column

Ellis
____________________________________
If I have answered your question, please mark the post as ☑️ Solved.
If you like my response, please give it a Thumbs Up.
My Blog Site