Microsoft Flow updating Calculated Field

Linford Frimpong 1 Reputation point
2020-12-09T22:21:06.1+00:00

Hello, I have two SharePoint List A and B and a flow which 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 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. Can anyone explain why this is happening?

SharePoint Workflow
SharePoint Workflow
SharePoint: A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.Workflow: An orchestrated and repeatable pattern of business activity, enabling data transformation, service provision, and information retrieval.
513 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Elsie Lu_MSFT 9,771 Reputation points
    2020-12-29T09:11:31.707+00:00

    Hi @Anonymous ,

    Thanks for waiting. :)
    Based on your description, I created List A and List B for a simple test.
    In List A , Calculated is used as the Calculated column, and the result is the sum of column Number 1 and Number 2. At the same time, Updates is used as the updated Column when an item in list B is created.
    Per my test, when a new item is created in List B , the first item in list A is updated successfully and the calculated column is not affected.
    As shown below:
    51870-1.jpg51991-2.jpg
    51859-3.jpg

    In order to reproduce your issue, I did some more tests but no luck:

    i. If the number in the number1(or 2) column is updated, the Calculated Column will be updated accordingly, no problem.

    ii. If the data in the updated number1 column is not a number, the display is invalid.
    51948-4.jpg

    iii. If the update is the value in Calculated column, flow will report an error by itself.
    51877-5.jpg

    So could you please tell me more detailed information for further research? For example:

    1.What is the structure of List A and List B? What are the types of columns?
    2. Would you like to share the specific steps of Flow?
    3. Have you made any special settings for these two lists, such as custom development?

    If the answer is helpful, please click "Accept Answer" and upvote it.

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    0 comments