cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Steelman70
Level 10

Updating date field to SharePoint list?

Hi, I cannot get a date picker to work in an edit form to update a date in a SharePoint list.

Just setting the update to the straight value of the date picker does not seem to work.  Does any formatting need to happen?

Could if be because I am in a European locale?

4 REPLIES 4

Re: Updating date field to SharePoint list?

Hi,

 

I guess this is an actual limitation that must be fixed. PowerApps doesn't like fields like people picker ou date picker

Matthieu Megaly
mlenhardt
Level: Powered On

Re: Updating date field to SharePoint list?

I currently encounter the same issue. 

 

I'm just trying to the date from the date picker to a field in an excel sheet.

 

This only writes numbers like '1466719200000' into the field and I have no idea how to convert it properly.

 

Tried also to change the Datafield.Update value to something like Text(DatePicker1.SelectedDate, "dd/mm/yyyy"), but this returns only zero in the list.

 

I'm also on European (German) locale.

naredie87
Level: Powered On

Re: Updating date field to SharePoint list?

You can use for example:

 

Text( yourDateVariable, "mm/dd/yyyy" ) 

DannyG
Level: Power Up

Re: Updating date field to SharePoint list?

Hi there,

 

@Steelman70 could you post the syntax you have entered? 🙂

Regards,
Dan

 

Helpful resources

Announcements
thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

Top Kudoed Authors (Last 30 Days)
Users online (5,317)