Hello!
I’m trying to create a power automate flow to copy date from one sheet to another.
I’ve managed to get somewhere today but I have s few problems
I have one worksheet with product features as a column and product 1,2,3 as rows. Each person reviews each feature for 3 products. I have a main sheet to collect all feedback in individual sheets related to the product.
my problem is that the add row action keeps overwriting the existing data because each review have the same column headings. I tried to make the columns R1 score R1 comment R2 score R2 comment. But because the features remain the same, it’s just causing confusion.
i tried to update row, but that doesn’t work at all. I’m not sure what the key column / value / parameters are as I have multiple tables and I can’t do the whole mapping because I have multiple reviews and that would contradict the aim of automation.
Anyway, does anyone know how to update rows without manual mapping or if I have to stick with add row. How to add multiple sheets and merge anything that’s the same


Report
All responses (
Answers (