I have a logic app that lists rows in a table which contains exchange rates. The numbers have a max of 5 places after the decimal. The issue that I have is that when the number has 4 zeros after the decimal and then a number this does not return a number to the logic app.
EG if the number is 0.00006 the returned value is 6E-05 where 6 always equals the last number i.e. if the number was 0.00007 the retuned value is 7E-05. The obvious work around to this is to run it through a formula which fixes the number but I feel that this is a work around rather than a proper solution. I've tried formatting the number in the excel table as text, general and even with more decimals but nothing seems to work.
Any ideas?