Hi everyone,
I’ve built a Power Automate flow using an Apply to each loop that processes rows from an Excel table stored on OneDrive. For each row, the flow checks which email step has already been completed and sends the next pending one – starting with the initial email and followed by up to three reminders. Each step is controlled by a condition block (e.g. “Reminder 2 sent ≠ yes”), followed by a “Send email” action and then an “Update row” action that sets the respective field to “yes”.
Here’s the issue:
Even though I only set one field in the “Update row” action (e.g. Reminder 2 sent = yes), Power Automate unexpectedly overwrites other fields in that same row with empty or outdated values. This breaks the flow logic in the next loop iteration – because the next condition checks now fail due to wrong values.
✅ I already tried:
- Leaving all unrelated fields blank in the Update action (no dynamic content)-
- double-checking field names and key column
- esting with fresh Excel files
❌ Still, Power Automate seems to overwrite multiple fields – even those not explicitly touched.
Is this a known bug?
Or is there a better way to update only one single field in a row without touching the rest?
Any ideas or proven solutions are welcome – thank you!
Simon Lehmann
Germany
