Forum Discussion
Form Responses not recording in excel on a consistent basis.
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.I'm not sure why the secondary table creation would prevent the initial population of information from the form. The population of table 1 happens (or should happen) outside of power automate. Here is a snip of the start of the process:
I don't know why the server would take less than a second to retrieve the information for power automate but time out prior to submission on table 1??
Any help would be appreciated.
