cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anthony_Dob
Continued Contributor
Continued Contributor

Search Output Value for a string

Hi Experts,

 

Get Training IDs  outputs the following:

 

"value": [
            {
                "ItemInternalId": "e72b4718-d26e-ec11-8943-000d3a2795b0",
                "cref8_opleidingid": "21257806-3e54-442c-885c-49cc0eacdec6",
                "versionnumber": 6793516,
                "cref8_cursistid": "a08f8fda-f766-ec11-8f8f-000d3a2e7546",
                "cref8_opleiding_cref8_cursistid": "e72b4718-d26e-ec11-8943-000d3a2795b0"
            },
            {
                "ItemInternalId": "db03e969-376d-ec11-8943-000d3a279af3",
                "cref8_opleidingid": "dc5e1cef-6ddc-488e-a973-a9ef1170eb76",
                "versionnumber": 6785275,
                "cref8_cursistid": "a08f8fda-f766-ec11-8f8f-000d3a2e7546",
                "cref8_opleiding_cref8_cursistid": "db03e969-376d-ec11-8943-000d3a279af3"
            },
            {
                "ItemInternalId": "138e859d-1367-ec11-8f8f-000d3a2e7546",
                "cref8_opleidingid": "9ff81e43-3db7-41fd-9a06-b0fbb68ae569",
                "versionnumber": 6718200,
                "cref8_cursistid": "a08f8fda-f766-ec11-8f8f-000d3a2e7546",
                "cref8_opleiding_cref8_cursistid": "138e859d-1367-ec11-8f8f-000d3a2e7546"
            }
        ]

 

I have a for each loop that contains a "cref8_opleidingid". I want to check if the "cref8_opleidingid" in the loop is inside the Get Training IDs  output. How would this be achieved?

 

I tried the following:

 

2022-01-06 11_14_40-noest-trainingbudget-budgetrequest-logic - Microsoft Azure.png

 

This translates to: If Training IDs  output   contains   ToString(cref8_opleidingid from loop)

 

It fails every time though. How can I achieve this?

 

Best Regards,

Anthony

1 ACCEPTED SOLUTION

Accepted Solutions
DamoBird365
Microsoft
Microsoft

Hi @Anthony_Dob 

 

Before your do until, I would create an array of cref8_opleidingid

 

DamoBird365_0-1641489440249.png

And then use your condition to see if the value is contained in this array.

DamoBird365_1-1641489543157.png

 

Make sure you change the map of select to text mode.

 

Then insert the value from the select into the first part of your condition and check if it contains your string.

 

Please consider accepting my answer as a solution if it helps to solve your problem.

Cheers
Damien

Please take a look and subscribe to my YouTube Channel for more Power Platform ideas and concepts, or take a look at my website. Thanks

View solution in original post

1 REPLY 1
DamoBird365
Microsoft
Microsoft

Hi @Anthony_Dob 

 

Before your do until, I would create an array of cref8_opleidingid

 

DamoBird365_0-1641489440249.png

And then use your condition to see if the value is contained in this array.

DamoBird365_1-1641489543157.png

 

Make sure you change the map of select to text mode.

 

Then insert the value from the select into the first part of your condition and check if it contains your string.

 

Please consider accepting my answer as a solution if it helps to solve your problem.

Cheers
Damien

Please take a look and subscribe to my YouTube Channel for more Power Platform ideas and concepts, or take a look at my website. Thanks

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Community Calls Conversations

Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (5,075)