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

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

    Hi RobElliott - 

     

    Thanks for your response. I followed you steps, but now I am getting an error. 

    Here is the flow: 

    Thanks,

    Hannah

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

      hannahmarollo I can see nothing wrong with your flow. What is the error message when you click on the date/time of the failed flow?

       

      Rob
      Los Gallardos
      Microsoft Power Automate Community Super User

       

Resources