Matching SharePoint Lookup Column to json key

[Bertmi01]

So I have some parsed json that outputs:

{
  "Entries": [
    {
      "EntryId": "1",
      "Field1": "Derp",
      "Field2": "Smerpleton",
      "Field3": "1442 NW 84th St",
      "Field4": "",
      "Field5": "Seattle",
      "Field6": "WA",
      "Field7": "98107",
      "Field8": "United States",
      "Field9": "Yes",
      "DateCreated": "2019-03-22 12:00:33",
      "CreatedBy": "public",
      "DateUpdated": "",
      "UpdatedBy": null
    },
    {
      "EntryId": "2",
      "Field1": "Mike",
      "Field2": "Test",
      "Field3": "12345 Lake City Way",
      "Field4": "Box 223",
      "Field5": "Seattle",
      "Field6": "WA",
      "Field7": "98101",
      "Field8": "United States",
      "Field9": "",
      "DateCreated": "2019-03-22 13:56:44",
      "CreatedBy": "public",
      "DateUpdated": "",
      "UpdatedBy": null
    }
  ]
}

And I have a SharePoint List with a column called "App ID" which is a single line text field. I want to do a conditional check which simply comes down to "If this EntryID doesn't exist in the App ID column, do blah blah blah".

I cannot figure out at all how to do this. "App ID" contains "Entry ID" seemed to be the most logical choice but doesn't work:

Any help or ideas would be sincerely appreciated.

[v-zhos-msft · Accepted solution]

Hi @Bertmi01 ,

It seems you want to check whether the 'App ID' contains the 'EntryId'.

I have made a flow for your scenario, please check it for a reference.

In the 'Compose' is the Json you have provided.

The expression of 'Compose 3' is: outputs('Compose')?['Entries']

In the 'Apply to each 2',using the output of 'Compose 3'

The expression in the codition is: item()?['EntryId']

Best Regards,

Community Support Team _ Zhongys

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Bertmi01]

Thank you so much, @v-zhos-msft ! Really appreciate your time in helping me out.