Hello!
I am new to Power Automate, so PLEASE, talk to me like I am a moron when answering this question, because I have seen similar questions answered and have no idea how to implement the solves.
I have a SharePoint list that is used for IT support tickets. Each ticket is given a priority level. I have created a Reminder Date calculated column that I would like to use to send a reminder email based on the columns Created (date) and Priority Level:
=IF([Priority Level]="Urgent",Created+1,
IF([Priority Level]="Normal",Created+5,
IF([Priority Level]="Low",Created+9,0)
)
)
I want to automate a reminder email to be sent to a specific person (not me) on the Reminder date but ONLY if the Status of the ticket (another column) is NOT "Solved" or "Abandoned" (two of the 5 available statuses).
I see a lot of "Add “Apply to each”, input parameter set to output of “Get items” action." or, "Within “Apply to each” box, add a Condition" answers, but when I try them, things pop up like "*Select an output from previous steps" and it just does not match up. I need super step by steps because it is just not clicking for me. Start with which type of flow? What steps do I add? What do I enter in each step?
I very much appreciate it any help you can give!
Thank you!
Solved! Go to Solution.
Yes thanks Ferren!
I do understand the basics, I have built multiple efficient and successful flows from scratch already, the issue is this particular one is not doing what I want it to do, and the solutions I see posted for similar issues are not making sense with what I am seeing.
No problem, I will continue to work and figure it out, I've only been using automate for a day and am just being impatient with this one flow.
Hello @EdenH
If you get lost with trigger types, actions, and conditions may be it is better to start from the beginning. Here are some useful step by step tutorials:
After that, surely you will find it easier to build the flow you need (we can provide a solution, but before you should understand some concepts).
Regards,
Ferran
Yes thanks Ferren!
I do understand the basics, I have built multiple efficient and successful flows from scratch already, the issue is this particular one is not doing what I want it to do, and the solutions I see posted for similar issues are not making sense with what I am seeing.
No problem, I will continue to work and figure it out, I've only been using automate for a day and am just being impatient with this one flow.
User | Count |
---|---|
101 | |
36 | |
29 | |
25 | |
16 |
User | Count |
---|---|
132 | |
54 | |
53 | |
37 | |
26 |