cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
RobertPC77
Level: Powered On

Flow not completing

I have been working on a MS FLOW that I can't seem to get quite right.

 

Here is the process I have in mind: 

  1. In a school setting, someone completes an online application in MS FORMS to apply for admission to a special program. 
  2. The form is then sent to a Sharepoint Library where answers are compiled into a document that can be downloaded for review. 
  3. At this point, an Approval is sent to a designated administrator who is notified to go to the MS FLOW Approvals site to go to the Sharepoint site, download and review the Application, then return to the Approvals site in MS FLOW to Approve or Reject. 
  4. Upon completion of this step, the Approval Status of the Document in SP should change to Approved
  5. Notification email should be sent to the Registrar to begin the Enrollment Process.

Everything seems to work well through #3 above.  However, #4 and #5 never occur.  Also, if at all possible, I would like to simplify #3 seems to be cumbersome for a school administrator who does not spend a lot of time in Sharepoint and Flow.

 

I'm open to suggestions.  Thank you in advance for your help!

 

part 1.JPGPart 1part 2.JPGPart 2part 3.JPGPart 3

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: Flow not completing

Hi @RobertPC77 I hope you're feeling better. Not a problem, I've been jetting around the UK so I've not been able to get back on  until now either.

 

The Create File action will generate an ETag which will appear in the dynamic content. So when the Set Approval requests an ETag, you can take the ETag dynamic content from Create File 2. This cleared the error for me.





Did my reply help? Please give it a thumbs up.
Did I answer your question? Please mark my post as a solution!


Proud to be a Flownaut!





Community Leader: Black Country PowerApps & Flow User Group

View solution in original post

11 REPLIES 11
Super User
Super User

Re: Flow not completing

Hi @RobertPC77 what actually happens when you Flow is running? Does it show as success or skipped for those last steps? Or does it just not move on from the Approval action?





Did my reply help? Please give it a thumbs up.
Did I answer your question? Please mark my post as a solution!


Proud to be a Flownaut!





Community Leader: Black Country PowerApps & Flow User Group

RobertPC77
Level: Powered On

Re: Flow not completing

Hi @MattWeston365 -  Thank you for inquiring!  

 

What actually happens is that the nothing ever happens following the Approval of the Reviewer.  The result of the Approval never shows in the Approval Status column in the SP site.  Nor does a notification go out to the Registrar to begin the next step in the Process.

 

Thank you for your help!

Super User
Super User

Re: Flow not completing

In the flow run history, does the approval show as successful? Is there a condition or other action before the update to the SharePoint list?




Did my reply help? Please give it a thumbs up.
Did I answer your question? Please mark my post as a solution!


Proud to be a Flownaut!





Community Leader: Black Country PowerApps & Flow User Group

RobertPC77
Level: Powered On

Re: Flow not completing

@MattWeston365   It shows that it did not succeed.  There is no other condition or action before the update to the Sharepoint List.

Super User
Super User

Re: Flow not completing

Strange. So the approval step shows a green tick? Or is it still yellow? Then the Flow marks itself as completed but hasn’t fired the last couple of steps. Can you post a screenshot of the Flow history of one of the runs please?




Did my reply help? Please give it a thumbs up.
Did I answer your question? Please mark my post as a solution!


Proud to be a Flownaut!





Community Leader: Black Country PowerApps & Flow User Group

RobertPC77
Level: Powered On

Re: Flow not completing

@MattWeston365 

 

Hi Matt, I'm sorry I haven't gotten back sooner...Thank you for your patience!  I went home sick yesterday, but am feeling much better now!

 

Here is a pic of the Run I did yesterday.  The problem may be with the lack of an Etag.  Last week, I tried inserting an Etag, but I kept running into errors when I tried to insert the SP, get Metafile data Action.  I believe this is what I need in order to draw an Etag from.

 

Part 4.JPG

Super User
Super User

Re: Flow not completing

Hi @RobertPC77 if you take the ETag dynamic content from your Create File 2 action then the approval should start to work. Have you also enabled Content Approval on the SharePoint Document library itself?





Did my reply help? Please give it a thumbs up.
Did I answer your question? Please mark my post as a solution!


Proud to be a Flownaut!





Community Leader: Black Country PowerApps & Flow User Group

RobertPC77
Level: Powered On

Re: Flow not completing

@MattWeston365   Hi Matt!  I'm sorry it has taken me so long to reapond. I had Medical Appointments scheduled yesterday.

 

When you refer to removing the ETag info from the Create File 2, do you mean removing the info in the File Content area?  I see no other content that resembles ETag information.

 

The Sharepoint Library does have Content Settings Approval required turned on.

 

Thank you for your assistance!

Super User
Super User

Re: Flow not completing

Hi @RobertPC77 I hope you're feeling better. Not a problem, I've been jetting around the UK so I've not been able to get back on  until now either.

 

The Create File action will generate an ETag which will appear in the dynamic content. So when the Set Approval requests an ETag, you can take the ETag dynamic content from Create File 2. This cleared the error for me.





Did my reply help? Please give it a thumbs up.
Did I answer your question? Please mark my post as a solution!


Proud to be a Flownaut!





Community Leader: Black Country PowerApps & Flow User Group

View solution in original post

RobertPC77
Level: Powered On

Re: Flow not completing

It worked as you said.  I think the issue I was having was somewhere I read that I had to put in a Sharepoint - Get the Metadata action.  However, I have learned from the error of my ways!

 

Thank you, Mr. Weston!  You have helped me for a second time!

RobertPC77
Level: Powered On

Re: Flow not completing

@MattWeston365 Hi again!

 

We ran the Flow this morning...a real student completed the Application in MS Forms.  I got the notification as well as the lady who is the Primary Reviewer.  When she selects the student's name in the email, it opens up in the FLOW Approvals Center.  She is then to select the link to the student file and see it in the Sharepoint site.

 

Problem: The Primary Reviewer does not see the student in the Sharepoint Site.  I log in to the Sharepoint Site and I can see it, but she is not able to see the new entry in the Document Library.

 

Could I be missing a setting, maybe in Sharepoint versioning?

Helpful resources

Announcements
firstImage

Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

firstImage

Watch Sessions On Demand!

Continue your learning in our online communities.

Power Platform 2019 Release Wave 2 Plan

Power Platform 2019 Release Wave 2 Plan

Features releasing from October 2019 through March 2020.

thirdimage

Flow Community User Group Member Badge

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

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Flow Community Video Gallery!

Top Kudoed Authors
Users Online
Currently online: 93 members 3,687 guests
Please welcome our newest community members: