cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
mbhushan
Level: Powered On

Re: How can I update only 1 property in a SharePoint List

Hi Scott,

In update item for Required fields, if we try to set value using Dynamic Properties, there is no option to pickup current value from List. e.g. see below scenario to understand my problem.

List A have 4 fields as Required fields. MS Flow is actived when new entry is added in Flow. Then flow sends an approval request, where i call update item to update approval comments in same list. At this stage in update item i have to set values for Required fields using Dynamic Properties. However is there a possibility to get latest values from List itself while setting these values? Problem is when entry is added in List and if its modified before approval, then during approval i can't see option to pickup those modified values. See below SS

SS 1.PNG

 

alejandroriv84
Level: Powered On

Re: How can I update only 1 property in a SharePoint List?

What about using HTTP request?

This allow you update just one field: 

 

 

WFExample.pngExample

 

 
Super User
Super User

Re: How can I update only 1 property in a SharePoint List

@mbhushan 

A simple solution might be to use a Get Item action before the Update and use the values from the Get Item for the required columns.

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Scott
Highlighted
x-Rei-Ai-x
Level: Powered On

Re: How can I update only 1 property in a SharePoint List

Possible Solution?

  1. Create a Custom View in your SharePoint List, making only the fields you are interested in visible
  2. Choose that Custom View in the SharePoint action "Get item" -> "Advanced Options" -> "Limit Columns by View"
  3. Choose that "Get item"'s ID in the SharePoint action "Update item"

 

Edit: Nevermind. This doesn't appear to work due to a broken "Limit Columns by View" function - forums indicate this is not working as intended.

Helpful resources

Announcements
firstImage

Incoming: New and improved badges!

Look out for new contribution recognition badges coming SOON!

firstImage

Power Platform Online Conference

Join us for the first ever Power Platform Online Conference!

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Power Automate Community Video Gallery!

Top Solution Authors
Top Kudoed Authors
Users online (5,679)