Switch with multiples columns

[IsraelJunior]

Hi Guys, i have a problem with my app. 

I need to change a color with each date. I have 3 columns with date and i have 1 gallery calendar i want to show 1 color if have value date. I can make its with 1 columns, but i have 3 columns to validation.

How can i do it?

First Picture is my gallery, second is my dataset

[v-bofeng-msft]

Hi @IsraelJunior ,

but i have 3 columns to validation

Could you please show me the rule?

Best Regards,

Bof

[IsraelJunior]

are 3 columns of date, my validation to show in the gallery is 

Filter('Calendário - Service Creation',
'Data Talks' = DateAdd(_firstDayInView, ThisItem.Value, TimeUnit.Days) ||
'Data SD1' = DateAdd(_firstDayInView, ThisItem.Value, TimeUnit.Days) ||
'Data SD2' = DateAdd(_firstDayInView, ThisItem.Value, TimeUnit.Days)
)

[IsraelJunior]

This is my gallery, and i have 1 ID with 3 dates, i want to change the color of boton if data 1 is 07/25, or data 2 is 06/26 etc.

[v-bofeng-msft]

Hi @IsraelJunior ,

You mentioned that  you can make its with 1 columns, could you please show me the button's Fill property ?

Best Regards,

Bof

[IsraelJunior]

i'm using this formula to filter the gallery 

Filter('Calendário - Service Creation',
'Data Talks' = DateAdd(_firstDayInView, ThisItem.Value, TimeUnit.Days) ||
'Data SD1' = DateAdd(_firstDayInView, ThisItem.Value, TimeUnit.Days) ||
'Data SD2' = DateAdd(_firstDayInView, ThisItem.Value, TimeUnit.Days)
)

And this formula in properties of buton

If(
ThisItem.'Data SD1' = _firstDayInView,
Color.DarkBlue,
If(
ThisItem.'Data SD2' = _firstDayInView,
Color.GreenYellow,
If(
ThisItem.'Data Talks' = _firstDayInView,
Color.Blue,
Color.BlueViolet
)
)
)

But its showing only blue violet

[v-bofeng-msft]

Hi @IsraelJunior ,

First, This issue is likely related to the time zone. What is the time zone of your SharePoint Site?

I think this link will help you a lot

Solved: Not able to capture current date and time in share... - Power Platform Community (microsoft....

Second, what is _firstDayInView's value? Is it a Datetime value? What is _firstDayInView's time?

Finally, This formula can be simpler

If(
     ThisItem.'Data SD1' = _firstDayInView,
     Color.DarkBlue,
     ThisItem.'Data SD2' = _firstDayInView,
     Color.GreenYellow,
     ThisItem.'Data Talks' = _firstDayInView,
     Color.BlueViolet
)

Best Regards,

Bof

[IsraelJunior]

I changed my columns to only date... i think my mistake is being on _firstDayInView, because _firstDayInView is showing 25/june, and i need compare with each date of month, how can do it?

[IsraelJunior]

I'm using "DateAdd(_firstDayInView,ThisItem.Value,TimeUnit.Days))" to check the day in the gallery