You’re offline. This is a read only version of the page.
22
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!
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.
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.
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
#1
WarrenBelz
146,605
Most Valuable Professional
#2
RandyHayes
76,287
Super User 2024 Season 1
#3
Pstork1
65,946
Most Valuable Professional
Share
Report
All responses (
Answers (
