Forum Discussion
Two timezone in the same column from the same source
Isn't this what you wanted? The error message text extracted out?
If you also want the details, you can change [Message] to [Detail]. Note that [Detail] is not a string, it is a record.
If your refering to my first post, I think I had a minor bug... just change
"DD-MM-YYYY"to
"DD/MM/YYYY"
Isn't this what you wanted? The error message text extracted out?
If you also want the details, you can change [Message] to [Detail]. Note that [Detail] is not a string, it is a record.
If your refering to my first post, I think I had a minor bug... just change
"DD-MM-YYYY"to
"DD/MM/YYYY"
"If you also want the details, you can change [Message] to [Detail]. Note that [Detail] is not a string, it is a record."
It is perfect artemus ! It's working!
The only thing is that the dates that weren't "errors" are still random. But, at this point, I suspect that the problem is SharePoint, and not necessarily the timezone in PowerQuery.