Power Platform Community Forum Thread Details

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?

Categories:

General topics

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