Forum Discussion
Form Responses not recording in excel on a consistent basis.
I have created a Form for Excel in OneDrive and used the resulting tables to preform a multitude of other actions via Power Automate (it is NOT the excel document that is generated from the response page of the form).
It is intermittently (and seemingly for no reasons) failing to collect responses from the form (see pic):
In this example - I know for certain that #'s 69, 71, 73 & 74 were properly entered. Resynching to a new worksheet is not an option as there is a great deal of automation attached to this sheet. Any idea why it would randomly skip entries? Creating quite the mess
14 Replies
- UPDATE 8-23-22
This post has 265 views and I have received a couple of personal messages asking if there was a resolution (one individual has PM disabled so I cannot answer)...sorry to report that this does not have a resolution yet, though it is clearly generating interest - anyone....anyone...?I experienced this today as well - response #38 is shown in the list of responses inside MS Forms but it is missing from the synced Excel spreadsheet. No obvious rhyme or reason.
Could you please clarify a bit
- you have Excel file which is automatically updates with Forms responses
- in the table of this file you have no missed responses, i.e. all from 67to 75
- with Power Automate you call the table from that file and something is missed
or
- you have Excel file on OneDrive
- Power Automate which is triggered on each response updates the table in that file
- and here some responses are missed
- Neither one of those are quite right... Let me phrase it like this:
-I have an excel file (table) which is NOT updating with form responses consistently.
-I DO have missed responses in the table.
-The only pattern I can discern is that it is always the first entry of the day - but it also recurs later
-My mention of the Power Automate process is to point out that the table of responses is used to create several secondary tables and perform a variety of tasks based on these responses (I only included this as I believe it might preclude some of the typical fixes to form functionality).
Hope this helps narrow it down (you were MOST helpful with a script problem I had)- It is intermittently (and seemingly for no reasons)
table of responses is used to create several secondary tables
Because of intermittent happened,How about not create secondary tables?
I guess it maybe time out on server side.
