Forum Discussion

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

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

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
Silver Contributor
Nov 11, 2021
hannahmarollo it looks like your column type in SharePoint is incorrect; you appear to have set the column type as a number but the response in the form is text. You either need to change the column type in the list to single or multiple lines of text or change the restriction in the form for that question to be number.

Rob
Los Gallardos
Microsoft Power Automate Community Super User
hannahmarollo
Copper Contributor
Nov 10, 2021
RobElliott Here is the message:
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