Flow failed - possible date format

(0) Share

Report

Posted on by 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.

Categories:

Building flows

supplier flow.pdf

I have the same question (0)

All responses (8)

Answers (1)

v-mengmli-msft on at

Like (0)

Report

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

Was this reply helpful? Yes No
fyogaff 44 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Verified answer

SanmeshG 1,947 Moderator on at

Like (0)

Report

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?

Was this reply helpful? Yes No
v-mengmli-msft on at

Like (1)

Report

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

Was this reply helpful? Yes No
fyogaff 44 on at

Like (0)

Report

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"
}

Was this reply helpful? Yes No
fyogaff 44 on at

Like (0)

Report

You were correct. I didn't have the space between the eq.
Thanks. Now I have other errors!

Was this reply helpful? Yes No
SanmeshG 1,947 Moderator on at

Like (0)

Report

Happy to help if you can post them here

Was this reply helpful? Yes No
fyogaff 44 on at

Like (0)

Report

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

Was this reply helpful? Yes No