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

Like (0) Share

Report

Posted on 18 Nov 2024 04:13:28 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

All responses (4)

Answers (0)

RubySmith11 32 on 19 Nov 2024 at 03:31:49

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!
Jalpa Mahesh Dhola 35 on 18 Nov 2024 at 06:52:08

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
RubySmith11 32 on 18 Nov 2024 at 06:21:03

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
Suggested answer

Jalpa Mahesh Dhola 35 on 18 Nov 2024 at 05:35:10

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']

Community site session details

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

Helpful resources

News and Announcements

Quick Links

Announcing the Engage with the Community forum!

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Warren Belz – Community Spotlight

Leaderboard > Power Automate - Building Flows

Featured topics

Product updates

Community site session details

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

Helpful resources

News and Announcements

Quick Links

Announcing the Engage with the Community forum!

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Warren Belz – Community Spotlight

Subscribe to this forum!

Select categories

Leaderboard > Power Automate - Building Flows

Featured topics

Product updates