Hi Abhishek,
Yes, this is possible although you do not have to store reference id’s for this.
What you need to do is create a parent entity and associate it with the entity you are importing. One parent entity will be connected to “n” number of your entities.
In your excel import configuration you can configure Reference to import objects as Parent entity and Mendix Object with your import entity.
You need to create an instance of Parent Entity when starting an import and pass it on to StartImportByTemplate java action. Shown below:
What this will do is associate all the imported rows to the parent entity. Later in your microflow you can retrieve all the imported rows by retrieving them with association from parent entity.
For status you can add an enumeration with a default value and set its appropriate value once its logic is executed.
Hope this helps.
Thanks,
Sharad R K