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 ...
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)
-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.
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.
I have no experience on power automate.
According to the information from you provided and Internet, It may not handle too many steps which consume long time.
If the business logical too complex,I guess you may find another ways(like PHP/java) to achieve your goal.- But the error is happening BEFORE the Power Automate process starts. The form is simply (and intermittently) not populating on the table.
Power Automate is essentially monitoring (and showing that data is present - somewhere...).