I have a question for you,
I have a button that patches information to a SP list, i would like for this button to be disabled based on time and maybe date 🙂
I have tried to wickle my way around this, and have come up with this function/statement: If(Now()>Time(14;30;00);Disabled;Edit) the idea being that if the time has passed half 2 the button would be disabled, now PA doesn't complain about this statement but it also doesn't actually follow it, it just shows the button in edit mode no matter the timestamp?
Has anyone got an idea of how to work around this issue, or maybe a completely different solution.
Thanks in advance
Solved! Go to Solution.
The problem is that you are expecting it to dynamically re-evaluate Now() in real time. It won't do that. It will evaluate your formula when the screen loads or at some other time depending on where you put it. To get the kind of real time support you want I would suggest changing the formula to save a value in a variable. Then use that formula in a Timer that runs on a cycle. The variable value would be set on the completion of each cycle. Then enable or disable the button based on the value in the variable.
The problem with that design is that if you make the timer cycle too short it could really drain performance.
Yes of course! I feel like an idiot i have litteraly used this but because most forums and sites are from the US the syntax(seperators) are different, and it only occured to me now that that was the issue 🙂
DisplayMode: If(TimeValue(Text(Now())) > Time(14,30,00),Disabled,Edit) definately works when it comes to the time a day, however, i am now looking to expand on this, i essentilly want the displaymode to be disabled if the time is within 14,30,00 on a specific day,
I have checkboxes Monday through Friday, Monday should close of af 1430 on mondays, however Tuesday, Wednesday, Thursday, Friday should still be available to check off??
I thought you might have some input on how this might be achieved? 🙂
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