Power Platform Community Forum Thread Details

Hello Grupo,

I have been trying to come up with a formula just like in excel in where you have the option to add a # of business days to the original selection of the date selected in the calendar.

The scenario:

User will select a Priority level from a dropdown:

High (2 days) ,
Medium (5 days)
Low (10 days)

And select the date of their request (todays date) using the calendar datepick function.

I need to find a way in which I can take (today's date) selected from the calendar and add the number of business days depending on the priority level.

ie: the user selects Medium (5 days) [from the dropdown] and the todays date is 27-Mar-2020 [From the calendar date picker],

I need the result to return 03-Abr-2020 a new field.

Hoping to hear all your ideas,

Daniel

Categories:

Building Power Apps