Power Platform Community Forum Thread Details

I built an app from different parts...like a Frankenstein...with a great help of some users from here.

It works fine when the iPhone language is set in English, but when I switch language to Spanish don´t work as should be.

SPO List

In English. the days selected previously in yellow, holidays in purple. Works fine!

In Spanish language doesn´t show any days selected previously.

Here the code:

APP START

ForAll(
TimeSheet,
If(
Title = Label4.Text ,
Collect(
DaysToStore,
AddColumns(
FirstN(
[0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,31,31,32],
DateDiff(Startdate,EndDate,Days)+1),
"Day",
"Day " & (Value + 1),
"Date",
DateAdd(Startdate, Value, Days),
"Items",Item
)
)
));

ClearCollect(
DaysFinal,
ForAll (
DaysToStore,

{
StartDate1:
DateValue(
Text(
Date,
DateTimeFormat.ShortDate )),
Item1:Items,
DiaName:
Text(Date, "[$-en-US]dddd" ,"es-US")

}
)
)

SCREEN ONVISIBLE

If(!_initialized,
UpdateContext({_today:Today()});
UpdateContext({_firstDayOfMonth:DateAdd(_today,1-Day(_today),Days)});
UpdateContext({_firstDayInView:DateAdd(_firstDayOfMonth,-(Mod(Weekday(_firstDayOfMonth)-2,7)+1),Days)});
UpdateContext({_holidays:Table({HolidayDate:Date(2020,01,01)},
{HolidayDate:Date(2020,04,10)},
{HolidayDate:Date(2020,05,01)},
{HolidayDate:Date(2020,05,21)},
{HolidayDate:Date(2020,06,29)},
{HolidayDate:Date(2020,07,16)},
{HolidayDate:Date(2020,09,18)},
{HolidayDate:Date(2020,09,19)},
{HolidayDate:Date(2020,10,12)},
{HolidayDate:Date(2020,10,31)},
{HolidayDate:Date(2020,11,01)},
{HolidayDate:Date(2020,12,08)},
{HolidayDate:Date(2020,12,25)}
)
});
UpdateContext({circleEvents:Table({Eventos:DaysFinal.Item1})});
UpdateContext({_initialized:true})

);

GALLERY
ICON name CIRCLE EVENTS
FILL:
Switch(
LookUp(
DaysFinal,
Concatenate(Text(Month(_firstDayOfMonth)),"/",
Text(
Day(
DateAdd(
_firstDayInView,
ThisItem.Value,
Days
)
)
) ,

"/",
Text(Year(_firstDayOfMonth))
) = Text(StartDate1)
).Item1,
"Vacations",
RGBA( 138, 43, 226, 1),
"Work",
RGBA(255, 215, 0, 1 ),
"Work travel",
RGBA(0, 255, 255, 1),
"Days in Lieu Taken",
RGBA(255, 165, 0, 1),
RGBA(0, 0, 0, 0 )
)