Hello,
I'm building a simple excel attendance report for ms bookings. Every time a booking is created, I get the info in an excel table. Now, where I'm struggling is that now I want that if someone cancels their appointment, I want to update a row where the column is "canceled?" and add a yes in that field.
I have tried instead of "update row", I tried "delete a row" but I hit a roadblock when trying to set the key value for the "delete row" or "update row" actions. My key column is the bookings unique id but I can't get the correct dynamic key value (How to tell PowerAutomate which row to delete)
I get the