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.
Hi @Shippen70 ,
Could it be possible that your input string is empty or null , if so then you have to use condition to bypass null or empty string and set it to 0 if found .
Thanks
Hi @Shippen70 ,
Could it be possible that your input string is empty or null , if so then you have to use condition to bypass null or empty string and set it to 0 if found .
Thanks
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!
User | Count |
---|---|
85 | |
57 | |
42 | |
37 | |
33 |
User | Count |
---|---|
91 | |
73 | |
72 | |
60 | |
40 |