cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Phu_Le
Level: Powered On

Dropbox auto select depend on current time

Hi All,

Please help me in this case, I am practicing write an app

 

I have a DropBox (["SHIFT1","SHIFT2","SHIFT3"]

How to make this Dropbox auto chose the right SHIFT, depend on the Now() time

IF       06:30 AM  >=  Now()  >  02:30 PM => SHIFT 1

IFElse 02:30 PM  >=   Now()  > 10:30 PM => SHIFT 2

Else => SHIFT 3

Thanks

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Dropbox auto select depend on current time

Hi @Phu_Le ,

Do you want to the drop down's selected value change according to time?

I'm afraid it's not supported to change the selected value directly.

As alternative way, I suggest you set the drop down's defaultselected value.

Set the drop down's Default:

If(Time(6,30,0)<=Now()&&Time(14,30,0)>Now(),"SHIFT1",Time(14,30,0)<=Now()&&Time(22,30,0)>Now(),"SHIFT2",SHIFT3")

The the drop down will be automatically filled in data according to time.

 

Best regards,

Community Support Team _ Phoebe Liu

Community Support Team _ Phoebe Liu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

2 REPLIES 2
Community Support Team
Community Support Team

Re: Dropbox auto select depend on current time

Hi @Phu_Le ,

Do you want to the drop down's selected value change according to time?

I'm afraid it's not supported to change the selected value directly.

As alternative way, I suggest you set the drop down's defaultselected value.

Set the drop down's Default:

If(Time(6,30,0)<=Now()&&Time(14,30,0)>Now(),"SHIFT1",Time(14,30,0)<=Now()&&Time(22,30,0)>Now(),"SHIFT2",SHIFT3")

The the drop down will be automatically filled in data according to time.

 

Best regards,

Community Support Team _ Phoebe Liu

Community Support Team _ Phoebe Liu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Phu_Le
Level: Powered On

Re: Dropbox auto select depend on current time

Thank @v-yutliu-msft 

So how to compare Datetimevalue like

If "18/05/2019 07:28 PM" + 11.5 hours > Now(), Then TRUE, Else FALSE

Thanks!

 

Helpful resources

Announcements
thirdimage

Coming Soon: T-Shirt Design Contest

Keep your eyes open for our upcoming T-shirt design contest!

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

Top Solution Authors
Top Kudoed Authors
Users online (5,940)