I am working on a training module where microsoft forms, power automate and excel are working together. This is how the process works:
A student fills out a test on microsoft forms using a company phone and submits his/her quiz. The student will complete another one of the same quiz to get an MSA result (measurement system analysis) and this is done by using Power automate which will take the results and send them to an excel spreadsheet file stored in sharepoint. The excel file has multiple tabs (test 1, test 2, overallresults, reference answers) where the overall results is computed using an MSA formula in excel. I have this already setup but I am struggling to get excel to view a line item in the overall results page to do a vlookup from test 1 and test 2 tabs so that it can compute the correct answers for that specific individual who submitted their results. Also, Im having trouble with power automate where the results aren't getting displayed out to a sharepoint page. The system is built, I'm just running into errors along the way and need help.
11 pekerja bebas membida secara purata $49 untuk pekerjaan ini
I'm a computer engineer and I can finish your job soon, you can count on me. Relevant Skills and Experience Excel, Microsoft, data operating, word, and all online work expert.