Answered

Dates selected on a date picker on mobile are incorrect when patched to SharePoint

(0) Share

Report

Posted on by emsleyd

Hi,

Please be kind this is my first post and I did have a little search 🙂

I've created a Power App for a client to allow their employees to request holiday.

When dates are selected and patched (whilst on a desktop) the dates that appear on my SharePoint list match those selected in the app.
When dates are selected and patched (whilst on a phone via the Power Apps app) the dates that appear on my SharePoint list differ wildly to those selected in the app. There doesn't appear to be any pattern; sometimes the dates that appear in SharePoint can differ by 500+ days to the days selected on the date picker.

Any ideas as to why this might be?

Many thanks!

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (1)

Sort by

SpongYe 5,721 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!
hi @emsleyd

Maybe try a datetime format:
Text(DateTimeValue(Now()), "mm/dd/yyyy hh:mm AM/PM", "en-US")

You didn't post any code so I assume there isn't any formatting yet.

Please also heck this article: https://powerusers.microsoft.com/t5/Building-Power-Apps/DatePicker-date-writes-a-2-year-in-advance-date-into-SharePoint/m-p/119939#M42339

-----------------------
PowerYsa Power Platform Enthusiast [LinkedIn] | [Youtube]

I love to share my knowledge and learn from others. If you find my posts helpful, please give them a thumbs up 👍 or mark them as a solution ✔️. You can also check out my [@PowerYSA] for some cool solutions and insights. Feel free to connect with me on any of the platforms above. Cheers! 🍻

Was this reply helpful? Yes No
emsleyd on at

Like (0)

Report
Copy link

Link copied!
Hi @SpongYe

Thank you for the reply.

This is my current format:
DateTimeValue( Text('dpFrom FDRS'.SelectedDate, "[$-en-GB]mm/dd/yyyy") & " " & FDStartColumn),

The code for FDStartColumn is:

Set( FDStartColumn, Switch( FromDayOfWeek, 2, Text(LookUp('Holiday Data', Title = SelectedUser).MonStart, "[$-en-GB]hh:mm"), 3, Text(LookUp('Holiday Data', Title = SelectedUser).TuesStartCalc, "[$-en-GB]hh:mm"), 4, Text(LookUp('Holiday Data', Title = SelectedUser).WedStartCalc, "[$-en-GB]hh:mm"), 5, Text(LookUp('Holiday Data', Title = SelectedUser).ThursStartCalc, "[$-en-GB]hh:mm"), 6, Text(LookUp('Holiday Data', Title = SelectedUser).FriStartCalc, "[$-en-GB]hh:mm") ) );

I tried using "DateTimeFormat.ShortDateTime24" as per the article you linked but this threw an error in the mobile version; stating the From column was required. It worked fine on the Desktop version though.

I changed the "Date Time Zone" on my Date Picker from Local to UTC which improved things, the date was only out by one day but the difference between UTC and my Local time is only 1 hour.

Still stumped 😟

Was this reply helpful? Yes No
emsleyd on at

Like (0)

Report
Copy link

Link copied!
ok, i'm not entirely sure how but I have both showing the same date; except Desktop is formatted mm/dd/yyyy and Mobile dd/mm/yyyy.

I want both to show as dd/mm/yyyy however if I change the format in the below from mm/dd to dd/mm then the formats of the Desktop and Mobile dates just swap in SharePoint.
DateTimeValue( Text('dpFrom FDRS'.SelectedDate, "[$-en-GB]mm/dd/yyyy") & " " & FDStartColumn),
.

Was this reply helpful? Yes No
PowerGirl 130 on at

Like (0)

Report
Copy link

Link copied!

What is the column type in your SharePoint list? If it is date time it should work automatically. If it is a single line text you will face the error when the dates are configured for different regions in different devices.

Was this reply helpful? Yes No
emsleyd on at

Like (0)

Report
Copy link

Link copied!

I'm using SharePoint classic as the list in question is a view of a SharePoint Calendar. It has to be classic to link to Outlook. My From column is of type Date and Time however there is no formatting. I've attempted to add JSON formatting but as of yet to no avail.

I've tried a number of different versions of the below but the same items always error:

All my Date Pickers are formatted as below:

I've seen on other threads that populating the Language fields resolved the issue but I have attempted this with "EN-GB" and its made no difference.

Was this reply helpful? Yes No
Verified answer

emsleyd on at

Like (1)

Report
Copy link

Link copied!

I've worked it out. The solution in the end was to delete the date formatting from the From and To fields in the Patch

Was this reply helpful? Yes No