I have an excel table of about 3000 rows that I need to group to about 200 people and email the HTML table to individuals and show only the rows applicable to them. I have managed to create this however there are two columns which are showing correctly in excel but not in the email table, one is for percentage and the other currency. I've read many suggestions, forums and watched many youtube videos and amended my flow with these suggestions, my flow now looks nothing like it did and the error remains. It has not converted either column. sometimes I get an Int error, other times a parameter error. This is what my flow now looks like.
This is the error I am currently getting
The execution of template action 'Create_HTML_table' failed. The column values could not be evaluated: 'The template language function 'formatNumber' expects its first parameter to be an integer or a decimal number. The provided value is of type 'Object'.
Please help, I am going out of my mind


Report
All responses (
Answers (