Answered

Change the 'Created By' field for all items in a SharePoint List

(0) Share

Report

Posted on by Laik

Hello everyone,

I have a SharePoint List with more than 1000 items and I want to copy/replace the 'Created By' field with 'Responsible Person' field, wherever 'Responsible Person' is not blank. I understand that I have to use Send an HTTP request to SharePoint, however, it shows an error 'Send_an_HTTP_request_to_SharePoint' failed'.

Thank you for your support.

Lai

Categories:

General topics

All responses (6)

Answers (2)

Sort by

royg on at

Like
a
(0)

Report
Copy link

Link copied!

Never tried it but it looks like the Header you're setting is wrong. Toggle to Text (right icon) and paste that section again.
Nived_Nambiar 18,138 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Laik

Could you share what error you are getting when using this HTTP REquest ?

Also what you are passing in the email variable ?

Thanks & Regards,
Nived N 🚀

LinkedIn: Nived N's LinkedIn
YouTube: Nived N's YouTube Channel

🔍 Found my answer helpful? Please consider marking it as the solution!
Your appreciation keeps me motivated. Thank you! 🙌
Laik on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks Nived for your reply.
The error is "Send_an_HTTP_request_to_SharePoint' failed".
Secondly, I am passing the value in 'Responsible Person' (a person or group field in SharePoint) to a variable defined aa Tawasul email.
Nived_Nambiar 18,138 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Laik

Ok, may be passing Responsible type to the variable would be wrong, if i am right, that api expects the email id of person- you have to pass the email id not person type

Thanks & Regards,
Nived N 🚀

LinkedIn: Nived N's LinkedIn
YouTube: Nived N's YouTube Channel

🔍 Found my answer helpful? Please consider marking it as the solution!
Your appreciation keeps me motivated. Thank you! 🙌
Verified answer

Laik on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Nived,
I also tried to pass the email id from the person type field i.e. Responsible, but I am still getting that error, copied below:
{
    "statusCode": 404,
    "headers": {
        "Cache-Control": "no-store, no-cache",
        "Pragma": "no-cache",
        "Set-Cookie": "ARRAffinity=0ba5f194be62197898c0733a8e9f81a2838fdd0f680b84e868ccf93e54b4fa64;Path=/;HttpOnly;Secure;Domain=sharepointonline-ne.azconn-ne-003.p.azurewebsites.net,ARRAffinitySameSite=0ba5f194be62197898c0733a8e9f81a2838fdd0f680b84e868ccf93e54b4fa64;Path=/;HttpOnly;SameSite=None;Secure;Domain=sharepointonline-ne.azconn-ne-003.p.azurewebsites.net",
        "Strict-Transport-Security": "max-age=31536000; includeSubDomains",
        "x-ms-request-id": "0ffc0ca1-4055-8000-25e9-dcb5d39fc6ab",
        "X-Content-Type-Options": "nosniff",
        "X-Frame-Options": "DENY",
        "Timing-Allow-Origin": "*",
        "x-ms-apihub-cached-response": "true",
        "x-ms-apihub-obo": "false",
        "Date": "Sun, 18 Feb 2024 18:56:56 GMT",
        "Content-Length": "460",
        "Content-Type": "application/json",
        "Expires": "-1"
    },
    "body": {
        "status": 404,
        "message": "Cannot find resource for the request ValidateUpdateListItem.\r\nclientRequestId: a30c45b8-a5d5-43df-9086-e731a8b7ac42\r\nserviceRequestId: 0ffc0ca1-4055-8000-25e9-dcb5d39fc6ab",
        "source": "xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx/_api/web/lists/GetByTitle('ECL%20test')/items/ValidateUpdateListItem",
        "errors": [
            "-1",
            "Microsoft.SharePoint.Client.ResourceNotFoundException"
        ]
    }
}
Any thoughts on the error?
Kind regards.
Laik
Verified answer

Laik on at

Like
a
(0)

Report
Copy link

Link copied!

I realized that I was not passing the ID, and I must mention here, For All items to be updated in a SharePoint List, we must use the following Uri:

_api/web/lists/GetByTitle('ECL test')/items(@{items('Apply_to_each')?['ID']})/ValidateUpdateListItem