web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Color rectangle based ...

Power Apps

Unanswered

Color rectangle based on date

(0) Share

Report

Report

Posted on by Wagemans_Frank

61

Hi

I have a 'START' and 'END' date in my list.

In my gallery i want to see a rectangle that is green when today is between start and end date.
It must be red when its not.

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (3)

Answers Img

Answers (1)

v-qiaqi@microsoft.com on at

Like (1)

Report
Hi @Wagemans_Frank,

Please set the TemplateFill property as below:

If(Now() >= ThisItem.START&&Now() <= ThisItem.END,Color.Green,Color.Red)

Was this reply helpful? Yes No
Wagemans_Frank 61 on at

Like (0)

Report

Hi

All mij rows are the same color.

My startdate is a column with a date.
I have an extra column (text) with the days.
My enddate is a column (text) with a formula DATEVALUE(thisitem.startdate)+(Thisitem.days)

How do i configure this to change the color green when Now() is not between Startdate and enddate?

Was this reply helpful? Yes No
Verified answer

v-qiaqi@microsoft.com on at

Like (0)

Report
Hi @Wagemans_Frank,

To be honest, I don't get you.

Sorry that I could not reproduce this issue in my environment.

To do the calculation, we need to convert the data into number value, not sure how you format your date string in the Text column, however it is another workload to convert the text date string into date value, which costs a lot of time, I don't think this makes sense.

To be more efficient, you should create Date column saving date value and number column to save the days, and in Power Apps do the calculation thing, using the following formula to calculate the end date:

DateAdd(ThisItem.START, ThisItem.Days, Days)

Then Modify the formula as below:

If(Now() >= ThisItem.START&&Now() <= DateAdd(ThisItem.START, ThisItem.Days, Days),Color.Green,Color.Red)

Was this reply helpful? Yes No

Join the conversation