"EXCEL - Get a row" action: Issue with number formatted as currency

[Eric6]

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

[v-litu-msft · Accepted solution]

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.