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
Go to Solution.
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:
The the drop down will be automatically filled in data according to time.
Community Support Team _ Phoebe Liu
View solution in original post
So how to compare Datetimevalue like
If "18/05/2019 07:28 PM" + 11.5 hours > Now(), Then TRUE, Else FALSE
Fill out a quick form to claim your user group badge now!
Find out where you can attend!
Features releasing from October 2019 through March 2020
The largest Power BI, Power Platform, and Data conference in New Zealand