Date picker - convert Javascript date from milliseconds to dd/mm/yyyy

(0) Share

Report

Posted on by Treboro

Hi, new to the forum and to Powerapps. I'm trying to patch a date picker selection to a Sharepoint list, using:

Patch( 'Sharepoint list', ThisItem, {Deletion:Value(dateDeletion.Value)})

So I just get the Javascript date in milliseconds on the Sharepoint list field. However, I've also tried dateDeletion.Value with .Date("dd/mm/yyyy"), getDate, Date.ToString() and Powerapps doesn't like any of them. Have also tried using dateDeletion.SelectedDate. Sorry in advance if I'm missing something basic here, though I'm still quite new to this.

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

TheRobRush 11,128 Moderator on at

Like (0)

Report
Firstly, check the settigns of your date column sharepoint and make sure it is set to Date Only

Set both of these to No

then try this

Text(DatePicker1.SelectedDate,"dd/mm/yyyy")

if you need it in that specific format (change datepicker1 to name of your datepicker)

Or simply

DateValue(DatePicker1.SelectedDate)

for modern control version these will be

Text(DatePickerCanvas1.Value, "dd/mm/yyyy")

and

DateValue(DatePickerCanvas1.Value)

Was this reply helpful? Yes No
Treboro 7 on at

Like (0)

Report

Thanks, changed Sharepoint column settings. However, I'm using a modern control datepicker, tried with {Deletion:Value(Text(dateDeletion.Value,"dd/mm/yy"))}
and get 'requested operation is invalid'

Was this reply helpful? Yes No
TheRobRush 11,128 Moderator on at

Like (1)

Report
should only need be

{Deletion:dateDeletion.Value}

sharepoint will automatically store it in the format it wants, as for displaying it later in your specific format you would do that app side with the Text(SharePointListName.SharepointDateColumnName, "dd/mm/yy")

Was this reply helpful? Yes No
Verified answer

TheRobRush 11,128 Moderator on at

Like (0)

Report

@Treboro has your issue been resolved? If so don't forget to mark an answer as the solution so others can find answers if they also experience the same issue.

Was this reply helpful? Yes No