Flow failed - possible date format

[fyogaff]

Hi, I am following a a you tube video and seem to be hitting a problem which I think could be a date format issue.  

I want to send an email out when a date is reached on an excel file.

I am in the UK.

The attachment shows the table, the flow and my formatting.  Any help would be appreciated.

[v-mengmli-msft]

Hi @fyogaff ,

Please check if you have selected ISO8601 format. If no, please select it and test again.

By default, the value of the date column is output as Serial Number, if we don't select ISO8601.

Another way is to check format of outputs of date column in outputs of "list rows present in a table".

Best regards,

Rimmon

[fyogaff]

I have tried with and without changing to ISO 8601 and it made no difference unfortunately.

[SanmeshG · Accepted solution]

what error does it give , I know it can't be trivial but I see no space between eq and the expression.

Can you send the error message?

[v-mengmli-msft]

Hi @fyogaff ,

Revisit your attached file. Please try to run with ISO8601 and modify the date format in expression to yyyy-MM-dd.

I recommend that you check the output format of this column, it may not be the dd/MM/yyyy in your expression.

Also, this is another Bad Request error, could you please provide details?

Best regards,

Rimmon

[fyogaff]

Hi, the error is:

"error": {

"message": "Syntax error at position 29 in 'RefresherDate eq' 2024/04/02''.\r\n inner exception: Syntax error at position 29 in 'RefresherDate eq' 2024/04/02''."

},

"source": "excelonline-ne.azconn-ne-003.p.azurewebsites.net"

}

[fyogaff]

You were correct.  I didn't have the space between the eq.  

Thanks.  Now I have other errors!

[SanmeshG]

Happy to help if you can post them here

[fyogaff]

Thanks for the offer.  I tried a different method and have it working now.