Listing files in a folder prior to deletion

(1) Share

Report

Posted on by CU27091213-0

So I've created a flow to delete files that have not been modified in the last 90 days, but i wondered how i could add to this a notification of which files will be deleted the next day. I've messed with the notification option in teams and that works well but ideally I'd like it to be something along the lines of

"the following files will be deleted tomorrow as they have not been modified in the last 90 days

File 1

File 2

File 3"

how could I go about creating this?

Categories:

Building flows

I have the same question (0)

All responses (5)

Answers (0)

Sort by

Suggested answer

David_MA 15,116 Super User 2026 Season 1 on at

Like
a
(2)

Report
Copy link

Link copied!

You can do something like this:

The above will return:

Was this reply helpful? Yes No
David_MA 15,116 Super User 2026 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!
For some reason I had trouble adding this to my prior post:

If you have too many rows of data, you may want to convert the Select to csv and attach it to the e-mail instead. There is a limit of how many rows will display in an Outlook message.

You can obviously use expressions to better format the dates.

You can also put the e-mail into HTML mode and then add CSS to better format the table in Outlook.

Was this reply helpful? Yes No
Suggested answer

Michael E. Gernaey 53,963 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!

HI,

It's a little difficult because you mentioned teams, so I have no ideas if the notification is an email or teams.

But the process is easy enough, and you said you already wrote the code for finding the things to delete, so not sure where the confusion is.

What is the requirements all up for sending notifications.

Was this reply helpful? Yes No
CU27091213-0 4 on at

Like
a
(0)

Report
Copy link

Link copied!

David_MA thanks so much for your reply, it is insanely helpful and I have managed to produce the table with your instructions.

I'm very new to this so could you advise how I would use an expression to change the date format? I've looked and all I can find is how to do it for a specific date not dates which change. Ideally I'd like the format to be ddmmyy hhmm.

If I wanted to send the list of files that were deleted would I just add the select and table creation to the deletion flow and change the wording on the email that is sent out?

Many thanks

Was this reply helpful? Yes No
David_MA 15,116 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

You can use the formatDateTime expression to format the date in the format you desire. An example of this would be formatDateTime(triggerOutputs()?['body/Modified'], 'ddMMyyyy hhmm'). This is a good resource for date/time expressions in Power Automate: formatDateTime in Power Automate in 2024 (sharepains.com)

If you want to send the list as file, replace the Format HTML Table action with Format CSV and in your e-mail use the output of the Format as CSV for the file content and be sure to name the file with a .csv extension.

Was this reply helpful? Yes No