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
Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Users online (4,740)