Unanswered

Using Power Automate HTTP Request to update sharepoint list item

(1) Share

Report

Posted on by zgregory

Hi everyone,

I have a SharePoint list that logs all my open tickets. What i would like is to get the most recent comment from each item and then update the text in the SharePoint lists column. Basically showing users latest comments.

So far i can get the last comment by using the Send HTTP request "GET" function, how ever how do i add the txt value to the SharePoint list item ?

Sharepoint listHTTP to get the latest commentneed to add most recent comment to the item

Categories:

Building flows

I have the same question (0)

All responses (13)

Answers (0)

Sort by

v-yetonggu-msft Microsoft Employee on at

Like (2)

Report
Copy link

Link copied!
Hi @zgregory ,

Please add a Parse Json to parse the body of Send an HTTP request to SharePoint.

I did a test for your reference.

In my scenario:

{ "type": "object", "properties": { "d": { "type": "object", "properties": { "results": { "type": "array", "items": { "type": "object", "properties": { "__metadata": { "type": "object", "properties": { "id": { "type": "string" }, "uri": { "type": "string" }, "type": { "type": "string" } } }, "text": { "type": "string" } }, "required": [ "__metadata", "text" ] } }, "__next": { "type": "string" } } } } }

Best Regards,

Sunshine Gu

Was this reply helpful? Yes No
zgregory 21 on at

Like (1)

Report
Copy link

Link copied!

Hi @v-yetonggu-msft thank you so much for the help.

I am getting an error when im trying to run your flow:

The execution of template action 'Apply_to_each_2' failed: the result of the evaluation of 'foreach' expression '@body('Parse_JSON')?['d']?['results']' is of type 'Null'. The result must be a valid array.

Was this reply helpful? Yes No
v-yetonggu-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

Hi @zgregory ，

Please go to the running history and post a screenshot of the output of 'Send an Http Request to SharePoint'.

I want to know why your Result is empty. Is there a null value in your Comments?

Best Regards,

Sunshine Gu

Was this reply helpful? Yes No
zgregory 21 on at

Like (1)

Report
Copy link

Link copied!

Hi @v-yetonggu-msft thanks for the quick response. Just to give you understanding for what i am using the list for.
The list is basically a ticket system where users raise questions, the comments are used to note down updates on the open tickets, basically keep track of who has done what and so on.

Not all items will have a comment for example if its a new ticket and no action has yet been taken the comments would be blank. What's weird is that even if the item has a comment the result is still null

Output screen shot below for Item 47

This item has a comment:

Was this reply helpful? Yes No
v-yetonggu-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

Hi @zgregory ,

I'm guessing it's because the Schema code in your Parse Json is wrong.

Could you please copy me the full schema code in your Parse Json?

Best Regards,

Sunshine Gu

Was this reply helpful? Yes No
zgregory 21 on at

Like (1)

Report
Copy link

Link copied!
@v-yetonggu-msft please see below, i copied it from the earlier post that you have sent.

This is the schema in the failed run:

{
  "type": "object",
  "properties": {
    "d": {
      "type": "object",
      "properties": {
        "results": {
          "type": "array",
          "items": {
            "type": "object",
            "properties": {
              "__metadata": {
                "type": "object",
                "properties": {
                  "id": {
                    "type": "string"
                  },
                  "uri": {
                    "type": "string"
                  },
                  "type": {
                    "type": "string"
                  }
                }
              },
              "text": {
                "type": "string"
              }
            },
            "required": [
              "__metadata",
              "text"
            ]
          }
        },
        "__next": {
          "type": "string"
        }
      }
    }
  }
}
And this is the schema in the actual flow:

{
"type": "object",
"properties": {
"d": {
"type": "object",
"properties": {
"results": {
"type": "array",
"items": {
"type": "object",
"properties": {
"__metadata": {
"type": "object",
"properties": {
"id": {
"type": "string"
},
"uri": {
"type": "string"
},
"type": {
"type": "string"
}
}
},
"text": {
"type": "string"
}
},
"required": [
"__metadata",
"text"
]
}
},
"__next": {
"type": "string"
}
}
}
}
}

Was this reply helpful? Yes No
zgregory 21 on at

Like (1)

Report
Copy link

Link copied!

@v-yetonggu-msft sorry just wondered if you had any luck with my request 🙂

Was this reply helpful? Yes No
zgregory 21 on at

Like (0)

Report
Copy link

Link copied!

@v-yetonggu-msft any updates on this please? 🙂

Was this reply helpful? Yes No
v-yetonggu-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

Hi @zgregory ,

There is no error in your code in Parse Json.

And I observed that the title of the item is filled in your items().

What needs to be filled in here is the ID of the item.

Correct Format：

Best Regards,

Sunshine Gu

Was this reply helpful? Yes No
zgregory 21 on at

Like (1)

Report
Copy link

Link copied!

Hi @v-yetonggu-msft,

I removed the ID just to test one item which had comments. I have replaced the with ID how ever i am still getting the same error. What i have found some items are working through JSON and the comment is being pulled, for example:
ID = 89

How ever ID = 47 has a comment, the comment is "47" but the output is NULL:

Was this reply helpful? Yes No