Unanswered

set limit of request allow per month in Leave app

(0) Share

Report

Posted on by Armie0217

Hi All,

I'm currently creating a leave app and tried lot codes to set a limit of request can be submitted every month (Ex: we have 16 requests for the month of March, but the available slots is only 14). I wanted the user to received a notification error in app or email trigger from power automate that there is no available slots for the month.

I have a column Number of Days (calculated between the start date and end date) and Column Month (text from the Start date submitted) , I tried in power automate but I don't know the options that I can use to count the number of days so it will trigger the control once the limit has been reached. Please help!

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

v-jefferni on at

Like (0)

Report

Hi @Armie0217 ,

Could you please share more details? How do you determine the limit of requests for different months? Or it's always 14?

Best regards,

Was this reply helpful? Yes No
NPPlatform 606 Moderator on at

Like (0)

Report

Hi @Armie0217, I think you could solve this in the app without making use of Power Automate. When a user tries submit a leave-request for a month you can check how many records already exists in your leaves-table for that month. If this is equal to the amount that's allowed you show the user a notification (for example "The maximum amount of leave-requests for this month has already been reached. Your request can not be completed."), if the maximum has not been reached yet, you start the process for the leave-request.

Was this reply helpful? Yes No
Armie0217 6 on at

Like (0)

Report

Hi @v-jefferni - the limit is calculated based on the working days per month and number of employees as we need to make sure we have like 90% presence percentage every month.

Was this reply helpful? Yes No