Change/update sharepoint calculated column formula

(0) Share

Report

Posted on by josefm2

Hi,

I'm having this error when i run my flow.

Error
Action 'Send_an_HTTP_request_to_SharePoint' failed

Error Details
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN""http://www.w3.org/TR/html4/strict.dtd">
<HTML><HEAD><TITLE>Bad Request</TITLE>
<META HTTP-EQUIV="Content-Type" Content="text/html; charset=us-ascii"></HEAD>
<BODY><h2>Bad Request - Invalid Hostname</h2>
<hr><p>HTTP Error 400. The request hostname is invalid.</p>
</BODY></HTML>

clientRequestId: c2e6c93c-ca2c-43d9-b323-xxxxxxxxxx

Tried following this:

Use Power Automate to automatically update calculated column on a SharePoint List (365hq.net)

My flow:

Thanks.

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (1)

grantjenkins 11,063 Moderator on at

Like (0)

Report

It looks like you've just copied both the Uri and Body from the website you linked to, and they still contain incorrect single quotes. I'd suggest pasting them into Notepad and replacing them all.

Was this reply helpful? Yes No
josefm2 24 on at

Like (0)

Report

Hi @grantjenkins ,

I made both changes with the same error.

uri: /_api/web/lists/getbytitle('tbl_critical_alert_main')/fields/getbytitle('testToday')
body: {'__metadata':{'type':'SP.FieldCalculated'},'Formula':'Today()'}

Error:
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN""http://www.w3.org/TR/html4/strict.dtd">
<HTML><HEAD><TITLE>Bad Request</TITLE>
<META HTTP-EQUIV="Content-Type" Content="text/html; charset=us-ascii"></HEAD>
<BODY><h2>Bad Request - Invalid Hostname</h2>
<hr><p>HTTP Error 400. The request hostname is invalid.</p>
</BODY></HTML>
clientRequestId: ea34bc05-f619-4c08-87d9-

Show Raw Inputs:
{
    "host": {
        "connectionReferenceName": "shared_sharepointonline",
        "operationId": "HttpRequest"
    },
    "parameters": {
        "dataset": "https://xxxx.sharepoint.com/sites/xxxx",
        "parameters/method": "POST",
        "parameters/uri": "/_api/web/lists/getbytitle('tbl_critical_alert_main')/fields/getbytitle('testToday')",
        "parameters/headers": {
            "content-type": "application/json;odata=verbose",
            "X-HTTP-Method\t": "MERGE",
            "Accept": "application/json;odata=verbose\n"
        },
        "parameters/body": "{'__metadata':{'type':'SP.FieldCalculated'},'Formula':'Today()'}"
    }
}

Was this reply helpful? Yes No
Verified answer

grantjenkins 11,063 Moderator on at

Like (0)

Report
A few things I can see:
It looks like you've got a tab after your X-HTTP-Method. Might be worth re-typing that part out.
It looks like you've got a new line after your application/json;odata=verbose for your Accept value. Might be worth re-typing that part out too.
The formula should be '=TODAY()' - you don't have the = in yours.
Make sure you are using the Title (not the internal Name) of your List and Field.

Was this reply helpful? Yes No
josefm2 24 on at

Like (0)

Report

@grantjenkins, very much appreciated. Followed items 1 to 3. As a result of the large number of records in our SPList, updating the current date in a list would take hours.(using another scheduled flow). This just takes a click of the test button. I made two flows with distinct schedules: today and today Plus 1.

Was this reply helpful? Yes No