Power Automate Exchange

Please login or click SIGN UP FOR FREE to create your FlowUG account to join this user group.
 View Only
  • 1.  Microsoft Form submissions not recording in the Excel spreadsheet

    Posted Sep 08, 2020 02:30 AM
    Just this week the Microsoft Form is skipping recording some submissions in the Excel file in the background.  As you can see entries 113 & 114 do not appear.  I know I can find them if I go to the Microsoft Form and manually add in the detail but I am not sure why this is occuring. Has anyone experienced this?  I have checked and this spreadsheet is open in the online (not app version) of Excel.


    Regards, Nadia

     

     

    Nadia Toffetti | Programs and Courses Officer

    Student Credentials
    Griffith University | Nathan campus | QLD 4111 | Bray Centre (N54) Room 2.39
    T +61 7 3735 7884 | email 
    n.toffetti@griffith.edu.au

     

    griffith.edu.au




     Griffith University - CRICOS Provider Number 00233E

     PRIVILEGED - PRIVATE AND CONFIDENTIAL

    This email and any files transmitted with it are intended solely for the use of the addressee(s) and may contain information which is confidential or privileged. If you receive this email and you are not the addressee or responsible for delivery of the email to the addressee(s), please disregard the contents of the email, delete the mail and notify the author immediately

     
     





  • 2.  RE: Microsoft Form submissions not recording in the Excel spreadsheet

    Top Contributor
    Posted Sep 14, 2020 09:06 AM
    I don't have a remedy but I want to remind you that all of these "triggers"  in Power Automate are fake. Everything is done through polling, and it is possible that the polling process misses a few changes every now and then. Plan your processes accordingly.

    ------------------------------
    Lutz
    ------------------------------



  • 3.  RE: Microsoft Form submissions not recording in the Excel spreadsheet

    Bronze Contributor
    Posted Sep 15, 2020 10:32 PM
    Hi Lutz,
    Could you elaborate, or point me to an explanation of polling? That's a new term to me outside of election cycles, and it sounds like an important distinction to understand.
    Thanks,
    -Rob

    ------------------------------
    Rob Clark
    Cambridge
    ------------------------------



  • 4.  RE: Microsoft Form submissions not recording in the Excel spreadsheet

    Top Contributor
    Posted Sep 15, 2020 10:46 PM
    Let's take the OP's process as an example.  The trigger is that a new form response has been submitted, and the action is to record that response in Excel.

    What you think is happening is that Forms tells Power Automate "Hey here is a new form response, you wanted to be notified, now do your stuff". This is usually called event based processing.

    What is actually happening is that Forms doesn't do any of that. In fact, none of the Power Automate connectors do any of that. Instead, Power Automate asks Forms "Hey, can I have your list of forms that have been added since the last time I asked?". "Hey, can you give that to me again?".  "Sorry I need it again"  etc. This is usually called polling.  For a variety of reasons (Shannon/Nyquist, clock differences, network issues etc) the result of the polling may be misleading.  Let's say the polling runs every minute.  A form is created and then immediately modified. The next polling would ask for newly created forms and would miss this one since it is no longer "new".

    With polling there is no 100% guarantee that all "events"  are captured correctly as per the trigger definition.  The OP noticed because the sequence is out of whack. Now you could add a process part that fetches the missing forms entries, but that is post fact. No way to anticipate.

    ------------------------------
    Lutz
    ------------------------------



  • 5.  RE: Microsoft Form submissions not recording in the Excel spreadsheet

    Bronze Contributor
    Posted Sep 15, 2020 10:53 PM
    Thanks, Lutz! That is a great explanation, and absolutely something I'll keep in mind for my triggers.

    ------------------------------
    Rob Clark
    Cambridge
    ------------------------------



  • 6.  RE: Microsoft Form submissions not recording in the Excel spreadsheet

    Silver Contributor
    Posted Sep 16, 2020 04:35 PM
    Why are you having a workflow paste Forms responses into Excel? Microsoft Forms already dumps the responses in an Excel sheet anyway so now you have responses in TWO Excel sheets? And if you build the Form from within SharePoint, Teams or OneDrive, your Excel sheet gets a live connection. Every time you open it, the responses are updated.

    ------------------------------
    Rachel Davis
    Program Manager, Business Operations
    Rockwell Automation
    ------------------------------