Solved: Help Extracting Value from Filter Array (produces ...

r96359 · ‎04-30-2020

Really appreciate anyone's help!

I have json code produced as a result of a Filter Array.

I really just need the matching value.

How can I use compose or any other function to just extract US6X in the example below?

efialttes · ‎04-30-2020

Hi!

As you got a single element in Filter Array output, you can use the following expression:

first(body('Filter_array'))?['CompanyCodes']

Hooe this makes sense

Each time you click on any of our inspiring answers 'Thumb up' icon...
...an ewok scapes from the stormtroopers.

Be grateful, Thumbs up! Save the Galaxy for free!

Escribo sobre Power Automate en:
https://medium.com/anyone-can-automate/

Proud to be a Flownaut!

View solution in original post

efialttes · ‎04-30-2020

Hi!

As you got a single element in Filter Array output, you can use the following expression:

first(body('Filter_array'))?['CompanyCodes']

Hooe this makes sense

Each time you click on any of our inspiring answers 'Thumb up' icon...
...an ewok scapes from the stormtroopers.

Be grateful, Thumbs up! Save the Galaxy for free!

Escribo sobre Power Automate en:
https://medium.com/anyone-can-automate/

Proud to be a Flownaut!

View solution in original post

r96359 · ‎04-30-2020

Many Thanks @efialttes !

Help Extracting Value from Filter Array (produces 1 record) to use in a "Apply to each" situation as a string

Helpful resources

Power Platform Community Conference

Power Platform ISV Studio