Update SharePoint List Numeric fields from Excel table, and help using Dynamic Content/Expression?

[Anonymous]

Hello,

Power Automate newbie here...so bear with me.  I am trying to update a SharePoint List from a Excel table and both have numeric columns defined, 3 are Currency and 1 is an Integer.  The Flow below works great for adding records with the text fields but I'm having trouble trying to set the numeric fields in the SP list equal to the incoming numeric fields from Excel Table.  I'm assuming the numeric Excel fields are coming into Power Automate as Text and the Power Apps 'Create Item' routine wants a numeric value.  So, I'm trying to convert the incoming text fields with a 'float' command to a numeric variable and then set the output SP list field to the variable.  I can't get it to work and hopefully there is an easy way to do this.

The DealerSpend is just the first field I was trying to convert...Thanks in advance for your help.

I've tried numerous incorrect ways to reference the field in the float function but can't get past this error or version of it.

[PrasadAthalye]

I think you need another bracket for float function around the expression.

float(('table1'0......)

[CFernandes · Accepted solution]

@Anonymous As mentioned by @PrasadAthalye please check the syntax, with reference to your screenshot a bracket is missing.

I also assume that you have the set operator inside the 'Apply to each loop' so you try to update the formula to 

float(items('Apply_to_each')?['<YOUR COLUMN NAME'])

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS! 

[Anonymous]

The extra bracket threw 'invalid syntax' error...(could be pilot error) so I tried the solution from @CFernandes C and that worked inside the loop. 

[CFernandes]

Hey @Anonymous, I am glad that your problem has resolved 🙂

[Anonymous]

float(items('Apply_to_each')?['DealerSpend']) - worked great and did not need variables.  Thank You!