Hello,
I've developed a PowerApp that allows users to edit records in an excel worksheet. Simply put,
- Records in the excel worksheet have a Unique Identifier, pre-determined by scrambling together 26 letters and characters in random order
- In the PowerApp is a gallery made up of the responses in the excel worksheet
- In this gallery, a user can make edits to the records in the response sheet row by row (there are dropdowns and open-ended comments)
- When an edit is made in one row, that whole row is recorded in a collection
- After making all necessary edits, the user clicks a submit button
- First, PowerApp checks the collection and looks for the Unique Identifier column. Then, it goes to the excel worksheet, finds each Unique Identifier that it previously found in the collection, and deletes those rows completely. Finally, it appends the collection to the excel worksheet.
- So basically, the original record in the excel worksheet is deleted before appending the new record
I have about 20 users of the PowerApp. This process works for 19 of them. For some reason, for one user, the PowerApp skips the "remove duplication" step, so we end up with many duplicate rows. It's as if the PowerApp doesn't check and delete Unique Identifiers for this one use, and I don't know why. The issue is not systematic since it only affects one person.
Does anyone know what could possibly be causing this? Perhaps that user's computer is just slow?
Chris