cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Vinisz
Helper I
Helper I

Filter output from array

Hi,

 

I query CDS Optionsets via the API.
I get JSON output below and want to filter to only show all data of the "Website" option (most important to get the "value")
I have trouble building the right filter, who know what to do ?

"Options": [
{
"Value": 516440000,
"Color": "#0000ff",
"IsManaged": false,
"ExternalValue": "",
"ParentValues": [],
"MetadataId": null,
"HasChanged": null,
"Label": {
"LocalizedLabels": [
{
"Label": "Eigen input",
"LanguageCode": 1043,
"IsManaged": false,
"MetadataId": "252abe99-d3ae-e911-a838-000d3ab865ed",
"HasChanged": null
}
],
"UserLocalizedLabel": {
"Label": "Eigen input",
"LanguageCode": 1043,
"IsManaged": false,
"MetadataId": "252abe99-d3ae-e911-a838-000d3ab865ed",
"HasChanged": null
}
},
"Description": {
"LocalizedLabels": [
{
"Label": "",
"LanguageCode": 1043,
"IsManaged": false,
"MetadataId": "272abe99-d3ae-e911-a838-000d3ab865ed",
"HasChanged": null
}
],
"UserLocalizedLabel": {
"Label": "",
"LanguageCode": 1043,
"IsManaged": false,
"MetadataId": "272abe99-d3ae-e911-a838-000d3ab865ed",
"HasChanged": null
}
}
},
{
"Value": 516440001,
"Color": "#0000ff",
"IsManaged": false,
"ExternalValue": "",
"ParentValues": [],
"MetadataId": null,
"HasChanged": null,
"Label": {
"LocalizedLabels": [
{
"Label": "Beurs Nieuwegein",
"LanguageCode": 1043,
"IsManaged": false,
"MetadataId": "282abe99-d3ae-e911-a838-000d3ab865ed",
"HasChanged": null
}
],
"UserLocalizedLabel": {
"Label": "Beurs Nieuwegein",
"LanguageCode": 1043,
"IsManaged": false,
"MetadataId": "282abe99-d3ae-e911-a838-000d3ab865ed",
"HasChanged": null
}
},
"Description": {
"LocalizedLabels": [
{
"Label": "",
"LanguageCode": 1043,
"IsManaged": false,
"MetadataId": "2a2abe99-d3ae-e911-a838-000d3ab865ed",
"HasChanged": null
}
],
"UserLocalizedLabel": {
"Label": "",
"LanguageCode": 1043,
"IsManaged": false,
"MetadataId": "2a2abe99-d3ae-e911-a838-000d3ab865ed",
"HasChanged": null
}
}
},
{
"Value": 516440002,
"Color": "#0000ff",
"IsManaged": false,
"ExternalValue": "",
"ParentValues": [],
"MetadataId": null,
"HasChanged": null,
"Label": {
"LocalizedLabels": [
{
"Label": "Beurs Brussel",
"LanguageCode": 1043,
"IsManaged": false,
"MetadataId": "2b2abe99-d3ae-e911-a838-000d3ab865ed",
"HasChanged": null
}
],
"UserLocalizedLabel": {
"Label": "Beurs Brussel",
"LanguageCode": 1043,
"IsManaged": false,
"MetadataId": "2b2abe99-d3ae-e911-a838-000d3ab865ed",
"HasChanged": null
}
},
"Description": {
"LocalizedLabels": [
{
"Label": "",
"LanguageCode": 1043,
"IsManaged": false,
"MetadataId": "2d2abe99-d3ae-e911-a838-000d3ab865ed",
"HasChanged": null
}
],
"UserLocalizedLabel": {
"Label": "",
"LanguageCode": 1043,
"IsManaged": false,
"MetadataId": "2d2abe99-d3ae-e911-a838-000d3ab865ed",
"HasChanged": null
}
}
},
{
"Value": 516440003,
"Color": "#0000ff",
"IsManaged": false,
"ExternalValue": "",
"ParentValues": [],
"MetadataId": null,
"HasChanged": null,
"Label": {
"LocalizedLabels": [
{
"Label": "Beurs Parijs",
"LanguageCode": 1043,
"IsManaged": false,
"MetadataId": "2e2abe99-d3ae-e911-a838-000d3ab865ed",
"HasChanged": null
}
],
"UserLocalizedLabel": {
"Label": "Beurs Parijs",
"LanguageCode": 1043,
"IsManaged": false,
"MetadataId": "2e2abe99-d3ae-e911-a838-000d3ab865ed",
"HasChanged": null
}
},
"Description": {
"LocalizedLabels": [
{
"Label": "",
"LanguageCode": 1043,
"IsManaged": false,
"MetadataId": "302abe99-d3ae-e911-a838-000d3ab865ed",
"HasChanged": null
}
],
"UserLocalizedLabel": {
"Label": "",
"LanguageCode": 1043,
"IsManaged": false,
"MetadataId": "302abe99-d3ae-e911-a838-000d3ab865ed",
"HasChanged": null
}
}
},
{
"Value": 516440004,
"Color": "#0000ff",
"IsManaged": false,
"ExternalValue": "",
"ParentValues": [],
"MetadataId": null,
"HasChanged": null,
"Label": {
"LocalizedLabels": [
{
"Label": "Mail",
"LanguageCode": 1043,
"IsManaged": false,
"MetadataId": "312abe99-d3ae-e911-a838-000d3ab865ed",
"HasChanged": null
}
],
"UserLocalizedLabel": {
"Label": "Mail",
"LanguageCode": 1043,
"IsManaged": false,
"MetadataId": "312abe99-d3ae-e911-a838-000d3ab865ed",
"HasChanged": null
}
},
"Description": {
"LocalizedLabels": [
{
"Label": "",
"LanguageCode": 1043,
"IsManaged": false,
"MetadataId": "332abe99-d3ae-e911-a838-000d3ab865ed",
"HasChanged": null
}
],
"UserLocalizedLabel": {
"Label": "",
"LanguageCode": 1043,
"IsManaged": false,
"MetadataId": "332abe99-d3ae-e911-a838-000d3ab865ed",
"HasChanged": null
}
}
},
{
"Value": 516440005,
"Color": "#0000ff",
"IsManaged": false,
"ExternalValue": "",
"ParentValues": [],
"MetadataId": null,
"HasChanged": null,
"Label": {
"LocalizedLabels": [
{
"Label": "Advertentie",
"LanguageCode": 1043,
"IsManaged": false,
"MetadataId": "342abe99-d3ae-e911-a838-000d3ab865ed",
"HasChanged": null
}
],
"UserLocalizedLabel": {
"Label": "Advertentie",
"LanguageCode": 1043,
"IsManaged": false,
"MetadataId": "342abe99-d3ae-e911-a838-000d3ab865ed",
"HasChanged": null
}
},
"Description": {
"LocalizedLabels": [
{
"Label": "",
"LanguageCode": 1043,
"IsManaged": false,
"MetadataId": "362abe99-d3ae-e911-a838-000d3ab865ed",
"HasChanged": null
}
],
"UserLocalizedLabel": {
"Label": "",
"LanguageCode": 1043,
"IsManaged": false,
"MetadataId": "362abe99-d3ae-e911-a838-000d3ab865ed",
"HasChanged": null
}
}
},
{
"Value": 516440006,
"Color": "#0000ff",
"IsManaged": false,
"ExternalValue": "",
"ParentValues": [],
"MetadataId": null,
"HasChanged": null,
"Label": {
"LocalizedLabels": [
{
"Label": "Mond-tot-mond",
"LanguageCode": 1043,
"IsManaged": false,
"MetadataId": "372abe99-d3ae-e911-a838-000d3ab865ed",
"HasChanged": null
}
],
"UserLocalizedLabel": {
"Label": "Mond-tot-mond",
"LanguageCode": 1043,
"IsManaged": false,
"MetadataId": "372abe99-d3ae-e911-a838-000d3ab865ed",
"HasChanged": null
}
},
"Description": {
"LocalizedLabels": [
{
"Label": "",
"LanguageCode": 1043,
"IsManaged": false,
"MetadataId": "392abe99-d3ae-e911-a838-000d3ab865ed",
"HasChanged": null
}
],
"UserLocalizedLabel": {
"Label": "",
"LanguageCode": 1043,
"IsManaged": false,
"MetadataId": "392abe99-d3ae-e911-a838-000d3ab865ed",
"HasChanged": null
}
}
},
{
"Value": 516440007,
"Color": "#0000ff",
"IsManaged": false,
"ExternalValue": "",
"ParentValues": [],
"MetadataId": null,
"HasChanged": null,
"Label": {
"LocalizedLabels": [
{
"Label": "Website",
"LanguageCode": 1043,
"IsManaged": false,
"MetadataId": "3a2abe99-d3ae-e911-a838-000d3ab865ed",
"HasChanged": null
}
],
"UserLocalizedLabel": {
"Label": "Website",
"LanguageCode": 1043,
"IsManaged": false,
"MetadataId": "3a2abe99-d3ae-e911-a838-000d3ab865ed",
"HasChanged": null
}
},
"Description": {
"LocalizedLabels": [
{
"Label": "",
"LanguageCode": 1043,
"IsManaged": false,
"MetadataId": "3c2abe99-d3ae-e911-a838-000d3ab865ed",
"HasChanged": null
}
],
"UserLocalizedLabel": {
"Label": "",
"LanguageCode": 1043,
"IsManaged": false,
"MetadataId": "3c2abe99-d3ae-e911-a838-000d3ab865ed",
"HasChanged": null
}
}
},
{
"Value": 516440008,
"Color": "#0000ff",
"IsManaged": false,
"ExternalValue": "",
"ParentValues": [],
"MetadataId": null,
"HasChanged": null,
"Label": {
"LocalizedLabels": [
{
"Label": "Overig",
"LanguageCode": 1043,
"IsManaged": false,
"MetadataId": "3d2abe99-d3ae-e911-a838-000d3ab865ed",
"HasChanged": null
}
],
"UserLocalizedLabel": {
"Label": "Overig",
"LanguageCode": 1043,
"IsManaged": false,
"MetadataId": "3d2abe99-d3ae-e911-a838-000d3ab865ed",
"HasChanged": null
}
},
"Description": {
"LocalizedLabels": [
{
"Label": "",
"LanguageCode": 1043,
"IsManaged": false,
"MetadataId": "3f2abe99-d3ae-e911-a838-000d3ab865ed",
"HasChanged": null
}
],
"UserLocalizedLabel": {
"Label": "",
"LanguageCode": 1043,
"IsManaged": false,
"MetadataId": "3f2abe99-d3ae-e911-a838-000d3ab865ed",
"HasChanged": null
}
}
}
],
"Description": {
"LocalizedLabels": [
{
"Label": "",
"LanguageCode": 1043,
"IsManaged": false,
"MetadataId": "412abe99-d3ae-e911-a838-000d3ab865ed",
"HasChanged": null
}
],
"UserLocalizedLabel": {
"Label": "",
"LanguageCode": 1043,
"IsManaged": false,
"MetadataId": "412abe99-d3ae-e911-a838-000d3ab865ed",
"HasChanged": null
}
},
"DisplayName": {
"LocalizedLabels": [
{
"Label": "Bron van lead DTP",
"LanguageCode": 1043,
"IsManaged": false,
"MetadataId": "402abe99-d3ae-e911-a838-000d3ab865ed",
"HasChanged": null
}
],
"UserLocalizedLabel": {
"Label": "Bron van lead DTP",
"LanguageCode": 1043,
"IsManaged": false,
"MetadataId": "402abe99-d3ae-e911-a838-000d3ab865ed",
"HasChanged": null
}
},
"IsCustomizable": {
"Value": true,
"CanBeChanged": true,
"ManagedPropertyLogicalName": "iscustomizable"
}
}

