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

SharePoint
SharePoint
A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
10,011 questions
PowerShell
PowerShell
A family of Microsoft task automation and configuration management frameworks consisting of a command-line shell and associated scripting language.
2,219 questions
0 comments No comments
{count} votes

Accepted answer
  1. Emily Du-MSFT 43,176 Reputation points Microsoft Vendor
    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