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.