Filter Errors of Parse JSON Before Creating SharePoint Items

(0) Share

Report

Posted on by probey82

I have a flow that takes a CSV from an email attachment and adds the rows to a SharePoint List.. It works very well and is based on this example.

It recently experienced an error because one of the rows had missing/incomplete data which didn't match the expected format, giving me this error:

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

Using the error above, I would like to filter out any future items where the value for the date is "False". This is the exact item from the JSON schema that gave the error:

"Date": "False",

I tried adding a Filter Array after the Parse JSON and before the Apply to Each-Create Item, but that didn't remove the offending line.

All responses (2)

Answers (0)

probey82 10 on at

Like (0)

Report

Re: Filter Errors of Parse JSON Before Creating SharePoint Items

@Sundeep_Malik I hoped it would help, but I'm getting the exact same error message.

Looks like it's not really Boolean, but just the word "False".
Sundeep_Malik 6,482 on at

Like (0)

Report

Re: Filter Errors of Parse JSON Before Creating SharePoint Items

Hey @probey82
Try this:
In the type of date in parse json write something like this:
"type":["string","boolean"]
Hopefully this helps.