Hello,
I'm ashamed to say how much time I've devoted to this problem. But it's too much. I've used Chat and Co Pilot and they have both led me into the depths of automate hell.
Creating, deleting and re creating and redeleting. Still my workflow doesnt do what it's supposed to. I've officially broken up with AI.
This is my last ditch effort here.
What I need to do:
1. We are now using 365 online forms for our employee compliance quizzes.
2. The forms (Quizzes are done)
3. I created workflow with conditions, so that if an employee fails, (gets below a 90% score), the employee gets an email. And, HR gets an email.
4. I f they get 90 or above, they get nothing.
5. In the sharepoint file, my HR team needs to see total score converted to total % becasue apparently forms to excel doesnt do this on its own. So, i have created new columns for "Total %" and a "Pass/Fail" column on that shared file. with formulas.
6. This worked long ago in the beginning stages of my workflow hell. But, because we need a way to acccess the employee form in the excel shared file because you cant search forms by quiz taker name because the form is to to people outiside of the company.
I'm not sure what kind of file i can include here for assistance? Just wanted to give the parameters first. HELP PLEASE
