web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Update SharePoint with...
Power Automate
Answered

Update SharePoint with calculation

(0) ShareShare
ReportReport
Posted on by 308

Hi Power Automate community,

 

I have an Approval flow for vacation request. I also have 2 lists in SharePoint that serve as parent and child. The VacationRequest list is the parent and the Employee list is the child. The VacationRequest list contains a column: TotalDays which is the days that the employee will go on vacation and the Employee list contains a column VacationDaysAvail which is the days that an employee has available to go on vacation. Each vacation request will subtract the TotalDays days from the VacationDaysAvail. I have succeeded that step through PowerApp already. The only problem is, if the manager Reject the approval, I want the Flow to add the TotalDays back to VacationDaysAvail.

 

Problem1.pngProblem2.png

 

I have tried many combination but it doesn't work. If the Outcome is no, all I want to do is update status to "Rejected" and add the total requested days back to the employee.

 

Can someone help me?

Categories:
I have the same question (0)
  • Verified answer
    Jcook Profile Picture
    7,781 Most Valuable Professional on at

    Hello @JB0007 

     

    Your Compose shape is not formatted properly.

     

    When you want to use expressions, you have to click the Expressions tab type add()

    Than click the dynamic content tab and select your values.

     

    You will know if you are typing an expression if you see the FX logo in the box you are typing in.

  • JB0007 Profile Picture
    308 on at

    Thank you @Jcook.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Automate

#1
trice602 Profile Picture

trice602 239 Super User 2026 Season 1

#2
David_MA Profile Picture

David_MA 177 Super User 2026 Season 1

#3
Kalathiya Profile Picture

Kalathiya 97 Super User 2026 Season 1

Last 30 days Overall leaderboard