Power Platform Community Forum Thread Details

I have an array like this

I want to extract just the ID for the title that matches 'Site Pages'

[
  {
    "__metadata": {
      "id": "https://xxxx.sharepoint.com/functions/Benefits/_api/Web/Lists(guid'080918dd-69ba-441e-b082-e3a25eb08410')",
      "uri": "https://xxxx.sharepoint.com/functions/Benefits/_api/Web/Lists(guid'080918dd-69ba-441e-b082-e3a25eb08410')",
      "etag": "\"1\"",
      "type": "SP.List"
    },
    "Id": "080918dd-69ba-441e-b082-e3a25eb08410",
    "Title": "Composed Looks"
  },
  {
    "__metadata": {
      "id": "https://xxxx.sharepoint.com/functions/Benefits/_api/Web/Lists(guid'a99b0a2f-a249-428f-8b2d-e3899ba53c94')",
      "uri": "https://xxxx.sharepoint.com/functions/Benefits/_api/Web/Lists(guid'a99b0a2f-a249-428f-8b2d-e3899ba53c94')",
      "etag": "\"28\"",
      "type": "SP.List"
    },
    "Id": "a99b0a2f-a249-428f-8b2d-e3899ba53c94",
    "Title": "Documents"
  },
  {
    "__metadata": {
      "id": "https://xxxx.sharepoint.com/functions/Benefits/_api/Web/Lists(guid'68d34a49-bf8a-4d85-86fc-151637164241')",
      "uri": "https://xxxx.sharepoint.com/functions/Benefits/_api/Web/Lists(guid'68d34a49-bf8a-4d85-86fc-151637164241')",
      "etag": "\"15\"",
      "type": "SP.List"
    },
    "Id": "68d34a49-bf8a-4d85-86fc-151637164241",
    "Title": "Events"
  },
  {
    "__metadata": {
      "id": "https://xxxx.sharepoint.com/functions/Benefits/_api/Web/Lists(guid'66c0698e-eaa8-4c8a-a57c-5b8dcb9674cf')",
      "uri": "https://xxxx.sharepoint.com/functions/Benefits/_api/Web/Lists(guid'66c0698e-eaa8-4c8a-a57c-5b8dcb9674cf')",
      "etag": "\"20\"",
      "type": "SP.List"
    },
    "Id": "66c0698e-eaa8-4c8a-a57c-5b8dcb9674cf",
    "Title": "Master Page Gallery"
  },
  {
    "__metadata": {
      "id": "https://xxxx.sharepoint.com/functions/Benefits/_api/Web/Lists(guid'1a61cb91-c23f-4725-91b8-90f117c9f8a3')",
      "uri": "https://xxxx.sharepoint.com/functions/Benefits/_api/Web/Lists(guid'1a61cb91-c23f-4725-91b8-90f117c9f8a3')",
      "etag": "\"36\"",
      "type": "SP.List"
    },
    "Id": "1a61cb91-c23f-4725-91b8-90f117c9f8a3",
    "Title": "Site Assets"
  },
  {
    "__metadata": {
      "id": "https://xxxx.sharepoint.com/functions/Benefits/_api/Web/Lists(guid'a6c278df-0278-499f-923e-3e0d43f53eed')",
      "uri": "https://xxxx.sharepoint.com/functions/Benefits/_api/Web/Lists(guid'a6c278df-0278-499f-923e-3e0d43f53eed')",
      "etag": "\"78\"",
      "type": "SP.List"
    },
    "Id": "a6c278df-0278-499f-923e-3e0d43f53eed",
    "Title": "Site Pages"
  }
]

So far I have used the filter array and select actions to give me a much more simplified array like this;

{
  "title": "Site Pages",
  "ID": "52e1273b-4a07-4d00-a68f-7a82ccea1366"
}

but I cant work out how to extract just the ID

I have tried this but it doesnt give me the ID

Categories:

General topics

Hi,

Please add a Filter array action and use the following:

Use Filter Array Action:

Add a Filter Array action to find the object where the Title is "Site Pages".
In the From field, set the array (dynamic content) from your previous step.
Add the following condition:
- Left value: item()?['Title']
- Operator: is equal to
- Right value: Site Pages