I'm in the process of building a flow for holiday updates where flow creates an Outlook event from an Excel spreadsheet. I then want to update the rows in the same spreadsheet so that any rows that have 'No' in one of the columns are changed to 'Yes' so that it doesn't duplicate the calendar entries.
I can get the flow to only add the calendar events that have 'No' in the correct column, but then I can't get the rows to update within the Excel sheet. I've tried this by keeping the cell empty rather than 'No' but it still doesn't update. Can someone tell me where I'm going wrong? Current flow is below.
