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
-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.
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.
