How to get Value from array using First, not whole first row / record

(0) Share

Report

Posted on by RubySmith11

Hi there,

I am using Compose with First() expression, to try and get the first Value from a Select Array. It returns the whole row / object (not sure what the right terminology is sorry), however I am trying to get the value itself.

It is returning { "Licenses" : "Finance"}, whereas I am trying just to return "Finance".

I feel like I need to add more to the First expression but cannot find the right syntax. Can anyone help me with how to access the value itself?

Current First expression:

first(body('Select'))

Whole Flow included below for reference

Flow

Flow Details

Categories:

Business Process Flows

I have the same question (0)

All responses (4)

Answers (0)

Suggested answer

Jalpa Mahesh Dhola 35 on at

Like (1)

Report

How to get Value from array using First, not whole first row / record

You need to change the expression like

first(variables('Array1'))?['Licence']

Was this reply helpful? Yes No
RubySmith11 32 on at

Like (0)

Report

How to get Value from array using First, not whole first row / record

Hi @Jalpa Mahesh Dhola,

Thanks for your reply.

Is there a way to apply the expression to the Body of Select Action? Or can it only be used against an Array Variable, so I need to Append Array for each value in the Select first into a whole new 3rd array?

Thanks,

Ruby

Was this reply helpful? Yes No
Jalpa Mahesh Dhola 35 on at

Like (0)

Report

How to get Value from array using First, not whole first row / record

Yes, you can use select action also like this

Which will give the output like

Was this reply helpful? Yes No
RubySmith11 32 on at

Like (0)

Report

How to get Value from array using First, not whole first row / record

Hi @Jalpa,

Thanks for your replies and help.

I am trying to get the Compose to provide the output of "Finance".

For your second suggestion, in your screenshot the output still has { "Licenses" : "Finance"}, whereas what I am trying to extract is only the "Finance".

Is there a way to do that?

I then need to concatenate it with another field later, so cannot have the whole value of { "License" : "Finance" }

When I try the first suggestion: first(variables('Array1'))?['Licence']

my compose input and output is blank.

Thanks in advance for your help!

Was this reply helpful? Yes No