I am trying to solve a problem where data we receive may be duplicated. We do not have a search API available to search the database, so I wondered if there is a way to use the logicapp to search previous runs for that app and send an error message if they find that a field is duplicated (it will only be one field from the dataset).

We receive data in the body, for example

id1: 123
id2: 456
id3: 789

The client’s system has a hole where id2 = 456 may be sent multiple times although it should be unique. We would normally add steps to run a search via API for the value against existing id2s in our data, but this is not an option. So I wanted to know if we could run some kind of lookup step within the logicapp to check the runtime repository for that specific app.

(I am not a dev, please forgive the non tech explanation)

N/A – I haven’t been able to test anything