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\":','')"
]
}
]
},