cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Helper III
Helper III

Update Excel online with today date

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

1 ACCEPTED SOLUTION

Accepted Solutions

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

 

image.png

 

 

image.png

 

My preferred option is the first one.

 

Thanks



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blog

Power Automate Video Tutorials

View solution in original post

6 REPLIES 6
Super User III
Super User III

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



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blog

Power Automate Video Tutorials

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.

1.png

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



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blog

Power Automate Video Tutorials

Thank you for your kindle support @abm .

 

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

 

1.png

 

EXCEL ONLINE:

2.png

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

 

image.png

 

 

image.png

 

My preferred option is the first one.

 

Thanks



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blog

Power Automate Video Tutorials

View solution in original post

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

🙂
thank you very much for your support

Helpful resources

Announcements
PP Bootcamp Carousel

Global Power Platform Bootcamp

Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.

secondImage

Power Platform Community Conference On Demand

Watch Nick Doelman's session from the 2020 Power Platform Community Conference on demand!

MPA Community Blog

Power Automate Community Blog

Check out the community blog page where you can find valuable learning material from community and product team members!

Users online (3,329)