cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

Powerapps Flow date to SharePoint date column

Hi all,

 

I have a SharePoint list, powerapps and a flow. I have a button in my powerapp that triggers a (create item in list) flow - the flow takes the date from the date picker in my app (dd:mm:yyyy), and creates an item in my list. 

 

The list uses a date column, which is set to show date only and displays as (dd:mm:yyyy). 

 

The date picker in my app uses the same format (dd:mm:yyyy)

 

However, the flow fails with the message "String was not recognized as a valid DateTime."

 

Even though the failure message shows it got the correct start and end date, with the correct format, from my date pickers.

 

Any help would be greatly appreciated.

2 REPLIES 2
Highlighted
Frequent Visitor

Re: Powerapps Flow date to SharePoint date column

I have also tried to add a compose: 

formatdatetime(triggerBody()['Createitem_StartDate'] ,'dd-MM-yyyyThh:mm:ss')

 

but I get an error "Unable to process template language expressions in action 'Compose' inputs at line '1' and column '2238': 'In function 'formatdatetime', the value provided for date time string '19/12/2019' was not valid. The datetime string must match ISO 8601 format.'."

Highlighted
Community Support
Community Support

Re: Powerapps Flow date to SharePoint date column

Hi @AB4N ,

 

Could you share the run code in PowerApps?

I have made a test, it can work fine. Please check:

Snipaste_2019-12-19_18-29-24.png

Snipaste_2019-12-19_18-27-26.pngSnipaste_2019-12-19_18-28-28.png

Sik

Helpful resources

Announcements
August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

secondImage

Return to Workplace

Reopen responsibly, monitor intelligently, and protect continuously with solutions for a safer work environment.

secondImage

Super Users Coming in August

We are excited for the next Super User season.

secondImage

Community User Group Member Badges

FIll out a quick form to claim your community user group member badge today!

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (8,141)