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

Date Formatting between Forms, Lists and Power Automate

I've created a survey in Forms to gather info and populate a corresponding List.  The flow keeps failing because of a date format mismatch.  

Here's the flow error:

The 'inputs.parameters' of workflow operation 'Create_item' of type 'OpenApiConnection' is not valid. Error details: Input parameter 'item/Datetotransfer' is required to be of type 'String/date'. The runtime value '""' to be converted doesn't have the expected format 'String/date'.

 

I haven't been able to correct this by changing settings of the Form or the List.  

What's the best method for changing the date format?  Should it be done by customizing the column formatting of the List or would it be better accomplished in the Flow itself?

1 ACCEPTED SOLUTION

Accepted Solutions
DamoBird365
Community Champion
Community Champion

Hi @68horn 

 

If using the date picker on the MS Form, you can use the function formatdatetime as follows:

 

formatDateTime(outputs('Get_response_details')?['body/r953ff8a619234050811ef13d52d37ad0'],'dd/MM/yyyy')
 
Build this up using the expression builder.
 

View solution in original post

1 REPLY 1
DamoBird365
Community Champion
Community Champion

Hi @68horn 

 

If using the date picker on the MS Form, you can use the function formatdatetime as follows:

 

formatDateTime(outputs('Get_response_details')?['body/r953ff8a619234050811ef13d52d37ad0'],'dd/MM/yyyy')
 
Build this up using the expression builder.
 

View solution in original post

Helpful resources

Announcements
MPA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Are Your Ready?

Test your skills now with the Cloud Skill Challenge.

Top Solution Authors
Users online (74,937)