cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
current_
New Member

Microsoft Flow updating Calculated Field

Hello, I have two SharePoint List A and B and a flow that updates List A with some values in List B if an item is modified or entered in B. SharePoint list A has a calculated field(date and the first letter of a string) but B doesn’t. Anytime the flow runs, it successfully updates List A with new values from B but sets the calculated field as NULL although that column is not part of the columns to be updated. The flow does not reference the calculated field to update.  Can anyone explain why this is happening?

1 ACCEPTED SOLUTION

Accepted Solutions
v-litu-msft
Community Support
Community Support

Hi @current_,

 

I tested on my side that reproduced your Flow but not find the same issue.

The calculated column not changed to null, and if one parameter in the calculated column updated, the calculated would update automatically.

Could you please share with me how do you configure the calculate column?

 

Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

1 REPLY 1
v-litu-msft
Community Support
Community Support

Hi @current_,

 

I tested on my side that reproduced your Flow but not find the same issue.

The calculated column not changed to null, and if one parameter in the calculated column updated, the calculated would update automatically.

Could you please share with me how do you configure the calculate column?

 

Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Users online (2,568)