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?
Best Regards
Dennis
Solved! Go to Solution.
Sorry I missed below highlighted ; i tried it at my side and it worked, Also please add single Quotes between the Outputs
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:
StartDate=UTCnow() -7days
EndDate=UTCNow
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
Hi @Mira_Ghaly
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!
Hi @Mira_Ghaly
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!!
Sorry I missed below highlighted ; i tried it at my side and it worked, Also please add single Quotes between the Outputs
HI @Mira_Ghaly
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.
This is what is causing it; you need to remove ur email step from this loop
Hi @Mira_Ghaly
If i remove this step, How can I automatically send out the information filtered by the flow before?
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.
Hi @Mira_Ghaly ,
Thank you for your patience.
Now i meet a new question for this flow.
If i change Filter Query contain "Created" to "Modified". This function will not work properly.
I think in SharePoint List, both "Created" and "Modified" are Created automatically and both of them about Date and time information, Why Filter Query = "Created" can work, but Filter Query = "Modified" can not work?
Did i miss any step?
Thank you!
B&R
Dennis
Hi Mira,
I got the answer from below link.
https://powerusers.microsoft.com/t5/Building-Flows/Get-Items-Filter-Query/m-p/319867
I can not delete my question... So you don't need to reply..
Thank you again.
User | Count |
---|---|
89 | |
40 | |
23 | |
20 | |
16 |
User | Count |
---|---|
130 | |
50 | |
48 | |
35 | |
26 |