Hello everyone,
I have the following goal:
The contents from a Microsoft Forms are to be transferred to an Excel file that is stored in SharePoint. This updated file is then to be copied to another folder.
The original template of the Excel file should always remain in its original location. Each time a new form is submitted, the data in the Excel file should be updated and then the updated version copied to the target folder.
During the first run, filling and copying the file works without any problems. However, on the second form submission, the new data is not copied to the file in the target folder. Instead, the file in the target folder still contains the data from the first submission.
When I submit the form a third time, the file contains the data from the second submission, and so on. So the file in the destination folder is always one pass “behind”.Can someone explain to me why the data is only updated and copied correctly on the first run, and how I can solve the problem?
Many thanks for your support!
2
Share
Report
All responses (
Answers (
