Unanswered

Send Email for SharePoint Library Files Modified in past week

(1) Share

Report

Posted on by DonnaW

Hello! I'm trying to create an automated workflow that sends and email every Sunday with information on files modified within past week. I've looked at similar threads for ideas and can't get mine to work at all. If anyone has any ideas, I would appreciate the help. Thanks!
I've set up the recurrence and the targeted SharePoint Library:

I've set up the Filter array with @lessOrEquals(item()?["Modified"], addDays(utcNow(),-7,'o'))

Note: Showing this in both Basic and Advanced mode

Added my condition of an Image Tag containing "Academy"

And added the Action to send the email

When I ran my test, it came back as successful, yet the two subsequent automated runs are still running.

Any ideas or suggestions? All help is greatly appreciated!

Categories:

Using flows

I have the same question (0)

All responses (3)

Answers (0)

Sort by

AliB365 91 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @DonnaW

You have two triggers in your flow, a recurrence and when a item/file is created. This is not generally supported. What you want is a recurrence trigger with a "get files (properties only)" action that will retrieve files for the past 7 days. Note that the following expression is case sensitive "Modified" and also note that the date expression is in single quotes ' '.

Modified gt '@{formatDateTime(adddays(utcNow(),-7),'yyyy-MM-dd')}'

Using a create table action and custom columns, we can define the columns that are returned. This can then be used in an email.

If you've got any more questions please let me know. I hope this helps.

Ali B

Was this reply helpful? Yes No
DonnaW 22 on at

Like
a
(0)

Report
Copy link

Link copied!

This is GREAT @AliB365 ! Thank you!
Is there any way to filter the emails based on one of the values in the table? For example, if the Image Tags contain "Academy" send to person A, and if the Image Tags contain "Knowledge Base" send to person B.

Was this reply helpful? Yes No
DonnaW 22 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks @AliB365 To add to my other reply... Or to put it better, how do I add an additional Filter Query value or condition, to only include items that contain "Academy" in the Image Tags ?
I tried modifying the Get Files (properties only) to
(Modified gt '@{formatDateTime(adddays(utcNow(),-7),'yyyy-MM-dd')}') and (MediaServiceImageTags gt 'Academy')
And it didn't work even though the flow checker said it was okay. I've also tried adding a condition in different parts of the workflow and nothing seems to be working.

Was this reply helpful? Yes No