Convert Array number to Integer

[lardo5150]

So the last output is a single number, as you can see in the above.  It is an array.

I need to convert this to an integer, so I can run it through a condition and check if it is greater or equal than to 5.

How can I convert this to integer?

I tried a compose with int, but that gave me an error as you see.

[Hardesh15]

@lardo5150  First use replace() and then int().

Int(Replace(Replace(Output,'[',''),']',''))

Please 'Thumbs Up' the posts that helped you and 'Accept as Solution' if my post answered your question.

@Hardesh /Gopenly.in

[lardo5150]

Running into a syntax error.  Any idea what I am doing wrong here?

[Hardesh15]

@lardo5150 First remove int and try to replace only and check output.

Please 'Thumbs Up' the posts that helped you and 'Accept as Solution' if my post answered your question.

@Hardesh /Gopenly.in

[lardo5150]

Did that.  It helped me find a syntax error.  So fixed that, ran it but got an error:

Unable to process template language expressions in action 'Compose_2' inputs at line '0' and column '0': 'The template language function 'replace' expects its first parameter 'string' to be a string. The provided value is of type 'Array'. Please see https://aka.ms/logicexpressions#replace for usage details.'.

int(replace(replace(body('SelectUnavailable'),'[',''),']',''))

[lardo5150]

Ok, looks like I got it to work.

The problem that complicates it is how do I change the null values to 0?

Here is a null value

Working

[Hardesh15]

@lardo5150  Either use expression empty() to check null or use condition block. 

Please 'Thumbs Up' the posts that helped you and 'Accept as Solution' if my post answered your question.

@Hardesh /Gopenly.in

[lardo5150]

Do you have example of both?

[Hardesh15]

@lardo5150  After Array use apply to each and pass array output. Then inside apply to each use compose and pass current loop item. Then use condition- Compose is not equal to Null then in Yes block use all actions which convert to int.

Please 'Thumbs Up' the posts that helped you and 'Accept as Solution' if my post answered your question.

@Hardesh /Gopenly.in

[lardo5150]

empty in the condition does not work.

Everthing is marked as true.

[Hardesh15]

@lardo5150  Use compose output in left side and Null expression in right side.

Please 'Thumbs Up' the posts that helped you and 'Accept as Solution' if my post answered your question.

@Hardesh /Gopenly.in

[dixonbridgeta]

@lardo5150 how did you get this to work?

[Chriddle]

Did I get it right?

You want the first element of an array and if the array is empty you want 0.

coalesce(first(your_array), 0)

[dixonbridgeta]

No, I was just trying to get the integer from the array instead of the key and integer. But I looked on another form and found the solution by using an apply to each formula. 

Thanks though!!

[Anonymous]

Hi Chriddle,

Thanks for this! I am after something similar, except that I would like to have the highest (not first) item of an array, and possibly also convert all empty values to zero. I tried to adapt your solution to my needs, changing the first function to 'max', but it did not work. This is the error message I got. Can you please help me to find out how can I get the highest value from my array?

[Anonymous]

Hi lardo5150,

Can you please explain how you solved the issue? It could be useful for me too, as I am after something very similar. Thank you!

[Chriddle]

@Anonymous Since the values in your array are strings you have to convert them to Numbers before using them with max(). Use a Select action and functions isInt() and int() to convert them.

[Omika]

Hi I am working on this flow and i am pulling data from power bi and i want to put condition when value is less than threshold then it should send me a mail. Here i am stuck at how to convert the data pulled from power bi to int.

Can anyone help me with this?

Thanks