1 ACCEPTED SOLUTION

Accepted Solutions
sss
Community Support
Community Support

Hi Vinisz,

 

There One Example from v-yuazh-msft

d1.PNG

D2.PNG

The fow would run successfully as below:

D3.PNG

Ref: https://powerusers.microsoft.com/t5/Building-Flows/Filtering-an-array-variable/td-p/182913

View solution in original post

2 REPLIES 2
ChristianAbata
Super User
Super User

hi friend @Vinisz  you can use parse Json action to get all json data and convert it into a properties to use.

 

see

 

json.gif



Did I answer your question? Please consider to Mark
my post as a solution! to guide others :winking_face:

Proud to be a Flownaut!


If you want you can follow me at www.christianabata.com Quieres contenido en español? Síguenos en Power Automate LA
sss
Community Support
Community Support

Hi Vinisz,

 

There One Example from v-yuazh-msft

d1.PNG

D2.PNG

The fow would run successfully as below:

D3.PNG

Ref: https://powerusers.microsoft.com/t5/Building-Flows/Filtering-an-array-variable/td-p/182913

View solution in original post

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Microsoft Ignite 768x460.png

Find your focus

Explore the latest tools,training sessions,technical expertise, networking and more.

Top Solution Authors
Top Kudoed Authors
Users online (1,617)