Creating Table, Create item from table in list, 'The template language function 'float' was invoked with a parameter that is not valid.

(0) Share

Report

Posted on by wonka1234

909 Super User 2024 Season 1

Hi,

I am trying to create item in my SP list from my Excel Table.

I am getting error msg -

Unable to process template language expressions in action 'Create_item' inputs at line '0' and column '0': 'The template language function 'float' was invoked with a parameter that is not valid. The value cannot be converted to the target type.'.

my column i am trying to input is a general column in the excel table, could have blank values or values like .45, or 8.0.

I am using this expression - float(items('Apply_to_each_3')?['2023_01_02'])

which is not really a date field, it is a number type in the SP list.

Please help!

All responses (2)

Answers (0)

ManishSolanki 15,085 Super User 2025 Season 1 on at

Like (1)

Report
Re: Creating Table, Create item from table in list, 'The template language function 'float' was invoked with a parameter that is not valid.

Hi @wonka1234

As the column could hold blank values so you need to handle the case for blank value as well. Pls try the below expression:

if(empty(items('Apply_to_each_3')?['2023_01_02']),null,float(items('Apply_to_each_3')?['2023_01_02']))

here, I am assuming that '2023_01_02' is the name of the column in excel. If not, then pls replace it with the name of column in excel table that holds decimal value.

If this helps & solves your problem, please remember to give a 👍 and accept my solution as it will help others in the future.

Thanks
wonka1234 909 Super User 2024 Season 1 on at

Like (0)

Report

Re: Creating Table, Create item from table in list, 'The template language function 'float' was invoked with a parameter that is not valid.

bump