Flow that daily collects SharePoint list entries with same SO# grouped by Status value, then communicates to specific people

[MShelnutt]

Hi @Pstork1 ,

you recently helped me with a flow to automatically update the Status column of a SharePoint list, and now I need to add another flow that will gather the entries that do not have a Status of "Complete", and group them by "SO/ Quote #" (the Title column) and will send an email and Teams message to the person (determined by the Status value) with the entries combined based on the "SO/ Quote #" value.

Here is what I have so far-

1. Recurrence to check every weekday at 6am

2. Get Items from the SharePoint List "Material Creation Tracker", with filter query as "Status ne 'Complete'"

3. Initialize Email Variable

4. Initialize Teams Variable

5. Initialize US20 Ops variable

6. Initialize Purchasing variable

7. Initialize Accounting variable

8. Initialize Intercompany variable

9. Initialize Sales variable

10. Initialize US21 Operations variable

11. Initialize US21 Quality variable

12. Apply to Each, with output from previous steps being "Body/value" from SharePoint list

13. For Each, with the same output as the Apply to Each in step 12.

#s 14-21 are inside this loop.

14. Append to Array variable US20 Ops

15. Append to Array variable Purchasing

16. Append to Array variable Accounting

17. Append to Array variable US20 Quality

18. Append to Array variable Intercompany

19. Append to Array variable Sales

20. Append to Array variable US21 Ops

21. Append to Array variable US21 Quality

22. For Each, with "body/value" from SharePoint List

23. Get Items, from SharePoint list with Filter Query set to "Title", as this is the "SO/ Quote #" column in the SharePoint list.

24. Outside of the "For Each loop", is Initialize US20 Ops Group variable

25. Initialize Purchasing Group variable

26. Initialize Accounting Group variable

27. Initialize Intercompany Group variable

28. Initialize US20 Quality Group variable

29. Initialize Sales Group variable

30. Initialize US21 Operations Group variable

31. Initialize US21 Quality Group variable

32. Apply to Each, the previous step output being the SharePoint List "body/value"

Does this seem good (so far~ not yet complete), or is there a better (and easier) way?

[ManishSolanki · Accepted solution]

Hi @MShelnutt 

Pls try my blog if that is helpful for you:

Single consolidated email to user (owner) for single select user field in SharePoint - Microsoft Pow...

If this helps & solves your problem, please remember to give a 👍 and accept my solution as it will help others in the future.

[MShelnutt]

Thanks, you helped me think through a different way to do this.