I have a flow in Power Automate that connects to an Excel table in SharePoint. One of the fields returned is a Price field, which contains only numerical data to 2dp.
Earlier in the flow I use List rows present in a table to query the table, skipping the first 2,500 rows and using the Date Time parameter to choose ISO 8601 formatting.
When I use Select to choose the fields from the table, I specify float for my price column to ensure it is numerical.
However, I am encountering a weird error where List rows present in a table action is treating the Price column as an ISO date rather than a number, causing the action to break as it cannot convert to a float.
Weirdly, this does not happen consistently. I have double checked the source and there is only numerical data in the column. There are some rows (e.g. TradeDate) that I do want to treat as datetime so I do not want to remove the datetime format completely. Given this error isn't consistent, I'm struggling to work out why it happens.
Has anyone encountered this issue before or know why it is happening / how it consistently fix it? I've included below a screenshot of the Price field in excel, a screenshot of the Raw Output from the List rows action (confirming the date time format), and the Flow up to Select.
