cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Anonymous
Not applicable

Leave Request - weekend calculation

Hi ,

 

 I want to calculate all the days that are being requested, including weekends. There is already a variable being defined, _inclusiveTotalDaysRequested .

I manged to add  one leave type which calculates total days requetsed, but when am adding multiple leaves its giving error .

 

please assist

 

 

2 REPLIES 2
Community Support Team
Community Support Team

Re: Leave Request - weekend calculation

Hi @Anonymous,

Could you please share a bit more about the error message within your app?
Could you please show more details about your scenario?

 

Best regards,

Kris

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous
Not applicable

Re: Leave Request - weekend calculation

Hi Kris,

 

Am trying to set few leave types which calculates only date difference , Lets say for example maternity and paternity , As per company policy  eligible leaves are in calender days not working days .

 

I managed to setup Maternity by modifying the formulas in below areas,But when i add multiple leave types in with same formula am getting error.

 

 

 NewRequestScreen -> GroupDateSelection -> OnSelect

               If(Upper(_selectedLeaveType.type)<>"Maternity", Set(_requestedDays, _workDaysInRequest - _holidaysInRequest), Set(_requestedDays, _inclusiveTotalDaysRequested))

Then  it is effectively checking if Maternity was selected, then we set _requestedDays to _inclusiveTotalDaysRequested.

 

HomeScreen -> GalleryRequests -> OnSelect

If(Upper(_selectedLeaveType.type)<>"Maternity", Set(_requestedDays, _workDaysInRequest - _holidaysInRequest), Set(_requestedDays, _inclusiveTotalDaysRequested))

 

Text property in NewRequstScreen -> GourpDateSelectio -> Label1_9

LookUp(RequesterBalanceCollection, Upper(type)=Upper(_selectedLeaveType.type), balance) - If(Upper(_selectedLeaveType.type)<>"Maternity", _requestedDays, _inclusiveTotalDaysRequested)

    &

    " days"

 

Regards,

Rahul Lal

 

Helpful resources

Announcements
thirdimage

Power Apps Super User Class of 2020

Check it out!

thirdimage

Power Apps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

SecondImage

Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Top Solution Authors
Top Kudoed Authors (Last 30 Days)
Users online (5,283)