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.

supplier flow.pdf

Categories:

Building flows

I have the same question (0)

All responses (8)

Answers (1)

v-mengmli-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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
Copy link

Link copied!

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
Copy link

Link copied!

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 Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

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
Copy link

Link copied!

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
Copy link

Link copied!

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
Copy link

Link copied!

Happy to help if you can post them here

Was this reply helpful? Yes No
fyogaff 44 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No