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?
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.
I do not. I have erased that and edited several times.
Check out new user group experience and if you are a leader please create your group
Did you miss the call?? Check out the Power Apps Community Call here!
See the latest Power Apps innovations, updates, and demos from the Microsoft Business Applications Launch Event.
User | Count |
---|---|
267 | |
221 | |
76 | |
38 | |
36 |
User | Count |
---|---|
339 | |
223 | |
124 | |
72 | |
56 |