cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
MarioA43
Helper I
Helper I

Flow pulling numbers as strings from excel table

Hello everybody!

 

So, i've been working on a project for some time and built a flow that is supposed to do the following:

 

1)gets some information from AI builder, because AI builder treats everything as text, so the flow gets these string values.

 

2)throw these values into a table in excel where they're formatted as numbers.

 

3)proceeds to pull the values in the correct format and input them in a list in sharepoint.

 

However, when the flow get the values from AI builder and place them in the sharepoint list, despite the values being considered numbers within excel (=isnumber outputs "TRUE"), the flow pulls them out as a String, one which can't be converted to float using expressions( Have tried). so i'd like to know if anyone can help me identify:

 

1)why does the workflow pulls out the values as Strings despite they being classified as numbers within excel.

 

2)If there's any other method to convert these values from strings to floats.

 

P.S. The values are accounting numbers that follow the format 99.999,99 so i believe the dots and commas prevent the conversion from string to float.

 

Thanks in advance!

 

Problem images below:

 

1.Trigger and basis.

image1.PNG

2. the error.

Picture2.png

1 ACCEPTED SOLUTION

Accepted Solutions
MarioA43
Helper I
Helper I

Well, turns out it is some kind of bug with the excel for business connector, i found a way around it.

in case someone is interested, the Value pulled from the excel for business is classified as a String, and what i did was, i created another column in the sheet with a =Value() formula that pick up the "String" that is considered a number and turns it into a number one more time (Yes, i "converted" it into itself), in that way the value pulled by Power automate is able to be converted to a float(couldn't be done before due to the commas and dots in the string).

Pic of the solution working:

1. "converting" the number into itself

image1.PNG

2.turning it into a float.

image1.PNGPicture2.png

and voila! the numbers are converted into floats and are ready to be input into a sharepoint list!

View solution in original post

2 REPLIES 2
MarioA43
Helper I
Helper I

Well, turns out it is some kind of bug with the excel for business connector, i found a way around it.

in case someone is interested, the Value pulled from the excel for business is classified as a String, and what i did was, i created another column in the sheet with a =Value() formula that pick up the "String" that is considered a number and turns it into a number one more time (Yes, i "converted" it into itself), in that way the value pulled by Power automate is able to be converted to a float(couldn't be done before due to the commas and dots in the string).

Pic of the solution working:

1. "converting" the number into itself

image1.PNG

2.turning it into a float.

image1.PNGPicture2.png

and voila! the numbers are converted into floats and are ready to be input into a sharepoint list!

View solution in original post

alrez
Community Support
Community Support

Hi,

 

Thanks for your follow up post! I am glad that you were able to discover a workaround for this issue and post a follow up here. Hopefully this will prove useful for future communities users.

 

Regards,

 

Alex

 

-------

 

Community Support Team _ Alex Rezac
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

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.

PowerPlatform 768x460.png

Microsoft Learn

Check out our new Discover Your Career Path blog post series and get all the details.

Top Solution Authors
Users online (1,224)