In Power Automate, I am importing rows from excel into powerapps. Once in powerapps, I use the parse JSON feature to add them to a collection. Each row has a 'Global Unique Identifier' field. Below is an example of 4 rows being imported and their ID.
Now, once I import them, I want to loop through the records and find any that has a duplicate ID (as seen in the above example, two records have a matching ID). I then want to add the rows containing the duplicates to another Collection to be displayed in a gallery.
I'm using the below code to do this.
ForAll(
importCollection,
If(
CountRows(
Filter(
importCollection,
GlobalUniqueID = ThisRecord.GlobalUniqueID
)
) > 1,
Collect(
errorCollection,
{
errorField: "Global Unqiue Identifier",
GlobalUniqieID: ThisRecord.GlobalUniqueID,
errorValue: ThisRecord.GlobalUniqueID,
errorType: "Unique ID",
errorMessage: "Duplicate Global Unique Identifiers found."
}
)
)
);
My logic is to count the number of rows that have the same ID as the record, and if there is more then one, add them to the error collection.
However, when I run this, all records in the importCollection are returning true for this condition and being added to the error Collection.
I'm unsure where my code is going wrong and feel like I'm going mad. Could anyone shine some light on how my approach fails and provide an alternative?
