Answered

CSV data import to CDS as Decimal Number

(0) Share

Report

Posted on by Shippen70

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.

float(items('Apply_to_each')?['txtLoadHrsBucket1'])

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.'.

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

MJain 2,450 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Shippen70 27 on at

Like (0)

Report

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.

if(empty(items('Apply_to_each')?['txtCapacityBucket1']),'0',formatnumber(float(items('Apply_to_each')?['txtCapacityBucket1']),'f'))

Was this reply helpful? Yes No