cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
BartHannah
Regular Visitor

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

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.

 

BartHannah_0-1599782651843.pngBartHannah_1-1599782690173.png

 

BartHannah_2-1599782738525.png

 

BartHannah_3-1599782826422.png

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.

BartHannah_4-1599782955322.png

 

1 ACCEPTED SOLUTION

Accepted Solutions
CFernandes
Super User
Super User

@BartHannah 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! 

View solution in original post

6 REPLIES 6
PrasadAthalye
Community Champion
Community Champion

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

 

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

Please Like and Mark this as Answer if it resolves your Issue.

Power Automate Community
CFernandes
Super User
Super User

@BartHannah 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! 

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. 

 

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

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

Helpful resources

Announcements
 WHAT’S NEXT AT MICROSOFT IGNITE 2022

WHAT’S NEXT AT MICROSOFT IGNITE 2022

Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.

Register for a Free Workshop.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

September Events 2022

Check out all of these events

Attend in person or online, there are incredible conferences and events happening all throughout the month of September.

Users online (2,679)