I am creating a flow where I parse CSV data. I have setup my CDS table with text fields, Date fields and Decimal fields. In testing I am able to load text and date fields without issue. For the number fields I'm using the float expression to convert the number from text to a number format. In CDS I have tried both Decimal and Floating as the format but they will not load using the float expression. If I test load the field to a text formatted column and remove the expression they load fine. Any thoughts on resolving the issue are appreciated. If necessary I will re-format my fields to text but would prefer to bring them in if the correct format.
Unable to process template language expressions in action 'Create_a_new_record' inputs at line '1' and column '21744': 'The template language function 'float' was invoked with a parameter that is not valid. The value cannot be converted to the target type.'.
Solved! Go to Solution.
You are correct, the issues was the blank records. I modified my expression to add an if condition. If the record is Empty write '0'. Once I did that I was able to eliminate the errors. Thanks.
Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!
Many congratulations to the Season 1 2021 Flownaut Crew!
Check out our new profile badges recognizing authored solutions!
Check out the community blog page where you can find valuable learning material from community and product team members!