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 / How to delete a partic...
Power Automate
Answered

How to delete a particular cell in the excel using PAD

(0) ShareShare
ReportReport
Posted on by Microsoft Employee

Hi,

I want to delete a particular cell in the excel using PAD.

In PAD, we have delete row and delete column action, but how to delete a particular cell in the excel?

 

  • Verified answer
    burque505 Profile Picture
    398 on at

    Hi @Anonymous, this action will write an empty string into a cell, replacing what was in the cell.

    This is the notation for an empty string, might not be visible in the screenshot:

     

    %""%

     

     

    delete_cell.PNG

     

    Before:

    before.PNG

    After:

    after.PNG

  • Community Power Platform Member Profile Picture
    Microsoft Employee on at

    Actually, I want to delete the selected cell and shifts up the cell value.

  • burque505 Profile Picture
    398 on at

    shift-flow.PNGshift-flow.PNG

    Before:

    start.PNG

    After:

    finish.PNG

    This has the effect of deleting 2B and shifting 3B, 4B and 5B up, but what's really happening is 3B through 5B are written into the column starting at 2B, and then 5B is deleted.

     

     

  • Community Power Platform Member Profile Picture
    Microsoft Employee on at

    It is working, but when I write the value " in the write to excel worksheet action, it is not displaying as empty cell, it is displaying like " in the cell.

     

    Radhika1_0-1618471459366.png

     

  • burque505 Profile Picture
    398 on at

    Just as in the post farther above, you need to write this into the cell for an empty string:

     

     

    %""%

     

    Or you can write this, as PAD will translate what you wrote above into this:

     

    %''%

     

    What you see in the screenshot in the flow is how PAD displays this line, i.e. minus the surrounding '%' s.

    You can also see from my screenshots that the target cell does, in fact, display as empty.

     

  • Community Power Platform Member Profile Picture
    Microsoft Employee on at

    yes, got it thanks

  • rangers Profile Picture
    6 on at

    I was just sufferred by the same issue, and finally resolved

    First, defind a string type variable  with empty value,

    rangers_0-1687745595546.png

    and use this var to fill the cell value of the Excel table

    rangers_1-1687745636314.png

     

     

     

     

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Leaderboard > Power Automate

#1
11manish Profile Picture

11manish 243 Super User 2026 Season 2

#2
David_MA Profile Picture

David_MA 211 Super User 2026 Season 2

#3
Mohsin Ali Profile Picture

Mohsin Ali 190

Last 30 days Overall leaderboard