Identify what 'raw' values are being conditioned against in Logic APP Conditional "contains"

AustinS 101 Reputation points
2020-06-25T16:37:22.02+00:00

I am creating a "lovely" logic app for a pull from an Azure Storage table into a CDS db. I am able to input the data in the format needed, but everytime this app is ran it duplicates the data in the CDS. I need it to run because these row's get manipulated (particularly one column).

I have a comparison of "contains" in a conditional statement:
(list of CDS records - contains - Azure table (item) PartitionKey -- if true, update particular record based on PartitionKey -- if false, create new record) .

I have tried many different ways of doing this, but it always rings false and the feedback after a run on a conditional is only "false" which is obvious. I would like to see what my condition is taking in and comparing from. I have a way of emailing me the raw data from the list records and the azure table records. It shows the partitionKey in both, so not sure why it is ignoring it.

I hope someone can help in the right direction or explain to me why these items can't utilize compare (contains) properly???

here is a snippet of the raw code for the conditional, some is 'expressioned' by me:

"expression": {
"and": [
{
"contains": [
"@Tomas Podoba ('List_records')",
"@replace(item()?['PartitionKey'],'\"cr821_partitionkey\":','')"
]
}
]
},

Azure Logic Apps
Azure Logic Apps
An Azure service that automates the access and use of data across clouds without writing code.
3,004 questions
0 comments No comments
{count} votes

Accepted answer
  1. AustinS 101 Reputation points
    2020-06-25T20:15:03.233+00:00

    Well, I was able to solve this issue. The items given from the List Records were not in a proper format to identify. So I placed those into a seperate Array and checked against that. It was able to identify that it contained that PartitionKey and rang True.

    Hope this helps someone in the future.

    1 person found this answer helpful.

0 additional answers

Sort by: Most helpful