Microsoftkenwashington Thank you very much! Power Automate is not workling for our usecase with quiz, because the Forms Connector in Power Querry is not offering the Points for the questions. So we do not know if the question was answered correct or not. I know i can mark every question, but we have minimum 20 questions per quiz and 5 active quizzies at the moment. The number of quizzies is rising.
Our Power Querry code is converting all Excel Form Files in a folder in that way, that we get a data table with the master data at the beginning, an then one column with the question, answer and point. Then we can combine all forms and have one big base table, which is graet for analysis.
I solved the refresh of the excel Files, very simple 😄 I put the excel online Files in the autostart of edge, so they are updated every morning when i start working.
