web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Automate InvalidTemplate. Unabl...

Power Automate

Unanswered

InvalidTemplate. Unable to process template language expressions in action 'Set_variable_12' 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.'.

(0) Share

Report

Report

Posted on by Muneeb

8

I am trying to perform this operation " if(contains(item()?['Uom'],'MM'),item()?['Width Item'],mul(float(item()?['Width Item']),10))"

inside 'Select' to map excel into new columns but i am getting this error. can you please guide me what am i doing wrong?

Categories:

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (0)

CU-18081211-6 9,270 Moderator on at

Like (0)

Report
Copy link

Link copied!
@Muneeb ,

The most frequent cause of this error is that you are using , to separate the whole number from the fractional part and PowerAutomate knows only about decimal point doing that.

So you need to replace the , with .

if( contains(item()?['Uom'],'MM'), item()?['Width Item'], mul( float(replace(item()?['Width Item'],',','.')), 10 ) )

Try this approach to see if is working.

Was this reply helpful? Yes No
Muneeb 8 on at

Like (0)

Report
Copy link

Link copied!

@gabibalaban I am not trying to separate the whole number from the fractional part. I am only trying to multiply the value of my column by 10 but after narrowing down the issue I came to a conclusion that my column name is causing the issue.
for example
One of my columns is:
LPTT Per SUOM- CS\n(w/o VAT)
and I am using concat in my select expression but it is still not reading the value of the column and giving me null. I have used all short of concat variations this being the last but nothing worked.
item()?[concat('LPTT Per SUOM- CS','\','n','(','w', '/', 'o VAT',')')]

Is there a way to rename my columns, I am reading an excel file from sharepoint or maybe change them while mapping in the Select operation.

Was this reply helpful? Yes No

Join the conversation