Showing results for 
Search instead for 
Did you mean: 
Not applicable

Galery peculiarities

So I'm working on a gallery to read from an excel file. The idea is that when get a weekend day in the gallery, the "TemplateFill" turns grey with the following code.

<If(DayOfTheWeek.Text = "Saturday" || DayOfTheWeek.Text = "Sunday" , RGBA(100,100,100,100))/>

The issue is that this code is working for Saturdays, but not for Sundays.

However this code works fine:

<If( DayOfTheWeek.Text = "Saturday" || DayOfTheWeek.Text = "Friday" , RGBA(100,100,100,100))/>

<If( DayOfTheWeek.Text = "Saturday" || DayOfTheWeek.Text = "Monday" , RGBA(100,100,100,100))/>


If this makes any sense...

Can anyone help?


Super User
Super User

Hi @Anonymous 

It is possible that you have an extra space in the Sunday text. Try

If(DayOfTheWeek.Text = "Saturday" || Trim(DayOfTheWeek.Text) = "Sunday" , RGBA(100,100,100,100))

If that takes care of it, you have found your problem.


Not applicable

I do not. I have erased that and edited several times.


Helpful resources

UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Solution Authors
Top Kudoed Authors
Users online (2,970)