cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
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.

Highlighted
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
Users Online
Currently online: 340 members 6,013 guests
Recent signins:
Please welcome our newest community members: