Answered

Choose one JSON object from multiple based on specific value

(0) Share

Report

Posted on by DanielGAJohnson

The below example is the output from an Initialize Variable step. How do I choose just the object whose file_type equals M4A?

[
 {
 "id": "value",
 "meeting_id": "value",
 "recording_start": "2022-02-01T20:09:15Z",
 "recording_end": "2022-02-01T20:09:24Z",
 "file_type": "M4A",
 "file_extension": "M4A",
 "file_size": 141805,
 "play_url": "URL",
 "download_url": "URL",
 "status": "completed",
 "recording_type": "audio_only"
 },
 {
 "id": "value",
 "meeting_id": "value",
 "recording_start": "2022-02-01T20:09:15Z",
 "recording_end": "2022-02-01T20:09:24Z",
 "file_type": "TIMELINE",
 "file_extension": "JSON",
 "file_size": 953,
 "download_url": "URL",
 "status": "completed",
 "recording_type": "timeline"
 },
 {
 "id": "value",
 "meeting_id": "value",
 "recording_start": "2022-02-01T20:09:15Z",
 "recording_end": "2022-02-01T20:09:24Z",
 "file_type": "MP4",
 "file_extension": "MP4",
 "file_size": 167422,
 "play_url": "URL",
 "download_url": "URL",
 "status": "completed",
 "recording_type": "shared_screen_with_speaker_view"
 }
]

Categories:

Business Process Flows

I have the same question (0)

All responses (6)

Answers (1)

DanielGAJohnson 93 on at

Like (0)

Report
Re: Choose one JSON object from multiple based on specific value

This is the result I want:

{ "id": "value", "meeting_id": "value", "recording_start": "2022-02-01T20:09:15Z", "recording_end": "2022-02-01T20:09:24Z", "file_type": "M4A", "file_extension": "M4A", "file_size": 141805, "play_url": "URL", "download_url": "URL", "status": "completed", "recording_type": "audio_only" }

Was this reply helpful? Yes No
Svenny 153 on at

Like (0)

Report

Re: Choose one JSON object from multiple based on specific value

The simplest way would be to use the action "Filter array", with the array you are working with as an input.

In the condition part of the action, specify "file_type" field on the left side, set the condition to "is equal to" and in the right field specify "M4A" as your target.

The output would be an array containing only items with file type M4A.

Reference: https://docs.microsoft.com/en-us/power-automate/data-operations#use-the-filter-array-action

Was this reply helpful? Yes No
DanielGAJohnson 93 on at

Like (0)

Report

Re: Choose one JSON object from multiple based on specific value

@Svenny thanks for the reply!

I'm having trouble specifying the "file_type" field. In the reference you have it shows the field already as dynamic content, but it's not showing in my dynamic content tool tip. Is there a way with an expression to specify the "file_type" field?

Was this reply helpful? Yes No
Verified answer

Svenny 153 on at

Like (0)

Report
Re: Choose one JSON object from multiple based on specific value

No problem!

Yes, you can type this into the expression tab in order to reference the "file_type" field, since dynamic content is not available:

item()?['file_type']

You can also use the "Parse Json" action to make the values in your array variable available as dynamic content for you to work with.

This requires you to specify a schema. The simplest way to do this is to paste your data as example data, and have Power Automate generate it for you.

Was this reply helpful? Yes No
DanielGAJohnson 93 on at

Like (1)

Report

Re: Choose one JSON object from multiple based on specific value

That worked. Thanks @Svenny !

Was this reply helpful? Yes No
Svenny 153 on at

Like (0)

Report

Re: Choose one JSON object from multiple based on specific value

@DanielGAJohnson Great to hear! Glad I could help.

Was this reply helpful? Yes No