Many Hours difference between data value in field in sharepoint list and being it displayed in Power Apps

[francescjp]

Hello:

I have one column in a Sharepoint list where I store datetime.

When I show to use it in PowerApps the hour is not correct. There are a lot of hours of difference.

In the sharepoint list I have this value: 7/5/2024 12:00

In PowerApps is showed: 07/05/2024 21:00

I store this datetime (Datetime column in Sharepoint) in a collection before print it. Here is the code:

ClearCollect(
colEsdevenimentsUsuari;
Filter(
//Canviar d'aqui 50 anys 🙂 :), per evitar avís delegació
FirstN(Esdeveniments; 10000);
DateAdd('Data i Hora Inici'; -1; TimeUnit.Hours) > Now()
)
);;

Set(numeroInicii;First(colEsdevenimentsUsuari).'Data i Hora Inici');;

I have also used this code and time is still wrong:
Set(numeroFi;DateAdd(First(colEsdevenimentsUsuari).'Data i Hora Inici'); -TimeZoneOffset(First(colEsdevenimentsUsuari).'Data i Hora Inici')); TimeUnit.Minutes));;

When I print numeroInicii on a label this value is shown:

07/05/2024 21:00

Sharepoint list only have one record. I use only one record to avoid confusion by the time.
Anyone knows why it happens?
Thank you very much.

[mmbr1606]

hey @francescjp 

can u try this:

ClearCollect(
    colEsdevenimentsUsuari,
    Filter(
        FirstN(Esdeveniments, 10000),
        DateAdd('Data i Hora Inici', TimeZoneOffset('Data i Hora Inici'), TimeUnit.Minutes) > Now()
    )
);

Set(
    numeroInicii,
    DateAdd(
        First(colEsdevenimentsUsuari).'Data i Hora Inici',
        TimeZoneOffset(First(colEsdevenimentsUsuari).'Data i Hora Inici'),
        TimeUnit.Minutes
    )
);

Let me know if my answer helped solving your issue.

If it did please accept as solution and give it a thumbs up so we can help others in the community.



Greetings

[francescjp]

Hello @mmbr1606 :

Following your code there are still 7 hours of difference between date stored in Sharepoint and date viewed in PowerApps.

Somewhere there is a timezone configuration set to 7 plus hours. I have to discover where it is applied and change it.

Thank you very much for your help.

[francescjp · Accepted solution]

Hello:

I have found the problem . It was the timezone configuration of the site that list belongs to.

See attached image where you can see the problem. I have changed it to the correct timezone and works perfect.

Very important!!! After changed timezone (see image) you have to delete and create again the datetime columns in order they apply changes. If you have data on list remember export data to file before doing anything and import later checking if dates are shown correctly. If not, change datetimes in file and import again. All future new records will have correct datetime.

Have a nice day.