Help with IF with DateDiff syntax

(0) Share

Report

Posted on by LTEVA

Hello everyone,

some help if possible with the following case:

What i have:
2 Date pickers (Start and End date)

ComboBox1 with values (Pending , Approved)

Combobox2 with values (Draft,Active,NearExpiration,Expired)

I cannot come up with the correct syntax so to have simultaneously IF's so to set 2 Comboboxes:

If Datediff Start,End = 0 then ComboBox1=Approved, ComboBox2=Expired

If Datediff Start,End<=14 then ComboBox1=Approved , ComboBox2=NearExpiration

If DateDiff Start,End>14 then ComboBox1=Approved , ComboBox2=Active

Any suggestion or logic to achieve the result will be much appreciated

Regards to all and Stay Healthy

Categories:

Building Power Apps

All responses (5)

Answers (1)

Sort by

Verified answer

CU-18081211-6 9,272 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @LTEVA ,
Each comboboxes has to be set separately on DefaultSelectedItems property similar to:
For ComboBox2:
If (DateDiff(Start,End,Days)=0, "Expired", DateDiff(Start,End,Days)<=14,"NearExpiration","Active")
For ComboBox1:
"Approved"

Hope it helps !
WarrenBelz 156,754 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @LTEVA ,

Some syntax guidance here

With( { wDiff: DateDiff( Start, End, Days ) }, UpdateContext( { varDiff, If( wDiff=0, "Expired" If( wDiff<=14, "NearExpiration", "Active" ) ) } ) ); Reset(ComboxBox2)

The DefaultSelectedItems of ComboBox2 would be

varDiff

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.
LTEVA 27 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @ gabibalaban,

Based on your solution i've made some slight modifications to adjust to my data and it worked Perfect!!

Many thanks
LTEVA 27 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @WarrenBelz ,

thanks for the suggested formula.
I gave a try on this but got some errors.

Please clarify if i should give this on the DefaultSelectedItems of ComboBox1.

Thanks again.
WarrenBelz 156,754 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

@LTEVA ,

I assumed you have solved this - mine was just a different approach