Answered

Determine string length, to apply rounding new column ( using SharePoint Online & Power Automate)

(0) Share

Report

Posted on by eviljoen4

I have two columns sample below, I need to round the second column string to the same length as in the first column to be able to automate order placing.

Current Price: Order Price:

0.123 0.134768

1.1 1.243029

0.00045 0.000472

The outcome I would like to see is:

Current Price: Order Price:

0.123 0.135

1.1 1.2

0.00045 0.00047

Thanks

Categories:

Building flows

I have the same question (0)

All responses (6)

Answers (1)

eviljoen4 21 on at

Like (1)

Report

I thought this might work but as @VictorIvanidze pointed out it does not work in all scenarios
=ROUND(['Order Price'],LEN(Current Price)-2)

Was this reply helpful? Yes No
VictorIvanidze 13,073 on at

Like (0)

Report

Hi @eviljoen4,

what if CurrentPriice is 123.123 and OrderPrice is 122.22222 ?

Was this reply helpful? Yes No
eviljoen4 21 on at

Like (0)

Report

Hello,

Good question, let me check.

Was this reply helpful? Yes No
eviljoen4 21 on at

Like (0)

Report

You correct my solution does not work, any ideas?

Was this reply helpful? Yes No
Verified answer

Shujaath_Khan 1,111 Super User 2024 Season 1 on at

Like (1)

Report
Hi @eviljoen4

there's good thread on round here
tried substring way if you're interested you can try below expression but the problem is it doesn't round the value
concat(split(variables('varorderPrice'),'.')[0],'.',substring(split(variables('varorderPrice'),'.')[1],0,length(split(variables('varCurrentPrice'),'.')[1])))

Thanks
Please click Accept as Solution on this reply if it helped to solve your issue, and thumbs-up if you feel this is useful or important in other ways as a boost.

Was this reply helpful? Yes No
eviljoen4 21 on at

Like (0)

Report

Thank you

Was this reply helpful? Yes No