User Profile
jeffreyhaddad1
Copper Contributor
Joined 5 years ago
User Widgets
Recent Discussions
Create a flow to send a weekly email with list data for each row
I have a SharePoint list for tracking different project tasks. I want to create recurring flow to send a weekly email to the project coordinator (which is a list column) displaying the statuses of each of their standard tasks (each task is a list column). I'm using the template in PowerAutomate but when I go the "Send an email (v2)" module and I'm crafting the body of the email with the dynamic content, the box keeps replicating itself with nested "apply to each" scripts when I add more fields in the email body. When I test the flow, it fails, and I think it's because of this forced "nesting".complex if and lookup
Type: FP,FPH,RMF,T&M,CR,CA profit%: XX% approval level FP FPH RMF T&M CR CA 4 <8% <6% <4% <5% <4% 0% 3 <12% <12% <5% <6% <5% 0% 2 <15% <15% <6% <8% <6% 0% 1 >=15% >=15% >=6% >=8% >=6% 0% I need a formula that will evaluate the input in cell "type" and the cell "profit" to output the corresponding approval level. For example, if type is "CR" and the profit is 7%, then output should be 4. If type is "FPH" and profit is 20%, then output is 1.Solved952Views0likes2Comments
Groups
Recent Blog Articles
No content to show