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?
