web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Creating Table, Create...
Power Automate
Unanswered

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

(0) ShareShare
ReportReport
Posted on by 920 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!

 

Categories:
I have the same question (0)
  • wonka1234 Profile Picture
    920 Super User 2024 Season 1 on at

    bump

  • ManishSolanki Profile Picture
    15,091 Super User 2025 Season 2 on at

    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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 522 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 364 Moderator

#3
abm abm Profile Picture

abm abm 243 Most Valuable Professional

Last 30 days Overall leaderboard