Unanswered

Update row in Excel - Calendar to Excel

(0) Share

Report

Posted on by hjt20

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.

All responses (7)

Answers (0)

hjt20 8 on at

Like (0)

Report

Re: Update row in Excel - Calendar to Excel

@Hardesh15

I added a delay to the end and it's still not changed the row from No to Yes unfortunately.
Hardesh15 7,087 Super User 2024 Season 1 on at

Like (0)

Report

Re: Update row in Excel - Calendar to Excel

@hjt20

Now coming to another part. Excel takes little time to update column you can use delay after update row action. use delay of about 2 min and then check.

Thanks

Hardesh
hjt20 8 on at

Like (0)

Report

Re: Update row in Excel - Calendar to Excel

Hi @Hardesh15

Thanks for your reply. Yes I spotted that the other day and updated to remove the space and still no joy.

Thanks
Hardesh15 7,087 Super User 2024 Season 1 on at

Like (0)

Report

Re: Update row in Excel - Calendar to Excel

@hjt20

i have seen carefully your original post and it seems perfect in logic but i found a space in filter query -

Can you check this? Here is my screen-

Thanks

Hardesh
Hardesh15 7,087 Super User 2024 Season 1 on at

Like (0)

Report

Re: Update row in Excel - Calendar to Excel

@hjt20

Sorry. I have seen you have used filter query. I will test this and give you complete screens.

Thanks

Hardesh
hjt20 8 on at

Like (0)

Report

Re: Update row in Excel - Calendar to Excel

Hi @Hardesh15

Thanks very much for your response. I've tried your answer and changed the Key Value to Yes, rather than a dynamic value but it still doesn't update any rows in the Excel file. Looking at the output it seems to be bypassing any rows that have No in the Event column and just finishing the flow when it finds a Yes.

Thanks.
Hardesh15 7,087 Super User 2024 Season 1 on at

Like (0)

Report

Re: Update row in Excel - Calendar to Excel

@hjt20

In update a row action- put 'Yes' in key value. you are supplying same value from previous step as No. by selecting dynamic content.

Thanks

Hardesh