Can the new sharepoint list item added every week be automatically sent out by email? All the new item information is summarized in one email and sent automatically once a week at a specific time.
I use "create new item and sent email" template. It can be realized that whenever there is a newly created item, an email will be sent automatically. But what I hope to achieve is that the new items for a week will be sent out only by one email.
Dear experts, can I achieve the function I want?
Solved! Go to Solution.
1. Instead of the current trigger you need a scheduled flow (Recurrence Trigger) that runs weekly
2. Get Items with Filter Criteria like this
where start and end dates can be generated as below:
3. Then you can use the Create HTML Table and use it to generate a table from List of Items returned from Get Items and use it in your email
To get the Time in past you can use the below Action and make sure you format the date use formatdatetime(Timestamp,'yyyy-MM-dd') and use it as parameter instead of start date above
I still don’t understand how " Created It'EndDate’ and gt'StartDate’ " is implemented? Does "Created" use the automatically generated Created column in the sharepoint list? Where can I define "EndDate" and "StartDate"? Can you help me with an example? Is it necessary to use the "Get past time" you mentioned below?
we need Past time to get the date from the beginning which is start date
Then format it as 'YYYY-MM-dd' using compose data operation Expression as below:
End Date : Compose Data Operation:
Then use the outputs of the compose data operations as below in Place of the filter
Answering your questions above:
I still don’t understand how " Created It'EndDate’ and gt'StartDate’ " is implemented? Does "Created" use the automatically generated Created column in the sharepoint list?
Created is the automatically generated created column when a new list item is created so the condition is created less than end date(Today) and greater than start date(which is today-1 week)
Where can I define "EndDate" and "StartDate"? Can you help me with an example? Is it necessary to use the "Get past time" you mentioned below?
I have provided example below on defining start and end date
Hope this helps!
I tried your method, but it seems that the format of the Created column does not match.
Please help to see the error log.
Thank You for you help!!
Thank you for you support. I achieved the desired function.
But for trial run , i meet a problem.
When I just completed the trial run of flow last week, I only received one email. But now after I try this flow, I will receive many emails instead of one. I re-created a new flow as it is, and trial run will also receive many emails. May I ask what caused this? I just want to receive only 1 email per run.
You have already constructed an HTML table which the one you want to send in the email , so email step needs to be outside the loop so as not to send multiple times as in your case.