Filtering Array based on condition from nested array

(1) Share

Report

Posted on by KK-03100339-0

Need help with filtering this data based on data in nested array

Input

[
  {
    "id": "1727825406546",
    "attachments": [],
    "mentions": [],
    "reactions": []
  },
  {
    "id": "1727741971470",
    "attachments": [
      {
        "id": "announcement-card-720f1fc6f1ce4454ab3fe65fad0b729d",
        "contentType": "application/vnd.microsoft.teams.messaging-announcementBanner",
        "teamsAppId": "announcement-card"
      },
      {
        "id": "cc4d3943-69d2-426b-994f-d3d62dbbc34b",
        "contentType": "reference",
        "name": "CAMDEN_2024_Teams_background_v02 (1).jpg"
      }
    ],
    "mentions": [],
    "reactions": []
  },
  {
    "id": "1727247153493",
	"attachments": [
      {
        "id": "d4b3f882897646a49294dbcd606fd718",
        "contentType": "application/vnd.microsoft.card.adaptive",
		"teamsAppId": "announcement-card"
	  }
  }
 ]

I would like to filter this array where attachment array is not empty and contentType element contain "Adaptive"

Result should be

{
    "id": "1727247153493",
	"attachments": [
      {
        "id": "d4b3f882897646a49294dbcd606fd718",
        "contentType": "application/vnd.microsoft.card.adaptive",
		"teamsAppId": "announcement-card"
	  }
  }

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (0)

AlexEncodian 4,409 Moderator on at

Like (0)

Report

Try this:

Filter 1: length(item()?['attachments']) is greater than 0 to check if attachments array is not empty

Filter 2: contains(item()?['attachments']?['contentType'], 'adaptive')

Was this reply helpful? Yes No
Chriddle 8,443 Super User 2025 Season 2 on at

Like (0)

Report
Pls check JSON before posting

From:

xpath( xml(json(concat('{"Root":{"Item":', outputs('Compose'),'}}'))), '//Item[contains(attachments/contentType, "adaptive")]' )

Map:

json(item())['Item']

Was this reply helpful? Yes No
Amardeep Raj 18 on at

Like (0)

Report
Hi there,

Here is the answer to your question

2. Filter Parent Array Where any attachment contains adaptive

@{xpath(xml(json(concat('{"body":{"value":', outputs('Compose_Sample_Data') , '}}'))), '/body/value[attachments/contentType[contains(text(), "application/vnd.microsoft.card.adaptive")]]')}

3. Initialize variable

If I've answered your question or solved your problem, please mark this question as answered. This helps others who have the same question find a solution quickly via the forum search. If you liked my response, please consider giving it a thumbs up. Thanks.

Was this reply helpful? Yes No