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

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Email to Excel Date/Ti...
Power Automate
Unanswered

Email to Excel Date/Time format and Clear excel rows older than 28days

(0) ShareShare
ReportReport
Posted on by 10

Another newbie here, we have requested that staff send an email to a mailbox with the subject SignIn or SignOut so that we know who is in the office at any given time. In an emergency this allows us to see who might be stuck in the office in the event of a fire evacuation. This is a short term solution...

 

I have it all working with Automate and it adds a row in with the persons name and date/time they sent it. The format is a little hard to read and i can't seem to set it to dd/mm/yy hh/mm. It currently looks like 2020-09-24T21:09:46+00:00

 

The other part is that i only want to store this data for 22 days, how can i get automate to run each night and delete all entries that are 22days or more.

Categories:
I have the same question (0)
  • Jcook Profile Picture
    7,781 Most Valuable Professional on at

    @KyotoUK  This is a duplicate post, please check your other post for my proposed 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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Automate

#1
trice602 Profile Picture

trice602 398 Super User 2025 Season 2

#2
David_MA Profile Picture

David_MA 331 Super User 2025 Season 2

#3
Expiscornovus Profile Picture

Expiscornovus 203 Most Valuable Professional

Last 30 days Overall leaderboard