Hi,
I'm building a flow which first filters a dataverse table and applies a condition to check if todays date minus 60 days is the same as a date entered in the table when an assessment took place. If it is and email reminder is sent. What I would like to do is then update the dataverse table with the date the email is sent. However, each time I try I receive
{
"error": {
"code": "0x80060888",
"message": "Bad Request - Error in query syntax."
}
}
Here's a picture of the flow:
Within the "Update a row" I selected the table and the row ID to be updated and entered the following expression to capture the date: formatDateTime(convertFromUtc(utcNow(), 'Eastern Standard Time'), 'yyyy-MM-dd').
The inputs are correct but the error appears on the outputs. Any ideas how I can resolve?
