How to easily Update Values in a SharePoint List with Microsoft Power Automate

In this video I share a quick tip which can be used when you want to update values in a SharePoint list containing mandatory fields. Check out the blog post:

This method allows you to target only the fields that you want to update without having to complete all of the fields in the normal Update Item action.

[ypvcbvq]

Just a small observation (you helped me out so much, can't thank you enough): if you are messy with how you handle naming your files (or lists in this case), please remember that renaming your list will not change its URL from the one generated upon creation. Mine was named "Test Call-Ins" at first, then I renamed it for the department to "Dept Call-Ins" so the compose action Paulie listed wouldn't work unless I told it to refer to the "test" name.

[gslvqz]

Perfect!! I was looking for a way to change one value field in a list containing over 16 fields, and using an 'Update Item' control was tedious. I could not find anyone else explaining how to update a single value until I found your tutorial. Thank you so much for sharing this information.

[praveenvasudevan]

Thanks! Spot on with the blog and the video.

[geralddahl]

Very efficient. Thank you for this resource. Much appreciated.

[colleengotling]

This is all new to me and this video is GREAT! But, I have a question. I am having to update a field for just one item in the list. I followed your instructions but it is taking a long time so I'm concerned that instead of updating just the one item, it might be updating the entire list.

[MedariKeshava]

Hi Paulie,

Thanks for another informative video, can u make a video on Dataverse - Power Automate integration as well on how to fetch records more than 5000 from dataverse

[navarrocloud]

Hi Paulie. How would you update a Person type?

[maricarmenjimenez]

Hi there!, thank you for your video, its very helpfull. I can't set user column, may you give an idea? Thank you

[BINDHUR-etei]

can we add values multichoice persontype columns Through Batch update flow???

[marinahugo]

Would it be possible to use Power Automate to sum the entries into the list on a given day and remove the duplicate entries? We use SP to capture stock taking - 3 columns [SKU; Qty =1; Date]. All the user does is scan the items into the list, then we have to use excel power query to merge and update the list before we can update Stock on Hand in another list.

[elseb]

This is all great but it would help a lot if you'd expand the "get item" card, I understand that this is obvious for experienced flow builders but without this for newbie the rest of the flow is useless.

[mstootable]

What if you need to update a different list?

[Zim-weezy]

can i specify if i have multiple rows ?

[RiGoRmOrTiSUK]

why do you have a "Get item" before updating the list?