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 III
Super User III

@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
Super User
Super User

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 III
Super User III

@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

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
MPA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

V3_PVA CAmpaign Carousel.png

Community Challenge - Giveaways!

Participate in the Power Virtual Agents Community Challenge

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

R2 (Green) 768 x 460px.png

Microsoft Dynamics 365 & Power Platform User Professionals

DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.

Top Solution Authors
Users online (1,661)