Hello,
I have sharepoint list like:
Person | Topic | Start date |
Person or group (allow multiple) | String | Date with hour |
A, B | Topic 1 | 06.02.2023 10:00 |
A, C | Topic 2 | 07.02.2023 11:00 |
B | Topic 3 | 08.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:
Person | Topic | Start date |
A, B | Topic 1 | 06.02.2023 10:00 |
A, C | Topic 2 | 07.02.2023 11:00 |
To person B:
Person | Topic | Start date |
A, B | Topic 1 | 06.02.2023 10:00 |
B | Topic 3 | 08.02.2023 09:00 |
I know that I should use "Get Items" from sharepoint list. But what should I do next?
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