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 / Sharepoint list and se...
Power Automate
Unanswered

Sharepoint list and sending emails to connected person

(0) ShareShare
ReportReport
Posted on by Microsoft Employee

Hello,

 

I have sharepoint list like: 

PersonTopicStart date
Person or group (allow multiple)StringDate with hour
A, BTopic 106.02.2023 10:00
A, CTopic 207.02.2023 11:00
BTopic 308.02.2023 09:00

Column person is connected with account so I know name, email adress, position etc. of choosen person. 

 

I want to send email every Friday to each person with their items started next week. 

Example: 

At Friday 03.02.2023 I want send email about items from 06.02 to 12.02. 

 

To person A: 

 

PersonTopicStart date
A, BTopic 106.02.2023 10:00
A, CTopic 207.02.2023 11:00

 

To person B: 

PersonTopicStart date
A, BTopic 106.02.2023 10:00
BTopic 308.02.2023 09:00

 

 

I know that I should use "Get Items" from sharepoint list. But what should I do next? 

 

 

Categories:
I have the same question (0)
  • MarvinBangert Profile Picture
    1,924 Most Valuable Professional on at

    Hi @Anonymous 

    please review the following blog post, it might already solve your problem: Send one email per user with multiple SharePoint items in Power Automate (tomriha.com)

    To only run on the items within a specific time range, you can use the filter query within the "get items" SharePoint action. Here is another example how to write the query: Solved: Using Filter Query Between Two Dates - Power Platform Community (microsoft.com)

     

    Does this help you? Otherwise please give me some more information.

    Best regards
    Marvin

    If you like this post, give a Thumbs up. If it solved your request, Mark it as a Solution to enable other users to find it.

    Blog: Cloudkumpel
    Join my User Group (German & English): Power Platform UG Cologne

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Automate

#1
David_MA Profile Picture

David_MA 103 Super User 2026 Season 1

#2
Haque Profile Picture

Haque 87

#3
trice602 Profile Picture

trice602 63 Super User 2026 Season 1

Last 30 days Overall leaderboard