Answered

How to set expiration date based on value selected on Dropdown

(0) Share

Report

Posted on by Benmo33

Hi All

Can anyone please help me figure this out. I need to set expiration date in PowerApps based on training selected on Dropdown and date completed.

for example if user completes Training A on 5/4/2021 then expiration date should be a year later and if Training B was completed on 5/5/2021 then expiration date should be a 2 years later

This is the formula that I am using in SharePoint list.

=IF(Training="Training A",[Date Completed]+365,IF(Training="Training B",[Date Completed]+730,IF(Training="Training B","12/31/2999")))

Categories:

Building Power Apps

Power apps .png

I have the same question (0)

All responses (2)

Answers (1)

TheRobRush 11,128 Moderator on at

Like (0)

Report

DateAdd(Today(),365,Days) will give you the date 1 year from today. Can change today to a variable that is in date format, and 365 & days both to any number and unit.

Was this reply helpful? Yes No
Verified answer

eka24 20,923 on at

Like (0)

Report

Does it mean you are dealing with only 2 dates? if on the DefaultDate of the DatePicker which holds the formula:

If(DatePicker1.SelectedDate>Today() And Dropdown1.Selected.Value = "Training A",DateAdd(DatePicker1.SelectedDate,365),

If(DatePicker1.SelectedDate<Today() And Dropdown1.Selected.Value = "Training B",DateAdd(DatePicker1.SelectedDate,730),Today()))

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Was this reply helpful? Yes No