Update Excel online with today date

[Kamacete]

Hi,

I have two files, one has several tasks to do in several different days, and I have to update another file only with the information for today, could you please help me?

thank you for your support

[abm]

Hi @Kamacete 

Not clearly understood your requirement. Are you looking to filter one of your excel file by todays date and take the records to another excel file?

Thanks

[Kamacete]

Sorry for the miss understanding.

🙂

Flow: 

1- Delete old row (error)

-- - When I don't have any row or different comment (of yes), the flow return error and I need to delete all existing rows and continue if there is no row at all (no tasks from the previous day)

let-me show what I have.

[abm]

Hi @Kamacete 

Thanks for your reply. What error are you getting? Which step it is failing? Also could you post a runtime history of your flow?

Thanks

[Kamacete]

Thank you for your kindle support @abm .

In this case, there is no row with information (simulation of no task form the previous day)

EXCEL ONLINE:

[abm · Accepted solution]

Hi @Kamacete 

That make sense now. Thanks for the details.

You can resolve this in two ways.

1. Before the delete row step do a list filter, then check the record count under an IF condition. IF record exists delete the rows

2. You can add an error handler in flow. So if any previous steps fails and wants to carry on do can set the configure run after option as succeeded or failed. Click the List action step three dots, select run after and set the following

My preferred option is the first one.

Thanks

[Kamacete]

for me the first one is more complicated, so, I will try the second.

🙂
thank you very much for your support