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

Sharepoint update item does not carry forward values

I am relatively new to Power Automate and have previously completed 1 successful project using this tool. While using the "update item" action previously, the values that are obtained from the "When item is created or modified" trigger are automatically carried forward without any need for dynamic content or manual input. I would only need to leave the fields blank for them to remain their values.

 

However, my latest flow is giving me a headache as I am required to update each field using dynamic content. Otherwise, the values just disappear. The only fields that remain their values are date fields and drop down list fields. I am wondering if I did something to trigger this action or if it's a glitch. Hoping someone can help me to resolve this issue.

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: Sharepoint update item does not carry forward values

Please review the Limit Columns by View parameter of the Update item action which's description is: Avoid column threshold issues by only using columns defined in a view.

If you don't want to pass in dynamic content to the columns when updating an item, then create an "UPDATE" view for the list, and display only the columns you wish to pass dynamic content to. Then set the "UPDATE" view in the Limit Columns by View option. 

👨🏻‍💻 If this reply answers your question or solves your issue, please ACCEPT AS SOLUTION ☑️. If you find this reply helpful, please consider giving it a LIKE 👍.

View solution in original post

3 REPLIES 3
Super User
Super User

Re: Sharepoint update item does not carry forward values

If you could provide an expanded screenshot of your Flow and steps, and of any detailed error messages you're receiving we could likely better assist you. Also, for the best results, you may want to review How to write a good forum post.

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

SteffiKYC
Level: Powered On

Re: Sharepoint update item does not carry forward values

This is my "Update Item" SharePoint action on Power Automate. The red ticks are fields (drop down fields AND date & time fields) where I did not need to insert dynamic content in order to carry forward its values, whereas the yellow ticks are fields where I needed to. Doing so, the SharePoint list will update without issues. However, it is very tedious as my list is long and I have several flows.

image.png

 

 If I remove the dynamic content in the yellow tick fields, the SharePoint List will correspond by updating the list selectively. Old values for the yellow tick fields return blank values, whereas the red tick fields return their old values even without dynamic content. Below is a sample of the output in my SharePoint list when trying to update my values.

image.png

 During my previous project, I did not need to enter dynamic content for old values to be carried forward. For example, even while leaving the fields in my flow blank, the old values that were previously there should still be carried forward. So I'm not sure what's the issue.

Super User
Super User

Re: Sharepoint update item does not carry forward values

Please review the Limit Columns by View parameter of the Update item action which's description is: Avoid column threshold issues by only using columns defined in a view.

If you don't want to pass in dynamic content to the columns when updating an item, then create an "UPDATE" view for the list, and display only the columns you wish to pass dynamic content to. Then set the "UPDATE" view in the Limit Columns by View option. 

👨🏻‍💻 If this reply answers your question or solves your issue, please ACCEPT AS SOLUTION ☑️. If you find this reply helpful, please consider giving it a LIKE 👍.

View solution in original post

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,611)