cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
JHendricksRC
New Member

Automated Flow Not Working, But Works When I "Test" it.

Can anyone tell me why this flow doesn't work automatically?  I get a notification from the MS Form stating that a response has come in.  When I go into the Flow, I click test, and it sends the way I expect.

 

Any ideas?

flow.png

2 ACCEPTED SOLUTIONS

Accepted Solutions
JHendricksRC
New Member

Re: Automated Flow Not Working, But Works When I "Test" it.

I think that it is finally working now.  I took out the parallel branch and stuck it below in succession.  I would love to see how yours works though... probably better than what I did.

 

 

--- UPDATE ---

It is working inconsistently.  I had items flowing... but my last one has not come back to my email.  I submitted the form 28 minutes ago and the emails haven't kicked out.  Now, I am hoping you can provide a better solution, @ScottShearer 

View solution in original post

Super User
Super User

Re: Automated Flow Not Working, But Works When I "Test" it.

@JHendricksRC 

Here is an example of a simple Flow that should meet your needs.  I send one email but you could easily add a second.  I suspect that you will continue to see inconsistent results unless you break this part out into a separate Flow.

FormsDemo1.jpgFormsDemo2.jpg

 

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Scott

View solution in original post

9 REPLIES 9
Super User
Super User

Re: Automated Flow Not Working, But Works When I "Test" it.

@JHendricksRC 

Can you provide additional detail  - what do you mean by "not working"?  If you mean that the Flow is not starting, please note that it can take up to 15 minutes for a Flow to fire/start depending on your license.  When you test a Flow, it usually starts immediately.

 

 

 

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Scott
JHendricksRC
New Member

Re: Automated Flow Not Working, But Works When I "Test" it.

Hi @ScottShearer,

THanks for replying.  I have created the flow.  I have a form response into Microsoft Form.  I can see it in the Spreadsheet... and I have been sitting here for 60 minutes and it hasn't triggered an email to either the respondent or to me, but I did see the automated message from Microsoft FOrm stating that a form had been submitted.  Does this answer your question?

Super User
Super User

Re: Automated Flow Not Working, But Works When I "Test" it.

@JHendricksRC 

The structure of your Flow looks a little odd.  Usually, after the Forms trigger, you need to have a Get Response Details action which enables you to reference the response data.  See my example below. 

Also, just because you did not receive an email doesn't mean that the Flow didn't run.  Take a look at the previous runs in the Flow properties.  You might see that they have errors associated with them which will be helpful in fixing your issue.

 

FormsResponse1.jpg

Can you post a screen shot showing more of your Flow?

 

 

 

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Scott
JHendricksRC
New Member

Re: Automated Flow Not Working, But Works When I "Test" it.

@ScottShearer 

 

That is the bottom of my flow... there isn't anything else there.  

 

Is there a sample of sending responses from a Microsoft Form Excel Sheet?  I'm confused about the "get responses" and what to put into the unique identifier.

Super User
Super User

Re: Automated Flow Not Working, But Works When I "Test" it.

@JHendricksRC 

It sounds like you have the Forms trigger in the middle of your Flow.  While not technically wrong, it is highly unusual to have multiple triggers in a single Flow.  You may want to have a separate and very simple Flow to send these emails.

If you want to respond to a Forms submission, you have no need to touch Excel - see my example above with Get Response Details.  You may be saving the response details in Excel, but you still don't need to touch Excel to send the emails.

Are you saving the responses in Excel?  Can you give me a better understanding of what your Flow does?

 

 

 

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Scott
JHendricksRC
New Member

Re: Automated Flow Not Working, But Works When I "Test" it.

  1. User Enters Form Data, click submit.
  2. Upon submit, user (who is anonymous based on our configuration of company Office 365) gets an email kicked out to his entered email address as a confirmation
  3. Another an employee gets a message with form entirety and other templated header/footer info with the form's contents.

 

I said spreadsheet before, but the flow doesn't touch the spreadsheet, only Microsoft Forms.  The data itself is sent to a spreadsheet for later manipulation by an admin.  The spreadsheet isn't integrated into the flow.

Super User
Super User

Re: Automated Flow Not Working, But Works When I "Test" it.

@JHendricksRC 

I will provide an example later today.  It will be a separate Flow and be based on the screen shot I provided.

 

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Scott
JHendricksRC
New Member

Re: Automated Flow Not Working, But Works When I "Test" it.

I think that it is finally working now.  I took out the parallel branch and stuck it below in succession.  I would love to see how yours works though... probably better than what I did.

 

 

--- UPDATE ---

It is working inconsistently.  I had items flowing... but my last one has not come back to my email.  I submitted the form 28 minutes ago and the emails haven't kicked out.  Now, I am hoping you can provide a better solution, @ScottShearer 

View solution in original post

Super User
Super User

Re: Automated Flow Not Working, But Works When I "Test" it.

@JHendricksRC 

Here is an example of a simple Flow that should meet your needs.  I send one email but you could easily add a second.  I suspect that you will continue to see inconsistent results unless you break this part out into a separate Flow.

FormsDemo1.jpgFormsDemo2.jpg

 

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Scott

View solution in original post

Helpful resources

Announcements
MBAS Gallery 2020

MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.

firstImage

New Ranks and Rank Icons released on April 21!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power Automate Community!

firstImage

Now Live: Power Virtual Agents Community!

We are excited to announce the launch of Power Virtual Agents Community. Check it out now!

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Community Summit North America

The top training and networking event across the globe for Microsoft Business Applications

Users online (5,703)