Forum Discussion

Lokyz8's avatar
Lokyz8
Copper Contributor
Apr 08, 2020

Incomplete or empty forms responses (Web App)

Hello,   I created a dozen of forms using only the web app. I used theses forms everyday for the last 3 weeks and it worked great, with a flow getting the responses into an Excel worksheet.   Bu...
microsoft forms
Poll
Yao Ke's avatar
Yao Ke
Icon for Microsoft rankMicrosoft
Apr 09, 2020

SamiMarzouki Sorry for the inconvenience, we had a bug caused this, this was resolved around 12:30 PM PST, but the previously lost response likert data cannot be recovered. 

hannahmarollo's avatar
hannahmarollo
Copper Contributor
Nov 05, 2021

Yao Ke - I am also experiencing this issue, though it looks like the bug was resolved back in April of 2020. Is something else going wrong? The form worked for me a week ago, but now when people submit answers the responses come back as completely blank. 

  • Jessie Chen's avatar
    Jessie Chen
    Icon for Microsoft rankMicrosoft
    Nov 08, 2021

    hannahmarollo Thanks for reporting the issue. For the missing response, do you mean the response data missing in the Excel file or in the Forms web under the "Responses" tab?

    • hannahmarollo's avatar
      hannahmarollo
      Copper Contributor
      Nov 09, 2021

      Hi Jessie Chen - Thanks for your response!

       

      The responses show in the form (and if you export to excel), but they don't show in the SharePoint List that I created that populates the responses. It was working last week, but on Friday it stopped populating the responses at all. 

       

      Here is how the flow looks now. 

       

      Thanks,

      Hannah

      • RobElliott's avatar
        RobElliott
        Silver Contributor
        Nov 09, 2021

        hannahmarollo do NOT use the Forms template to create your flow in Power Automate. It puts in that apply to each which is unnecessary, incorrect and causes the sort of problems you have experienced. I don't know why Microsoft haven't corrected it. Build your flow from new putting the get response details action immediately after the when a new response is submitted trigger.

         

         

         

         

         

         

        Rob
        Los Gallardos
        Microsoft Power Automate Community Super User

Resources