You’re offline. This is a read only version of the page.
Announcements
118
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
Hi @Eric6,
I tried to repeat your issue on my side and I found if set the column to currency format, then use Get a row action to extract content of the Excel row, the sign "$" could display in the Excel table, and flow wouldn't recognize the "$47,872.25" to date, please refer to the following screenshot:
You could have a try, if your problem still exists, please attach your Flow screenshot:
Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Share
Report
All responses (
Answers (
