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.

Categories:

Using flows

I have the same question (0)

All responses (7)

Answers (0)

Hardesh15 7,087 Super User 2024 Season 1 on at

Like (0)

Report

@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

Was this reply helpful? Yes No
hjt20 8 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Hardesh15 7,087 Super User 2024 Season 1 on at

Like (0)

Report

@hjt20

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

Thanks

Hardesh

Was this reply helpful? Yes No
Hardesh15 7,087 Super User 2024 Season 1 on at

Like (0)

Report

@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

Was this reply helpful? Yes No
hjt20 8 on at

Like (0)

Report

Hi @Hardesh15

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

Thanks

Was this reply helpful? Yes No
Hardesh15 7,087 Super User 2024 Season 1 on at

Like (0)

Report

@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

Was this reply helpful? Yes No
hjt20 8 on at

Like (0)

Report

@Hardesh15

I added a delay to the end and it's still not changed the row from No to Yes unfortunately.

Was this reply helpful? Yes No