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

Рет қаралды 22,812

Күн бұрын

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:
www.tachytelic.net/2023/03/po...
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.

Пікірлер: 24

@user-yp5vc9bv1q Жыл бұрын

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.

@praveenvasudevan997 6 ай бұрын

Thanks! Spot on with the blog and the video.

@geralddahl9159 Жыл бұрын

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

@gslvqz8812 6 ай бұрын

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.

@PaulieM 6 ай бұрын

Glad it helped. It’s actually really frustrating to update a row that has a lot of fields.

@colleengotling3680 4 күн бұрын

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. I did a little more testing and I think my issue is that I'm updating a on premise list going through the On premise data gateway so I am trying to connect to the list but it's not finding it.

@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

@elseb 26 күн бұрын

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.

@maricarmenjimenez4877 4 ай бұрын

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

@navarrocloud Жыл бұрын

Hi Paulie. How would you update a Person type?

@BINDHUR-et6ei 4 ай бұрын

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

@mstootable 8 ай бұрын

What if you need to update a different list?

@marinahugo4173 6 ай бұрын

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.

@PaulieM 6 ай бұрын

Yes. It would be possible.