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"
Well, now there's only errors.
Is there a way to extract the text of an "error" cell. Because the very first step (source) is filled with errors.
Thank you
You can, but is that what you want to do?
You can add a new column with:
let val = try [DateColumn]
in if val[HasError] then val[Error][Message] else val[Value]
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.