Hi,
In a flow I am using the "Get a row" action on a table in an EXCEL Online file. This works well for all columns except for one column that is a numerical field formatted as "Currency" (with a dollar sign and 2 decimals, negatives in brackets and red).
This field is interpreted as a date string in the Output of "Get a row".
The field is imported like this:
"Amount in $":"2029-04-02T03:52:18.286Z"
In the file it is displayed like this: "'$47,872.25", while it is really only the value 47,872.25 when looking at the cell content.
How can I ensure that this field gets interpreted as a number rather than a date? I'm thinking about formatting it as a number, not a currency, but I'm not the main owner and it may help the owner to see the "$" sign in this column and the naked number only in the local currency column. So ideally I would leave the formatting as it is.
Best regards,
Erik

Report
All responses (
Answers (