Share
ReportHi everyone, I'm still a newbie with PowerAutomate, I'm trying to automate this :
I want to automatically retrieve the answers from a form, and increment them in a unique excel file for each answer: A user answers 60 questions on forms, and a unique excel file is created compiling these 60 answers
For this I created an Excel Template file, to which I add a line for each answer (thanks to the block, add a line to a table), then I copy and paste this file in another folder by changing the name and applying a script that will duplicate the answers of the last line in a canva.
But I sometimes have a little problem: the script runs without error, I receive the email telling me that someone has answered my questionnaire, but the line is not added to my Excel Template file, so the script runs on the previous answer... This problem happens quite regularly but in a completely random way. I tried to add some delay between the different blocks but nothing works...
(I'll give you screenshot of my flow in the answer of this topic)
Does anyone have a solution? Thanks in advance !
All responses (
Answers (
233
