cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Regular Visitor

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
Highlighted
Super User II
Super User II

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

4 REPLIES 4
Highlighted
Super User II
Super User II

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!

Highlighted
Regular Visitor

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.

Highlighted
Super User II
Super User II

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

Highlighted
New Member

o lRe: Sharepoint update item does not carry forward values

@Brad_Groux My Flow doesn't give me the option to limit by view in the "Update Item" section. I'm working in Flows. Any suggestions? 

 

 

Helpful resources

Announcements
firstImage

Super User Program Update

Three Super User rank tiers have been launched!

firstImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

firstImage

Join the new Power Virtual Agents Community!

We are excited to announce the launch of Power Virtual Agents Community. Check it out now!

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!

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