Filling the icon 1 time a week?

(0) Share

Report

Posted on by Joaoandrebs

361

hey guys,

I need to make a condition for the fill of this icon. I need it to be orange every Monday at 7 am, however, it will paint the fill green if the date of the label9_2.text (comes from another base) is greater than the date on which the icon was painted orange ( Monday, 7 A.M.)

label 9_2.text in red!

Ex: 07/03/23 - Monday - 7 AM = orange color
label9_2 = 03/07/23 - Monday - 10 AM = green color
and the next orange color will be on 03/10/23 at 7 am!

Grateful!!

Categories:

Building Power Apps

I have the same question (0)

All responses (11)

Answers (1)

LaurensM 12,516 Moderator on at

Like (1)

Report
Copy link

Link copied!
Hi @Joaoandrebs,

Please give the code below a try in the Fill property:

If( //On Monday & time is exactly 7am Weekday( Today(), StartOfWeek.Monday ) = 1 && Now() = Time( 7, 0, 0 ), If( //If label time is less than 7am DateTimeValue(Label9_2.Text) < Time( 7, 0, 0 ), //Show orange Color.Orange ), //In all other cases show green Color.Green )

If this solves your question, would you be so kind as to accept it as a solution & give it a thumbs up.

Thanks!

Was this reply helpful? Yes No
Joaoandrebs 361 on at

Like (0)

Report
Copy link

Link copied!

@LaurensM firstly thanks for the answer bro,

and I believe that your code is correct, but I believe that the detail is that the times change because I'm from the pt-br zone and not en-us (?). here our schedule does not have A.M or P.M and I think it is impacting in some way... look:

now, this is stranger:

to me it seems to be this... I don't know what to say about it?

Was this reply helpful? Yes No
Joaoandrebs 361 on at

Like (0)

Report
Copy link

Link copied!

@LaurensM im verificating, look this 😐🤔

Was this reply helpful? Yes No
LaurensM 12,516 Moderator on at

Like (0)

Report
Copy link

Link copied!
Hi @Joaoandrebs,

I clearly made a mistake, I see. Please use the following adjustment:

If( //On Monday & time is exactly 7am Weekday( Today(), StartOfWeek.Monday ) = 1 && Now() = Today() + Time( 7, 0, 0 ), If( //If label time is less than 7am DateTimeValue(Label9_2.Text, "pt-BR") < Today() + Time( 7, 0, 0 ), //Show orange Color.Orange ), //In all other cases show green Color.Green )

As a note: Weekday(Today(), StartOfWeek.Monday) returns a number depending on the weekday. In this case, Monday will have the value 1.

If this solves your question, would you be so kind as to accept it as a solution & give it a thumbs up.

Thanks!

Was this reply helpful? Yes No
Joaoandrebs 361 on at

Like (0)

Report
Copy link

Link copied!

@LaurensM

I'm testing through the current day (Wednesday), and by the launch I made yesterday (Tuesday), it should appear orange, but it only appears green..
What I find strange is that "Time" is returning the date 1/1/1970.

Was this reply helpful? Yes No
Joaoandrebs 361 on at

Like (0)

Report
Copy link

Link copied!

@LaurensM

but this one is correct...

Was this reply helpful? Yes No
Verified answer

LaurensM 12,516 Moderator on at

Like (1)

Report
Copy link

Link copied!
Hi @Joaoandrebs,

I made some additional adjustments and removed the nested if() statements. With the code below we will only display an orange color when the current time is after Monday 7AM (of this week) & the label is before Monday (of this week) 7AM.

With( //Temp save current Monday 7am value {wCurrentMondayMorning:DateAdd(Today(),-Weekday(Today(),StartOfWeek.MondayZero),TimeUnit.Days)+Time(7,0,0)}, If( Now() >= wCurrentMondayMorning && DateTimeValue(Label9_2.Text,"pt-BR") < wCurrentMondayMorning, //Monday, currently 7AM or later & the label date is before Monday of this week 7AM - show Orange Color.Orange, //In all other cases show green Color.Green ) )

The code above will only show green when the (1) the label date is after the current Monday 7AM or (2) it is currently Monday before 7AM.

I hope this helps!

Was this reply helpful? Yes No
Joaoandrebs 361 on at

Like (0)

Report
Copy link

Link copied!
@LaurensM
I believe we are on the way! however, when checking, I inserted a button and created an updateContext to see what the return was, and on Monday it was OK! however on Tuesday, the only thing I changed in the formula was StartOfWeek.Monday to StartOfWeek.Tuesday, and it produced the same value (?) I didn't quite understand!
UpdateContext({wCurrentMondayMorning1:DateAdd(Today(); -Weekday(Today();StartOfWeek.Tuesday);TimeUnit.Days)+Time(7;0;0)})
But APPARENTLY it's working, so I'm not likely to check.

Was this reply helpful? Yes No
LaurensM 12,516 Moderator on at

Like (1)

Report
Copy link

Link copied!

Hi @Joaoandrebs ,

I understand the confusion surrounding the variables. My code uses StartOfWeek.MondayZero: Monday returns 0, Tuesday 1, Wednesday 2... We use these numbers to 'subtract' the difference between today and this week's Monday in order to get Monday's date.

Using StartOfWeek.Tuesday will look quite similar with one exception. Tuesday will return 1, Wednesday 2... However, Monday will return 7.

Was this reply helpful? Yes No
Joaoandrebs 361 on at

Like (0)

Report
Copy link

Link copied!
@LaurensM
hello laurens! all very well?

I inserted your code in another problem I have,

I have a system that changes the fill of an icon to green and yellow in 3 conditions, daily, weekly and monthly. This condition applies from records saved in a list, which are answered in a form, which some of these records are monthly, daily and weekly.

What i have:
Diary turns yellow 7:00 A.M every day
Weekly turn yellow every Monday at 7:00 ---- ok!
Monthly turn yellow every 1st at 7:00 of every month
I believe I have only one detail to modify, but I haven't found a way yet
Switch( ThisItem.Frequencia; "Semanal"; With( //Temp save current Monday 7am value {wCurrentWeekly:DateAdd(Today(); -Weekday(Today();StartOfWeek.MondayZero);TimeUnit.Days)+Time(7;0;0)}; If( Now() >= wCurrentWeekly && DateTimeValue(Label9.Text;"pt-BR") < wCurrentWeekly; //Monday, currently 7AM or later & the label date is before Monday of this week 7AM - show Orange Color.Orange; //In all other cases show green Color.Green ) ); "Diario".... "Mensal"...

I've tried numerous solutions but none of them work for my tests 😞

Was this reply helpful? Yes No