Date Error in Flow

[SimonY]

Hi everyone,

I have used a templated flow to pull data  from a form into an SP list. All dates are formatted correctly and are not mandatory. However I still keep getting a failure on my flow with this message

All Site settings are English Australia and same for Region.

Any ideas on what the issue could be caused by?

[v-alzhan-msft]

Hi @SimonY ,

Could you please share a full screenshot of the configuration of your flow?

I have made a test on my side and couldn't reproduce the issue, could you please explain more details of your flow and the "Create item" action? Have you add any expression in the "Create item" action for the date?

Does all the Date columns have value in the form response? Could you please take a try to add date to all the Date columns to see if the flow could run successfully?

Best regards,

Alice       

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[SimonY]

Hi Alice,

Entering date data in all fields worked. I ran it again without filling all fields and it failed. Not all dates are mandatory and date details on list are set as image below. 

I have branching to skip some sections, including the insurance questions based on a no response, and nothing else is configured in the background. 

The blank fields are where the dynamic content will not show in the config flow creation? And I don't get a 'see more option' when selected to add them from my form?

Really appreciate the help :0)

My config is below;

OHS Form Flow Config 1

OHS Form Flow Config 2

OHS Form Flow Config 3

[v-alzhan-msft · Accepted solution]

Hi @SimonY ,

There is no easy way to troubleshoot your problem, I would suggest for two solutions:

1. Create a new sharepoint list and then create a new flow to see if the issue still exists.

2. Leave the Date column blank from the form response and run the flow, check out which column caused the issue, then delete and recreate the column to see if the issue still exist.

Best regards,

Alice       

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[SimonY]

Hi @v-alzhan-msft 

I think your right I will need to create a new list.

I have done a little test (new form new list and 3 date fields, two required one not) and get some interesting format change showing in data being pushed from a simple form. See Date sent and Date reported below. Both are identical in the list and only Date Reported is required in the list.

Thanks for the help too.