Forum Discussion

chagedorn49's avatar
chagedorn49
Copper Contributor
May 08, 2025

Email to Assignee with SharePoint items created in past week and assigned to the email recipient

Going into this it seemed straightforward, but I've been banging my head against the Power Automate wall. We have a SharePoint list with a number of columns, one of which is basically Assigned to (i...
Microsoft Flow
PowerApps
sharepoint
michalkornet's avatar
michalkornet
Iron Contributor
May 11, 2025

Hi chagedorn49​,  I hope I understand the case correctly, but you need to take the following actions to complete it:

- In the scheduled flow:

  1. Get the current date in ISO format to use in filtering.
formatDateTime(utcNow(), 'yyyy-MM-ddTHH:mm:ssZ')

2. Calculate the ISO date for now minus 7 days.

formatDateTime(addDays(utcNow(), -7), 'yyyy-MM-ddTHH:mm:ssZ')

3. Filter items from the list using the calculated date range. (of course use previously calculated values)

Created ge datetime'2025-05-11T00:00:00Z' and Created le datetime'2025-05-04T00:00:00Z'

4. Use 'Apply to each' on the filtered items to send an email to the person listed as the ticket creator.

  • chagedorn49's avatar
    chagedorn49
    Copper Contributor
    May 13, 2025

    Thank you so much for your feedback michalkornet​ 

    I can definitely use the above to get the past 7 days of new SharePoint items and then use the "Ticket created by" value in the To field of the email.

    The "Ticket created by" property in SharePoint is a people picker field and there are about 30 different people that these SharePoint items are assigned to. By chance do you know how to set up the Power Automate email step (or perhaps it's a step before it) so that the only SharePoint items in the body of the email are the ones assigned to the person being emailed?

Resources