Get Last Item in Array

(0) Share

Report

Posted on by Chauc3r

I can succesfully retrieve a value from the first item in an array using this:

body('TrackCont')?['Containers'][0]['eta_final_delivery']

Can someone tell me how to pull the same from the last item in the array? Array is of indeterminate length?

Thanks

Categories:

Building flows

I have the same question (0)

All responses (7)

Answers (1)

abm abm 32,985 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @Chauc3r

You can use the last() expression to get the last value from the index of the array.

Thanks

Was this reply helpful? Yes No
Chauc3r 50 on at

Like (0)

Report
Copy link

Link copied!

Hi @abm,
Apologies, I'm rather out of my depth here.
I tried rewriting that as
last('TrackCont')?['Containers']['eta_final_delivery']
but it didn't like it!

Also if you were able to point me at an idiot guide to flow syntax that be amazing!

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

Like (0)

Report
Copy link

Link copied!

Looks like you need a closing )

last('TrackCont')?['Containers']['eta_final_delivery'])

Was this reply helpful? Yes No
Chauc3r 50 on at

Like (0)

Report
Copy link

Link copied!

Hey @haroldbk_msft ,

I tried multiple versions of that guy with no luck.....

100% confident I'm doing something idiotic!

Was this reply helpful? Yes No
Verified answer

abm abm 32,985 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Try the below in a compose

last(body('TrackCont')?['Containers']))

See the runtime history and see what it outputs

Was this reply helpful? Yes No
abm abm 32,985 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

Also see what this returns

body('TrackCont')?last(['Containers'])

Let me know how it goes. Once either of these expression works then its easy to extract the properties.

Was this reply helpful? Yes No
Chauc3r 50 on at

Like (4)

Report
Copy link

Link copied!

Sticking things into a compose and playing with them is probably the most useful tip I've ever had with Flow! Just makes things so much more visible!
Thanks!

Was this reply helpful? Yes No