Unanswered

Sharepoint get items in power automate not working with integers

(1) Share

Report

Posted on by danielrogers05

I'm trying to create a Power Automate/Flow which sums a column using get items. Ultimately I want to pass the sum value to another Sharepoint list, however everything I try in power automate seems to fall down when using integers. It would appear power automate is getting list items as strings and ignoring the field type.

When I try to use compose to get an integer field I get this error:

The variable 'varSumLeave' of type 'Integer' cannot be initialized or updated with value '266.400000000000' of type 'String'. The variable 'varSumLeave' only supports values of types 'Integer'.

When I try to convert the string to an integer using the int() function I get this error:

The variable 'varSumLeave' of type 'Integer' cannot be initialized or updated with value 'int('266.400000000000')' of type 'String'. The variable 'varSumLeave' only supports values of types 'Integer'.

"int('@{items('Apply_to_each')?['Total_x0020_Leave']}')"

I've been trying to get this to work for days now but nothing seems to work, any help would be greatly appreciated. Thanks

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (0)

Sort by

Brad_Groux 4,556 on at

Like (0)

Report
Copy link

Link copied!

If you could provide an expanded screenshot of your Flow and steps, your Flow run history, and of any detailed error messages you're receiving we could likely better assist you. Also, for the best results, you may want to review How to write a good forum post.

If this reply answers your question or solves your issue, please ACCEPT AS SOLUTION ☑️. If you find this reply helpful, please consider giving it a LIKE. Want to know more? Follow @BradGroux on Twitter, and check out my Medium blog at https://msft.engineer.

Was this reply helpful? Yes No
danielrogers05 6 on at

Like (0)

Report
Copy link

Link copied!

Thanks for the quick reply, I've included screenshots below.

Was this reply helpful? Yes No
Pstork1 69,387 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!
The problem is that the INT() function in Power Automate won't round up if you try to use it on a whole number with a decimal value. So it would work as you have it coded for a value of 26.0000, but not 26.4000. To fix it you first need to remove the decimal portion of the number. Try using this formula

int(formatNumber('@{items('Apply_to_each')?['Total_x0020_Leave']}','#'))

Was this reply helpful? Yes No
danielrogers05 6 on at

Like (0)

Report
Copy link

Link copied!

Hi there,

I tried using the formatNumber function as suggested but still receive the same error, see below.

Was this reply helpful? Yes No