I have 2 SP Lists:
Frist one is about some projects and there are 3 important columns(related to this future Flow):
On the other side, there is a 2nd SP list contains the following column.
‘Last Name’ from this list is connected to the 1st list.
I need to build a flow which is only focusing on one of those sub project. Let’s just say it is a choose “MM” from a drop down menu(Sub Project) in the 1st SP list .
The Flow should look for all Authors (people creating the entry in this list) in the 1st list and for each Author the workflow is looking for "overdue" documents. The Flow should send an eMail to this Author with all overdue documents. All of the item should be send in one single eMail to every single Author who is concerned.
As a trigger I use ‘Recurrence’(for example every day). Than I managed to get all items that are with status “overdue” with Filter Query in ‘Get Items’ action for 1st SP List:
The filter looks like this: Due_x0020_Date lt utcNow('MM-dd-yyyy') and Sub_x0020_Project eq 'MM"
Now I have all of the entries that are out of the schedule.
My main question is how to continue after that, I need to get the eMails of the Authors of the items in 1st SP List from the 2nd List?
Should store all of the IDs with status “overdue” by Authors and send an eMail with those IDs. I cannot send group eMail, every Author should receive an eMail only with the IDs that are related to him.
I really will be grateful, if You give me an advise how to create this Flow.
Have a great day all of You.
Thank you so much for the reply.
I'll try to do it and let you know what the result is. Maybe I'll have some additional questions also.
Maybe I'm not so skillful and I didn't manage to handle the Flow...The main idea is not to send email for every overdue item, I need to collect all items by author and send them in one email to this author. But when I get into apply to each - that is not possible.
Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.
Register today for two amazing days of learning, featuring intensive learning sessions across multiple tracks, led by engaging and dynamic experts.
The European SharePoint Conference returns live and in-person November 28-December 1 with 4 Microsoft Keynotes, 9 Tutorials, and 120 Sessions.