You’re offline. This is a read only version of the page.
Announcements
Hi everyone,
I need to create a validator in Power Automate. All my numeric values in an Excel file are supposed to be separated by commas (e.g., 19,20 or 200,02), but sometimes the file comes with numbers using a dot as the decimal separator instead (e.g., 19.20 or 200.02).
Whenever that happens, I want to send an alert email to the team.
My problem is: when I use the "List rows present in a table" action, Power Automate automatically converts all number values to dot (.) format — even if the original Excel cell uses a comma. I need to read the value exactly as it appears in the Excel file, without any automatic formatting or conversion.
My system only accepts numbers with a comma separator, so I need a way to detect when dots are used instead and trigger a warning flow.
Is there any way to force Power Automate to read the raw value (or to treat the column as text) so that I can perform this validation correctly?
Thanks in advance!
How is my table:
Share
Report
All responses (
Answers (
8,479
