Patch function not working properly on Phone.

[thomaspp]

Hi all,

I've created a time registration function that allows the user to register the time with one push of a button.

The OnSelect property is set to:

Patch(
    TimeData,
    LookUp(
        TimeData,
        Day = DataCardValue35_1.Text And Line = "Blister" And BatchNo = DataCardValue29_1.Text
    ),
    {PrepOperStart: DateTimeValue(Text(Now(), "yyyy mm dd hh:mm"))}
)

This works well on the desktop! But not on the iPhone..?!
Sometimes it appears as if it's executing the function but nothing gets patched to the data source. The data source is a Sharepoint List.

However I also created a manual input option where the user can register the datetime to the same field using a standard EditForm control instead. It works on both desktop and iPhone!

What could be the cause for this issue with Patch()?

Best regards,

[thomaspp · Accepted solution]

Sorry, I found the answer after a couple if hours of trial and error.'

Apparent iOS doesn't recognize this time format 

DateTimeValue(Text(Now(), "yyyy mm dd hh:mm"))

so I changed it to "Now()"...
Shows you the importance of testing on various devices.

[v-chenzhi]

Hi @thomaspp ,

Thanks for sharing!

I haven't considered the limitations of iOS before. I tried this and it worked.

DateTimeValue(Text(Now(), "yyyy/mm/dd hh:mm"))

I need to know more about this restriction, please mark your post as a solution so help others find it more readily.

Thanks again for sharing!

Best Regards,

Zhi Chen