Unanswered

Import data from excel to dataverse with unique values

(0) Share

Report

Posted on by Community Power Pla...

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.

Categories:

General topics

I have the same question (0)

All responses (6)

Answers (0)

Chriddle 8,436 Super User 2025 Season 2 on at

Like (0)

Report

Enforce unique values for this column at the dataverse table level.

Was this reply helpful? Yes No
Chriddle 8,436 Super User 2025 Season 2 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

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

Was this reply helpful? Yes No
Chriddle 8,436 Super User 2025 Season 2 on at

Like (0)

Report

Check alternate keys:
https://learn.microsoft.com/en-us/power-apps/developer/data-platform/define-alternate-keys-entity

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Chriddle 8,436 Super User 2025 Season 2 on at

Like (1)

Report

That looks good to me

Was this reply helpful? Yes No