Answered

label fill color on 2 controls

(0) Share

Report

Posted on by CU22100730-0

Hello everybody,

i have 1 small issue again, i want to use a statement on check of two things 1) when its date yesterday and when a specify texfield is emty then give a textlabel a red color but i dont get it right

Somebody small help please

thanks

I Try meany code but dont work

Switch(
 DateValue(Body1.Text);
 DateAdd(Today();-1);
 && If(IsBlank(UitgevoerdDoorLabel);
 (Label6);Color.Red; Color.Transparant
)

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (3)

Sort by

Prabhakar_S 735 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @ginobelgium,

You can achieve this by using the If function for each condition and then combining the results using the And function. Here's the corrected formula:

If( DateValue(Body1.Text) = DateAdd(Today(), -1) && IsBlank(DoorLabel.Text), Color.Red, // If both conditions are true, set color to Red Color.Green // Otherwise, set color to Green )

In this formula:
DateValue(Body1.Text) = DateAdd(Today(), -1) checks if the date in the Body1.Text control was yesterday.
IsBlank(DoorLabel.Text) checks if the DoorLabel control's text is empty.
&& is used to combine both conditions with the logical AND operator.
If both conditions are true, the label's color is set to Color.Red. Otherwise, it's set to Color.Green.
Make sure to replace Body1.Text and DoorLabel.Text with the actual names of your controls.

Thanks!!!

Please consider marking my response as the accepted solution if it successfully resolves your concern. If you found the information beneficial in other aspects, kindly express your appreciation by giving it a thumbs-up.

Was this reply helpful? Yes No
CU22100730-0 93 on at

Like
a
(0)

Report
Copy link

Link copied!
Thankyou verry much
Prabhakar_S it works great this way , 1 more small question: what do do if i want the iff statements become true if the date is between yesterday and yesterday -5

If( DateValue(Body1.Text) = DateAdd(Today(), -1) && IsBlank(DoorLabel.Text), Color.Red, // If both conditions are true, set color to Red Color.Green // Otherwise, set color to Green )

Thanks a lot
PREVIEW

Was this reply helpful? Yes No
Verified answer

Prabhakar_S 735 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @ginobelgium ,

You're Welcome. If you want the conditions to be true if the date is between yesterday and yesterday -5, you can modify the formula like this:

If(
DateValue(Body1.Text) >= DateAdd(Today(), -5) && DateValue(Body1.Text) <= DateAdd(Today(), -1) && IsBlank(DoorLabel.Text),
Color.Red, // If all conditions are true, set color to Red
Color.Green // Otherwise, set color to Green
)

Thanks!!!

Please consider marking my response as the accepted solution if it successfully resolves your concern. If you found the information beneficial in other aspects, kindly express your appreciation by giving it a thumbs-up.

Was this reply helpful? Yes No
CU22100730-0 93 on at

Like
a
(0)

Report
Copy link

Link copied!
Goodmorning Prabhakar, i work it out last night and your help learn me a lot, thanks for your kindness!
Only one thing, when i want with this code put text in a label, i try few codes in the TEXT part of the label to fix this but not working great
If( DateValue(Body1.Text) >= DateAdd(Today(), -5) && DateValue(Body1.Text) <= DateAdd(Today(), -1) && IsBlank(UitgevoerdDoorLabel.Text); (Label10);"Op te volgen";"") )

Was this reply helpful? Yes No
Verified answer

Prabhakar_S 735 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @ginobelgium ,

Give this a try,

If(
DateValue(Body1.Text) >= DateAdd(Today(), -5) && DateValue(Body1.Text) <= DateAdd(Today(), -1) && IsBlank(DoorLabel.Text),
"Op te volgen",
""
)

If you still have issues, send a screenshot of the error and give a quick brief on what you are trying to achieve.

Thanks!!!

Please consider marking my response as the accepted solution if it successfully resolves your concern. If you found the information beneficial in other aspects, kindly express your appreciation by giving it a thumbs-up.

Was this reply helpful? Yes No
Verified answer

CU22100730-0 93 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks Prabhakar

Was this reply helpful? Yes No