Unanswered

Leadings 0's in a power automate flow

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hello,

I have a sharepoint list that is connected to my power automate as well as a microsoft form. So when someone fills out the form, the data is logged into sharepoint and then I get an email. But when I get an email, I have a ton of 0's after my numbers. Not sure how to fix it.

I already have a compose in my power automate because in my columns, when someone choose a license type, that needs to display the cost of the specific lisense type. So I'm not sure how to put int() into it?

I followed a Youtube video and this is the code I'm currently using :

replace(replace(replace(outputs('Get_response_details')?['body/re84feff3e1534461bb9bfaea74b662c2'],'[',''),']',''),'"','')

Categories:

General topics

I have the same question (0)

All responses (7)

Answers (0)

ScottShearer 25,290 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

@Anonymous

Try using int() or float() See my example below.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

would I put int() separately from that first compose I already have? because in my sharepoint, it's already a calculated column where it says, if the user picks "standard" then display "100" and that first compose forumla I have, is giving me back the "standard" perfectly fine, but the number is coming back as like 100.00000

Was this reply helpful? Yes No
ScottShearer 25,290 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

@Anonymous

Enclose the expression that you already have that spits out all the zeros in the int() expression.

If you still have issues, post a screen shot of the expression that generates the zeros.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

so this is my calculation in my sharepoint:

and the formula I have in my flow, is connected with my microsoft form, I followed from this video here : https://www.youtube.com/watch?v=l82nVlGwrio

so I don't know if I just can't get it to show as 100 and not 100.0000 because I already have that compose in my flow already?

that is saying :
replace(replace(replace(outputs('Get_response_details')?['body/re84feff3e1534461bb9bfaea74b662c2'],'[',''),']',''),'"','')

Was this reply helpful? Yes No
ScottShearer 25,290 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

@Anonymous

Try this in your compose action:

int(outputs('Get_response_details')?['body/re84feff3e1534461bb9bfaea74b662c2'])

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

i did a compose 2 and copied and pasted it in, but it didn't work... Maybe it isn't possible for mine since I'm essentially having to do that replacement formula

Was this reply helpful? Yes No
ScottShearer 25,290 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
@Anonymous

Copy/paste from this board directly into Power Automate frequently does not work for a number of reasons.

Try this:

Add a compose action

Click on Expression

In the expression window, enter int()

Place you cursor inside of the parens i.e. ()

Select/click on the value that you want from Dynamic properties

Click on Update to save the expression

Was this reply helpful? Yes No