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.
Solved! Go to 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.
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.
Thank you so much, @v-zhos-msft ! Really appreciate your time in helping me out.
User | Count |
---|---|
88 | |
37 | |
26 | |
13 | |
13 |
User | Count |
---|---|
127 | |
54 | |
37 | |
24 | |
21 |