Calculate Values to Populate Excel Table

(0) Share

Report

Posted on by CU19120319-0

When my manager asked me to do a flow ，I had a problem
It is hoped that when an employee submits an overtime application, it initiates an approval, and after the approval is passed, it is collected on Excel or List. All of the above can be achieved. But I ran into the following problem
1. Employees may work overtime multiple times a month, and hope that each overtime work can be recorded in the same line
2. There is a column in excel and list to calculate overtime wages, but the overtime wages on weekdays are 1.5 times the daily wage, that is, the working hours should be calculated as 1.5H, at the same time, weekends are calculated as 2 times, and statutory holidays are 3 times.
In this case, how can I solve the above problem?

Categories:

Business Process Flows

I have the same question (0)

All responses (1)

Answers (0)

Suggested answer

David_MA 12,515 Super User 2025 Season 2 on at

Like (0)

Report
Calculate Values to Populate Excel Table

Without knowing what data is being captured when an approval is submitted, it is hard to tell you what to do. However, here is some basic guidance:

If you're capturing the dates for pay, you can use the DayOfWeek() expression (https://learn.microsoft.com/en-us/power-automate/minit/date-and-time-operations#dayofweekdate) to determine if it is a weekday or weekend. It returns 0 for Sunday and 6 for Saturday.

You can then use a condition to check if what is returned is equal to 0 or 6 and then use the mul() (https://learn.microsoft.com/en-us/azure/logic-apps/workflow-definition-language-functions-reference#mul) to multiple the wages by 1.5.

You can use other expressions to see if overtime needs to be paid.

To test some of the expressions, use variables and compose actions. You can then run your flow and see the result to make sure it is correct.

What you want to do can certainly be done, but it is not exactly simple since you need to ensure the data needed is available in your process and you need to know how to build expressions and conditions.

The biggest hurdle will be with figuring out the holidays. Here is a post that goes into some of the issues you will encounter with your process: Excluding weekends and holidays in date differences in PowerApps - Microsoft Power Platform Blog

I would start building your flow, and then when you encounter a specific issue you run into, post a question specific to the issue and show your flow and how the action is configured. Also provide any error messages you get.

I doubt anyone in these forums is going to show you how to completely build what you are asking.

Was this reply helpful? Yes No