Hello,
I'm trying to figure out how to send multiple events (held on the same day) from a SharePoint calendar into ONE email. It is currently sending an email for each event that is held on the same day.
I am also trying to see if it's possible to send an email for calendar events that are more than one day (currently it only sends the initial day the event starts, and none of the dates after that). This is what my current flow looks like. Thanks!
Easiest way for me, is just plug a Create HTML Table action after the Get Items. Pass in get items value, then you can customize to just show the TItle and start time. Then use that HTML Table in your email step. It won't have to loop through the items since it's a table.
IF you want to handle with conditions you can do that as well and just add the items to an array variable by initializing it at the top, then place the condition and append to array action after get items, then use that array variable to generate the html table above then send the email.
I prefer to use filters if you can figure out the odata filter on the get items advanced properties. Can do startdate gt x and startdate lt y etc. Here is a good article going over that: Power Automate filter on SharePoint Date and Time column (tomriha.com)
User | Count |
---|---|
88 | |
39 | |
23 | |
20 | |
16 |
User | Count |
---|---|
128 | |
50 | |
48 | |
35 | |
26 |