When importing data from excel I am using 2 entities. One entity which is used by the app and another entity (with same attributes) only used for the import.
My import microflow ...
- deletes old content from import-entity
- imports excel data into empty import-entity
- after import into “import”-entity the microflow compares content of “import”-entity and “app”-entity and decides which object in “app”-entity has to be created, updated or maybe deleted.