Sum of Calculated Columns using Power Automate

Josephine 20 Reputation points
2024-05-22T08:01:53.54+00:00

Hi! I am a newbie to Power Automate. I am looking for some help with my project re leave management system. I want to create a flow to get the sum of my SharePoint list calculated columns and auto populate them to another SP list column.

I have 3 calculated columns (PL_Balance, AL_Balance, and LSL_Balance) in the Leave Monitoring list, and I want to get the total of each column by employee, then auto populate them into another list named Leave Summary.

I have searched on many different sites, but I couldn’t find any answers related to this. I only found this one on YouTube, but this one is not about the calculated column: https://youtu.be/z5MxbwURV68. si=3eyEq6N4msSGm3Xj

I have tried this one, but the calculated columns didn’t show up when I was doing the mapping. It is really painful to work on the calculated columns.

I hope someone can help me with this. Any help will be highly appreciated. 😊

User's image

User's image

Microsoft 365 and Office | SharePoint | For business | Windows
Windows for business | Windows Server | User experience | PowerShell
0 comments No comments
{count} votes

Accepted answer
  1. Emily Du-MSFT 51,846 Reputation points Microsoft External Staff
    2024-05-23T01:59:14.5133333+00:00

    Power Automate is currently not supported in the Q&A forum.

    Please start a new discussion via the Power Automate Community so that you can get dedicated support on this issue.

    Thank you for your understanding.


    If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

    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.

    1 person found this answer helpful.
    0 comments No comments

0 additional answers

Sort by: Most helpful

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.