Unanswered

Change reset time in ready formula

(0) Share

Report

Posted on by Joaoandrebs

361

I have a formula, which Laurens @LaurensM helped me build (thank you) that says that every time the fill of a rectangle based on conditions in the SP frequency column will fill green or orange, Daily = every day at 5:00, Monthly = every month at 5:00 and Weekly = every week at 5:00, but now what I need is instead of resetting only at 5 o'clock, to also reset at 3 o'clock in the afternoon (3:00 PM)

NOTE: I'm from South America, here the time is 15:00 and not 3:00 pm, but I don't know if this changes in the formula.

With(
 //Temp save date value based on Frequencia
 {
 wDateValue: Switch(
 ThisItem.Frequencia;
 "Diario";
 Today();
 "Semanal";
 DateAdd(
 Today();
 -Weekday(
 Today();
 StartOfWeek.MondayZero
 );
 TimeUnit.Days
 );
 "Mensal";
 Date(
 Year(Today());
 Month(Today());
 1
 )
 ) + Time(
 5;
 0;
 0)
 };
 If(
 Now() >= wDateValue && DateTimeValue(
 Label9.Text;
 "pt-BR"
 ) < wDateValue;
 Color.Orange;
 Color.Green
 )
)

Thanks!

Categories:

Building Power Apps

All responses (4)

Answers (0)

Sort by

gcmfaizan 1,022 on at

Like
a
(0)

Report
Copy link

Link copied!
@Joaoandrebs ,

Just update you If condition with the below formula,
If( Now() >= wDateValue + Time(5, 0, 0) || Now() >= wDateValue + Time(15, 0, 0), Color.Orange, Color.Green )

If this is the answer for your question, please mark the post as Solved.
If this answer helps you in any way, please give it a like.

Thanks!
Joaoandrebs 361 on at

Like
a
(0)

Report
Copy link

Link copied!

Hello @gcmfaizan
didnt work... 😞
gcmfaizan 1,022 on at

Like
a
(0)

Report
Copy link

Link copied!

@Joaoandrebs What is the error message?
vaubeee 533 on at

Like
a
(0)

Report
Copy link

Link copied!
@Joaoandrebs Try:

If( Now() >= wDateValue && DateTimeValue( Label9.Text; "pt-BR" ) < wDateValue || Now() >= wDateValue + Time(10;0;0) && DateTimeValue( Label9.Text; "pt-BR" ) < wDateValue + Time(10;0;0) ; Color.Orange; Color.Green )

------------------------------------------------------------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved. Remember, you can accept more than one post as a solution.

If you like my response, please give it a Thumbs Up.