Formatting a Form number field when creating Sharepoint list item

(0) Share

Report

Posted on by jameslockyer

With Forms having limited restrictions, I have a response field that is set to Number. But this allows users to enter a value that is either a whole number or one with decimals. The form submissions are recorded in a list, whilst they are going through an approval process. Upon approval, they are then added to a list which contains only approved requests.

I have a Flow which takes the value field and populates this second Sharepoint List, and I included some formatting of this in the flow, using INT and format. This works when the user submits the value as a whole number, but fails when decimals are included. Can anyone advise what I should be using to cope with submissions that may or may not include decimals?

Thanks in advance.

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (2)

Verified answer

abm abm 32,865 Most Valuable Professional on at

Like (0)

Report

Hi @jameslockyer

Use the float() expression.

Was this reply helpful? Yes No
Verified answer

Expiscornovus 33,195 Most Valuable Professional on at

Like (1)

Report
Hi @jameslockyer,

If you are expecting decimals I would use a float() instead of an int(). Float can handle whole numbers and decimals.
float(outputs('Compose'))

Was this reply helpful? Yes No
jameslockyer 12 on at

Like (0)

Report

Thanks everyone for the replies. Float worked beautifully, and I have another Powerautomate string to my bow, thanks!

Was this reply helpful? Yes No