Uploading CSV & XLS files change the current value

Hi,   I just want to know what ways I can implement when I upload a csv or xls file. Whenever that data is already uploaded to the system, I just want to update that data.   Thank you in advance.
1 answers


You can create another entity with same attributes to upload Excel data temporarily. (do the excel configuration accordingly)

In microflow, fetch data from the actual database(where data will be saved finally) using retrieve activity.

Use loop activity and inside activity retrieve single data from newly created entity using xpath for the unique key so that we will get the same record

Then do the comparison using decision activity and then update the data or if its new record create the record. And commit the list.

Hope this helps!