Get and update SharePoint list item using Power automate Http REST call l Parse Json l MS Flow

[@venkateswararao4303]

Vivek Ji I am following and learning the power automation

[@viveknavik2909]

Keep learning and become expert

[@janeg1848]

Great video. I had to change my double quotes to single quotes in the POST action. It kept throwing out an error otherwise 😊.

[@anutv-d3d]

Well explained

[@vazik_cze]

Hello Vivek, I wonder. Can you create a video with a way to archive a bit more complicated list (multiline / choise) and together with attachments? This would be appreciated. Thank you

[@katcol312]

Hi Vivek. Truly a great tutorial video. Thank you! Questions- Will this method require constantly updating any part of the steps if there are no significant changes to the SharePoint lists? Is there a less complex flow that will do the same as this one? If so, can you do a video on an alternate process flow?

[@indumathi-b2r]

The execution of template action 'Apply_to_each_2' failed: the result of the evaluation of 'foreach' expression '@body('Parse_JSON')?['body']?['d']?['results']' is of type 'Null'. The result must be a valid array. I am getting error like this..how to solve it?

[@surbhikshah2423]

Hi Vivek very helpful for beginners but if I was to use the post method for exporting data to excel is that the way to go? I have a requirement similar using Json from sp list to excel and with column name data type

[@viveknavik2909]

You can make use of "Create CSV table" action block in power automate

[@calcioscacchi]

Should I use this flow to edith the author and the creation datetime of the original table?

[@viveknavik2909]

Yes this can be used

[@veerpat5331]

Hi nice na handy tutorial..
In my case, i got error for first "Parse Json". Any feedback would be helpful.
{
"message": "Invalid type. Expected String but got Null.",
"lineNumber": 0,

[@calcioscacchi]

Did you solve this?

[@viveknavik2909]

In the parse json schema put this in the type where ever u feel like column can return null... example : "heat_index_f": {
"type": ["number","null"]
}

[@calcioscacchi]

@@viveknavik2909 now I got it... we have to modify the schema loaded from the example, not the example itself...

[@viveknavik2909]

@@calcioscacchi exactly