Hi,
You can temporarily import excel data in non-persistent entity and in a microflow fetch data from both i.e., from non-persistent and the actual database(where data will be saved finally) using retrieve activity.
Then do the comparison and then decide whether to save data in actual entity or end the flow.
Hope this helps!
Hi Shubham Dhorajkar,
using below steps you can achieve your solution.
Hope it helps!!!
Hi Subham,
Do you want the whole Excel file to not import if any one of the record is found in the database or you want to exclude the row that is present and then create others ?
If you want the second option you can make use of the Excel import settings “Only Create new objects ” option.
You can also explore other options in the link. You can make use of the settings given by the module instead of Creating flows.
For your Reference : https://docs.mendix.com/appstore/modules/excel-importer/#references
If you want the whole excel file to not import you can make use of other solution given above..