cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper III
Helper III

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?

 

2 REPLIES 2
Highlighted
Super User
Super User

Re: Galery peculiarities

Hi @TiagoRuivo 

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.

 

Highlighted
Helper III
Helper III

Re: Galery peculiarities

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

 

Helpful resources

Announcements
August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

secondImage

Return to Workplace

Reopen responsibly, monitor intelligently, and protect continuously with solutions for a safer work environment.

secondImage

Super Users Coming in August

We are excited for the next Super User season.

secondImage

Community User Group Member Badges

FIll out a quick form to claim your community user group member badge today!

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (8,101)