You’re offline. This is a read only version of the page.
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.
Thank you, it worked, the flow ran successfully.
Just a quick question, can this be a problem later? It runs successfully to the end of it, I used "configure run after" for the next action so it can finish either way and so far it added the new values only, as I wanted.
Already did that, for the Sharepoint and in Dataverse as well, I made it primary column but it will still introduce duplicate data when imported
Before inserting a row you can do a "List rows" with a "Filter rows" for the new id and only if that returns no items do the insert.
However, this can fail if there are multiple inserts in a timely manner!
So enforce unique values for this column at the dataverse table level
#1
WarrenBelz
146,524
Most Valuable Professional
#2
RandyHayes
76,287
Super User 2024 Season 1
#3
Pstork1
65,906
Most Valuable Professional
Share
Report
All responses (
Answers (
