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 / Auto clearing names ou...
Power Automate
Answered

Auto clearing names out of a list

(0) ShareShare
ReportReport
Posted on by 9

Good afternoon,

 

I have a feeling this is an easy thing for most here, but I can't seem to get this to work based on the countless YouTube videos I have watched on the subject.

Scenario: I have created a couple basic Microsoft Lists to use in Teams. They basically form a check-in check-out system for equipment. The user puts their name in the "Current Owner" field to check out the equipment. I am wanting to do two things, and I have two separate checkout sheets. 

1) For the first list, I need to be able to set the field to clear the name out after 8 hours has passed. I am guessing this is only able to be done with a JSON script, but again I am kind of knew to all this.

 

2) I want to be able to set the other list to clear the name out at a certain time each day, reoccurring. I have tried to setup a Power Automate for this, but no luck as of yet to get it to actually translate over to the  actual list. 

I don't mind just setting both to expire after 8 hours, but I just need it to automatically clear out the names each day because my co-workers can't be bothered. 


Thank you,

Kris

Categories:
I have the same question (0)
  • Verified answer
    Nived_Nambiar Profile Picture
    18,136 Super User 2026 Season 1 on at

    Hi @Kris5 

     

    Yes it is possible. Let me explain how to do validation for creation hours in power automate. But i am not sure what you meant by clearing field, is it removing the item or updating that row name field as null/empty

     

    well i have explained both cases below

     

    For this purpose, i have created a list with one item like below

    Nived_Nambiar_1-1681703547624.png

     

     

    Case 1: when we need to update Name field as null/empty in row item.

     

    Nived_Nambiar_0-1681703498583.png

     

     

    So logic used is , getting all items from list, then looping through all items in list and then checking whether the item was created in list 8 hours before using the expression in condition 

     

    Expression used there is : int(formatDateTime(dateDifference(items('Apply_to_each')?['Created'],utcNow()),'HH'))

     

    If the condition is true, we will be using update item to update the existing item by passing Name field as Null 

     

    2nd Case: when you need to delete list item which is created 8 hours before, made small change to existing flow

     

    Nived_Nambiar_2-1681703759639.png

     

    condition expression is same, only change is instead of update item, we have used delete item 🙂

     

    Hope the information helps.

     

    Here i have used recurrance flow concept to run the flow at scheduled time:)

     

    Hope it helps 🙂

    Mark it as solution if it resolves your query 🙂

  • Kris5 Profile Picture
    9 on at

    @Nived_Nambiar ,

     

    Thank you for the amazing information. I am about as green as you can get to this type of stuff. I'm a little lost on the structure of the flow. I created a recurrence flow, and then added Get Items. I think that is correct so far, but I am a little lost at the screenshot you sent in the next few steps. Thank you again. You are amazing.

    Kris5_0-1681740204900.png

     

  • Nived_Nambiar Profile Picture
    18,136 Super User 2026 Season 1 on at

    Hi @Kris5 

     

    One thing to know do you need to delete item from list or just clear name value from field?

     

    if you want to delete the item, then follow Case 2

    else if you want to update that item by setting name as null, use case 1 

     

    Let me know if you need any additional help 🙂

     

  • Kris5 Profile Picture
    9 on at

    I think we got it. Thank you! I marked as solution.

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 March Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Haque Profile Picture

Haque 592

#2
Valantis Profile Picture

Valantis 340

#3
11manish Profile Picture

11manish 284

Last 30 days Overall leaderboard