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 data fro...
Power Automate
Answered

How to delete data from specific range of cells?

(0) ShareShare
ReportReport
Posted on by 27

Hi everyone,

 

I want to create a scheduled flow to delete data from a specific range of cells. 

snip.png

 

 

For the above table, I want the flow to automatically delete the data in the "Available hours" column and leave it blank. 

 

Looking forward to your replies! Thank you!

Categories:
I have the same question (0)
  • Verified answer
    grantjenkins Profile Picture
    11,063 Moderator on at

    This is how you might be able to achieve what you're after. However, this assumes all the Names are unique and not null.

     

    For this example, I'm using the following Excel Table. I'll be clearing the Amount column values.

    grantjenkins_1-1700656948929.png

     

    See full flow below. I'll go into each of the actions.

    grantjenkins_0-1700656893414.png

     

    Recurrence will run on the schedule to suit your needs.

    grantjenkins_3-1700657114721.png

     

    List rows present in a table will retrieve all the rows. Note that by default this will only return the first 256 rows. If you have more rows than this then you can set the Top Count to cover the rows you have. I've set mine to 5000 (max you can have) just as an example.

    grantjenkins_2-1700657097770.png

     

    Apply to each will iterate over each of the rows.

    grantjenkins_4-1700657143780.png

     

    Update a row will update each of the rows using the Name column to uniquely identify each row. This is where it's important that each of your Names are unique and there are no blank names. To update the Amount (remove the value) you would use the following expression.

    string('')

    grantjenkins_5-1700657240361.png

     

    After running the flow we would have the following table (Amount values have been cleared).

    grantjenkins_6-1700657322156.png

  • calinpff Profile Picture
    27 on at

    Hi @grantjenkins ,

     

    Thank you for taking the time! 

     

    I'm adding the string('') expression for my row, however it doesn't stay there after saving the flow. It gets deleted. 

     

    Thanks again!

     

  • calinpff Profile Picture
    27 on at

    *

  • calinpff Profile Picture
    27 on at

    Thank you very much for your help, Grant! It finally worked. 🙂 

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!

Congratulations to the April Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Vish WR Profile Picture

Vish WR 791

#2
Valantis Profile Picture

Valantis 568

#3
Haque Profile Picture

Haque 535

Last 30 days Overall leaderboard