Skip to main content
Nintex Community Menu Bar

Hello

I have a Nintex workflow which Query List to retrieve all Active Reminders and then for each ID of the Reminders it sends an email notification.

Every time i run the workflow i have an error: Coercion Failed: Unable to transform the input lookup data into the requested type.

However if i run the Query List alone, it works fine (and store all variables in Collection). Knowing that the Query List filter the items having the field called "Next Reminder" to be between the 2 date ranges of this Reminder.

So if "Next Reminder" is between "Reminder Date From" and "Reminder Date To" > Send Notification.

If i go to the items and remove all values inside the "Next Reminder" field, the workflow works fine.

Workflow attached.

I appreciate your help.

@Victor_fares I would suggest to log to history all actions to determine what is exactly causing the error and narrow down the issue.


coercion error when comparing date values, seems to be wrong typs (string instead of date)



 



check this


Reply