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

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

@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
ScottShearer
Super User III
Super User III

@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

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?

@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

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

@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

  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.

@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

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

@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
Process Advisor

Introducing Process Advisor

Check out the new Process Advisor community forum board!

MPA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

V3_PVA CAmpaign Carousel.png

Community Challenge - Giveaways!

Participate in the Power Virtual Agents Community Challenge

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Carousel April Dunnam Updated 768x460.jpg

Urdu Hindi D365 Bootcamp

Dont miss our very own April Dunnam’s The Developer Guide to the Galaxy! Find out what the Power Platform has to offer for the traditional developer.

Users online (2,559)