cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Bertmi01
Level: Powered On

Matching SharePoint Lookup Column to json key

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:

 

image.png

 

Any help or ideas would be sincerely appreciated.

1 ACCEPTED SOLUTION

Accepted Solutions
v-zhos-msft
Level 10

Re: Matching SharePoint Lookup Column to json key

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']

Capture6.PNGCapture7.PNG

Capture8.PNG

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.

View solution in original post

2 REPLIES 2
v-zhos-msft
Level 10

Re: Matching SharePoint Lookup Column to json key

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']

Capture6.PNGCapture7.PNG

Capture8.PNG

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.

View solution in original post

Bertmi01
Level: Powered On

Re: Matching SharePoint Lookup Column to json key

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

Helpful resources

Announcements
firstImage

Power Platform Online Conference

Join us for the first ever Power Platform Online Conference!

firstImage

Incoming: New and improved badges!

Look out for new contribution recognition badges coming SOON!

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Power Automate Community Video Gallery!

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