Power Platform Community Forum Thread Details

I'm fairly new to Power Automate and am facing a challenge with a specific task. I have a SharePoint document library and need to send a single reminder email for multiple documents to each individual listed in the "Assigned To" column, which allows for multiple people. Each assigned person has unique permissions and can only see their documents.

Here is an example of the library structure:

Name	Title	DueDate	Status	AssignedTo
Doc1	Description1	20231106	Completed	Person1; Person2
Doc2	Description2	20231205	Pending	Person1; Person2
Doc3	Description3	20240101	Pending	Person1; Person3
Doc4	Description4	20231115	Pending	Person4; Person2
Doc5	Description5	20231120	Pending	Person4; Person3

I have found a great post on how to create a reminder I need, which sends one email to the 'Assigned To' person: https://powerusers.microsoft.com/t5/Building-Flows/Sending-one-reminder-for-multiple-tasks/m-p/150723

However, my situation is complicated by the fact that the "AssignedTo" field contains multiple persons (usually 2-3), and I need to send a list of their incomplete tasks to each person. For example, in the scenario above, 'Person1' would receive an email including "Doc2" and "Doc3", 'Person2' would receive "Doc2" and "Doc4", and so forth.

I would greatly appreciate any guidance or help with this.

Thank you in advance!

Categories:

Building flows