Unanswered

Convert Array number to Integer

(0) Share

Report

Posted on by lardo5150 Microsoft Employee

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.

Categories:

General topics

I have the same question (0)

All responses (17)

Answers (0)

Sort by

Hardesh15 7,087 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@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

Was this reply helpful? Yes No
lardo5150 Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Hardesh15 7,087 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@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

Was this reply helpful? Yes No
lardo5150 Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

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'),'[',''),']',''))

Was this reply helpful? Yes No
lardo5150 Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Hardesh15 7,087 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@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

Was this reply helpful? Yes No
lardo5150 Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Do you have example of both?

Was this reply helpful? Yes No
Hardesh15 7,087 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@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

Was this reply helpful? Yes No
lardo5150 Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

empty in the condition does not work.
Everthing is marked as true.

Was this reply helpful? Yes No
Hardesh15 7,087 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@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

Was this reply helpful? Yes No