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

When to use use {Compose:input ['Number Column']} vs "@float(outputs('Compose'))" vs @float(triggerbody()?['Number Column'])

I am working on getting an excel table from a SPO library to SPO DataList. While working on the flow I noticed that most of the solution in the community forum falls into the use of @float(outputs('Compose'))" vs @float(triggerbody()?['Number Column']) when I searchd for Numeric Feild for SPO flow.

 

I was NOT able to get my flow working @float(outputs('Compose'))" vs @float(triggerbody()?['Number Column']) as I always get InvalidTemplate error probably my syntax is wrong. However I was able to get my flow working by using Input/Output.


ComposeP1.pngComposeP2.png

 

Question is when do I use "@float(outputs('Compose'))" vs @float(triggerbody()?['Number Column']) and when do I declare a floating variable? is my solution optimal?

1 ACCEPTED SOLUTION

Accepted Solutions

Hi @yellowsubmarine ,

What the column name of the two columns in your excel file.

For example, in my excel, the column name is Column1, So the expression is :

float(items('Apply_to_each')?['Column1'])

Capture15.PNG

For you flow, you just need change the expression with the column name of yours.

Best Regards,

Community Support Team _ Zhongys

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

View solution in original post

6 REPLIES 6
v-zhos-msft
Solution Sage
Solution Sage

Hi @yellowsubmarine ,

When you get the number from the excel file to flow, the type of the value will change to string.

The type of Input/Output is string.

When you want to change the data format, you need to use the function of @float().

I have made a test below: the type of column1 in excel is number.

Capture10.PNGCapture13.PNGCapture9.PNGCapture12.PNG

Best Regards,

Community Support Team _ Zhongys

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

 

Hi @v-zhos-msft 

 

Thanks for the respone, Could you share the expression you used for the float?

 

@v-zhos-msft does that mean even if I was able to call the value from input(excel data table) to output SPO number format columns Amount1 and Amount2 the values are transferred as string?

 

best regards,

ys

Hi @yellowsubmarine ,

The expression is: float(items('Apply_to_each')?['Column1'])

Capture14.PNG

For the second question, when you transferred the data via flow, the value type will change to string.

 

Best Regards,

Community Support Team _ Zhongys

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

 

Hi @v-zhos-msft ,

 

Based on my flow from excel to SPO Data list what should be my dynamic expression solution to convert it to float number format to the 2 columns I have formatted as number.

 

Should a varaible be declared first? When would be the use case to use a float(triggerboddy)? expression?

 

best regards,

ys

Hi @yellowsubmarine ,

What the column name of the two columns in your excel file.

For example, in my excel, the column name is Column1, So the expression is :

float(items('Apply_to_each')?['Column1'])

Capture15.PNG

For you flow, you just need change the expression with the column name of yours.

Best Regards,

Community Support Team _ Zhongys

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

View solution in original post

@v-zhos-msft thanks for the clarification. I might raise another question regarding triggerbody as my question is pretty general. 🙂

 

best regards,

ys

Helpful resources

Announcements
MPA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

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.

Users online (2,544)