web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Flow to send digest em...
Power Automate
Answered

Flow to send digest emails to assigned user column from a SharePoint online list based on status column items In Progres for items from the last 7 days

(0) ShareShare
ReportReport
Posted on by 247

hello all,

 

I am trying to make a flow with recurrence once per day and specifically to send a daily digest emails to "assigned user" column from a SharePoint online list based on status column items "In Progress" for items from the last 7 days.

 

Screenshot 2020-09-18 111657.png

 

 

so based on the above example the flow at the time of recurrence will send two emails: One digest at User 1 with the two things which are "In progress" One digest at User 2 with the one thing which is "in progress"

Categories:
  • abm abm Profile Picture
    33,004 Most Valuable Professional on at

    Hi @kouliscon 

     

    Have you got a defined users list stored anywhere? If yes then you could access the list of users first then iterate each users against the status and last 7 days (utcNow(), addDays with minus 7). If you don't have a defined list then first get all the records then get all the unique users list then filter using status and days.

     

    Thanks

  • efialttes Profile Picture
    14,756 on at

    Hi!

    Tons of examples on how to solve similar challenges in this same community.

    My suggested approach is:

    1.- REad all items whose status is 'In progress' by means of 'Get items' action block in the last 7 days

    2.- Build an array variable with all users emails

    3.- iterate all through them by means of an 'Apply to Each' whose input is the users emails' array

    Now inside the apply to each:

    4.- 'Filter array' action block assigning as its input 'Get items output' and setting its condition rule in order to extract items whose user assigned equals the one from current iteration

    5.- 'Create HTML table' assigning as its input 'Filter array' output

    6.- SEnd an email to current iteration email

     

    Does this approach matches your requirements? If so, please let us know your progress on this flow design, and if you find a blocking issue, share a screenshot with current flow design

     

    Cheers!

  • kouliscon Profile Picture
    247 on at

    here is what I have till now

     

    Pic1.png

     

    Pic2.png

     

    Pic3.png

     

    but I get stuck at the "Get Items 2" filter Query.. any ideas?

  • abm abm Profile Picture
    33,004 Most Valuable Professional on at

    Hi @kouliscon 

     

    Thanks for your screenshot. If the column Receiver is a text column then use a single quotes 

     

    Receiver eq 'currentitem'

     

    image.png

  • kouliscon Profile Picture
    247 on at

    @abm  Hello

     

    i have been struggling with this without success.

     

     Can you provide more info with maybe pictures from the flow that works and i don’t have a defined list so i will need to look first at the records and then get unique users.

     

     Thank you

  • kouliscon Profile Picture
    247 on at

    @abm the single quotes worked but i cannot make it work correct...

  • abm abm Profile Picture
    33,004 Most Valuable Professional on at

    Hi @kouliscon 

     

    What data type is the receiver column?

     

    Thanks

  • Verified answer
    abm abm Profile Picture
    33,004 Most Valuable Professional on at

    Hi @kouliscon 

     

    Thanks for the screen share. The following are the steps we did.

     

    1. Filter the list by status

    2. Store JSON custom formatted data with email and data (Array)

    3. Store unique email address (Array)

    4. Iterate  unique array and filter the JSON values

    5. Send email

     

    Thanks

  • kouliscon Profile Picture
    247 on at

    thank @abm for your time, you really know what you are doing and your final solution nailed it.

     

    you know the PowerApps very well as you tried so many different alternatives.

     

    thank again for the assistance and solution.

  • abm abm Profile Picture
    33,004 Most Valuable Professional on at

    Hi @kouliscon 

     

    Thanks for your kind words. This community is one of the best and lots of good knowledge here.

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Leaderboard > Power Automate

#1
11manish Profile Picture

11manish 237 Super User 2026 Season 2

#2
David_MA Profile Picture

David_MA 227 Super User 2026 Season 2

#3
Mohsin Ali Profile Picture

Mohsin Ali 194

Last 30 days Overall leaderboard