I made a flow which gets triggered in Power Apps for importing data from an Excel file into the Dataverse table. It works perfectly, but now I need to make sure there are no duplicates added, that no row from the Excel file already exists in the Dataverse.
My table has a unique value called Unique_ID which I'm trying to compare with the value received from the Excel.
This is how my flow currently looks, when it works perfectly.
After reading stuff on this forum, I tried adding a "Get row by ID" action to compare inside the dataverse and put a condition after it, but the problem is that I was able to put the action only after "add a new row" because otherwise I don't get that "unique_id" from anywhere else, it does not show as an option. These actions made it so that my dataverse will update but it crashed always on the "get row by id" action.
Thanks for you help.
