cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Kepcla
Helper I
Helper I

Calendar issues in different language

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

Kepcla_1-1600980854849.png

 

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

Kepcla_0-1600980785337.png

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

Kepcla_2-1600980926031.png

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 )
)

 

Kepcla_3-1600981230402.png

 

I tried everything, but no luck! 

Appreciate any help...

0 REPLIES 0

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Carousel_PP_768x460_Wave2 (1).png

2022 Release Wave 2 Plan

Power Platform release plan for the 2022 release wave 2 describes all new features releasing from October 2022 through March 2023.

365 EduCon 768x460.png

Microsoft 365 EduCon

Join us for two optional days of workshops and a 3-day conference, you can choose from over 130 sessions in multiple tracks and 25 workshops.

Top Solution Authors
Users online (4,904)