web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Update Excel online wi...
Power Automate
Answered

Update Excel online with today date

(0) ShareShare
ReportReport
Posted on by 160

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

Categories:
I have the same question (0)
  • abm abm Profile Picture
    32,985 Most Valuable Professional on at

    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 Profile Picture
    160 on at

    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

  • abm abm Profile Picture
    32,985 Most Valuable Professional on at

    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 Profile Picture
    160 on at

    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

  • Verified answer
    abm abm Profile Picture
    32,985 Most Valuable Professional on at

    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

  • Kamacete Profile Picture
    160 on at

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

    🙂
    thank you very much for your support

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Automate

#1
David_MA Profile Picture

David_MA 262 Super User 2026 Season 1

#2
Haque Profile Picture

Haque 227

#3
Expiscornovus Profile Picture

Expiscornovus 225 Most Valuable Professional

Last 30 days Overall leaderboard