Share
Report
67I'm trying to update a dataverse for teams table with new rows from an excel file stored in the same environment.
I was able to get the new rows created, but unfortunately it's creating multiple rows for each.
I'm listing rows in the excel, then listing rows from the dataverse table where the ID column from Excel matches the Name column in Dataverse. If they do not match then the excel row needs to be added to the dataverse table. But what I'm getting as a result is that if there are 5 new rows in the excel file, the flow creates 25 rows into dataverse, 5 copies for each row in excel.
my flow is as below:
The condition is: length(outputs('List_rows')?['body/value'])
I suspect the issue is either with the condition, or with "Apply to each2"
Any insight on how to ensure only new rows are added to the dataverse table without duplication?
All responses (
Answers (
