Update SharePoint Column using Power Automate (Choice, Date, Lookup and Person Column)

Thank You!!!
In this video, you will learn how to update the following SharePoint columns with an empty or null value:
1) Choice Column
2) Date Column
3) Lookup Column
5) Person Column

I also have a bonus Tip on the Date column, so don't miss it :)

Video Chapters:
00:00 Introduction
02:40 Update Choice Field
06:25 Update Lookup Field
07:59 Update Date Field
08:26 Bonus Tip for Date Field
11:51 Update Person Field

Reference Http Code :
URI: api/web/lists/getbytitle('ListName')/Items(ItemID)
Header:
{
"Accept": "application/json;odata=verbose",
"Content-Type": "application/json;odata=verbose",
"If-Match": "*",
"X-HTTP-Method": "MERGE"
}

Body:
{'__metadata':
{'type':'SP.Data.FlowDEMOListItem'},
'UserNameId':-1
}

Thanks again for watching.
Don't forget to subscribe and click on the notification bell.

Connect with me
Twitter: @deepak_s22

[shaiksamad]

Deepak. These are the common requirements which we used to get and you have solved it by this video.. Thank for the great work

[cmacdhon]

Hello Deepak. You video was enormous help. Thank you so much!

[arslanseitaly]

Hi Deepak, You saved my day! Thank you man!

Great information Deepak. Thanks for sharing.

[sureshgupta]

Hi Deepak, In this video you have show how to update empty value to a lookup column, can you tell me how to update a lookup column with an sharepoint value, i am getting as int error.

[dmp]

Hi Deepak, thanks for the video! I was having issues getting date values in my list to be set to null and I was trying to do what you suggested. Turns out that it only works with the old flow designer, not the new one. Even with the expression I was using written the same way, if I wrote the expression in the new designer it would fail saying the input for the expression needed to be a string/date value and wouldn't accept a null. The solution for me was to write the input for the parameter in the old designer (turn off the new one) and then it worked as expected. The help from Co-pilot suggested putting a placeholder date value in (1900-01-01) but that's a hack I wasn't going to fall back on. Appreciate your help!

[lm]

Hi Deepak, I love your videos. Can you tell me if it is possible to do something similar with a Sharepoint Document Library? I have a library where files are uploaded and the Authoriser name is assigned in a person column. Sometimes a file uploads and defaults the authoriser name immediately, which I don't understand but I thought if I could empty it immediately it wouldn't matter. Thanks. (Alternatively if you have any idea why a file brings its own field entry with it that would be just as helpful)

[amrithashetty]

Hi Deepak, I have created a flow for copying the list item from one column to other column is same sharepoint list, it works but when i add next new item previous copied item disappears ..please help on this

[gamingescape]

Hi, Can you help me with one thing? I am making a list where I have different status such as not started, need more information choices in the column and a second list where status have been given technical name like for not started status it will be technical and need more information will be functional and now I want that whenever status is not started it should be assigned to technical person in the column of people picker and name of that technical person should be displayed in column as per the status selected.
Can you let me know how to do that in sharepoint?

[virginiekauffman]

Hi Deepak, Thanks a lot, very useful tips.
I am trying to empty a user column on a library and it does not work. Does it change anything in the Body ? should I use SP.Data.LibrarynameListItem ? or is it different for a library ?
here is the error I get :A type named could not be resolved by the model.
thank you for your help.
best regards

[wasif]

instead of clearing the lookup column, I wanted to update it with some value e.g; with value inside the Title column

[prabhatawasthi]

Hi Deepak, Thanks for great work. i have a query, how to update dynamic choice field from one list to another list. please share link or tutorial if you have.

[shathike]

Hi Deepak, this is good informative, kindly let me know, lookup field not working for date format its visible number format (i.e. 44, 745) please guide me how to change as date format. Thanks

[debashishpanda]

Sir can you help me out. i am asked to get all the sites created in my SharePoint admin center to a new team site list. Means need all the data of dummy created sites into a new teamsite list using power automate. I dont know what to do. I created a new list in the team site using power automate and now i need to insert those dummy sites data using power automate. Can you help me out

[Itsprincessa]

is it possible to update a lookup column with the value from a single text column?

[ResponsibleXI]

Doesn't null mean empty string? Whats the difference between both?

[rosariofalero]

Hi Deepak, thank you so much for your video! Would you know why I am getting the following error when trying to update a user column as you described: An unexpected 'PrimitiveValue' node was found when reading from the JSON reader. A 'StartObject' node was expected.

[tdegler]

Great video! Thank you!
I am struggling to clear 2 float columns by condition. Sending null works, but sending null variable - does not work (sets column to 0). When I put "if(..., null, value)" into update, then null results also in 0.
Maybe you know how to solve that...

[richardjames]

This was terrible, the resolution is so bad that I can't see what you are typing.