cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
RobertPC77
Helper II
Helper II

Approval not appearing in Flow

One Last step.....Thanks to the guidance of you wonderful folks, my first Flows are working well!  Now for the last part...My goal is to look into my Sharepoint List under a specific column to begin an Approval when a certain date appears.  Here is my Flow (I apologize for it being so long):

Inked1a_LI.jpg

 

Inked1b_LI.jpg

 

1c.PNG

 

I get the notification to check in my Approvals tab...but there are no Approvals appearing there.  Thank you in advance for any help you can offer!

 

Respectfully,

 

Robert

1 ACCEPTED SOLUTION

Accepted Solutions

I've had a Teams session with @RobertPC77 tonight as I think a lot of us were missing the real issue with the Flow. The main issue was that the bulk of the Flow was running even when it shouldn't i.e. if no results were being returned from Get Items then it wasn't terminating (no point running if there's nothing to process).

 

We have walked through the Flow and have added a condition directly after the Get Items to evaluate if any items have been returned by using the expression:

length(body('Get_items')?['value'])

If there are no items being returned, the length will be 0, so our condition is that if the length is greater than 0, we will send the notification and initiate the further approvals

 

We've done some basic testing and all seems to be working 🙂

 

Thank you to everyone in the thread for assisting, it seems we're there and have another happy member of the Flow family!

 

If you have found this post useful, please give it a thumbs up. If it has answered your question, please accept it as the solution so others can benefit.

@MattWeston365

View solution in original post

26 REPLIES 26
RobertPC77
Helper II
Helper II

Also...I do not yet have access to Office 365 Outlook.  It is coming though...

RobElliott
Super User
Super User

I suggest you use "Start and wait for approval (v2)" rather than the "Create an approval". Also personally I wouldn't use the premium approval type as I think that needs a specific licence though I could be wrong, but it might explain why you are not getting the approval email. I would then use the white-on-green envelope "send an email notification" if you're not on Office 365 Outlook yet. Hope something there helps a bit.

Rob
Los Gallardos

 

I've tried the Green Envelope Mail...but I never receive anything from it....so for right now, I am stuck with the Notifications.

 

I will switch to the Create and Wait for an Approval. v2 and Wait for First to Respond. 

 

THank you!

Could you add the green envelope Send an email notification and then post a screenshot of what you've put in it?

Thanks

Rob
Los Gallardos

1d.PNG

 

Thanks. There's nothing obviously wrong there but one thing I have sometimes found with flow is that it needs the whole email address in the To field to be added before actually pickig the recipient. Odd I know so you might want to try deleting the recipient in the To field then typing the whole email address. 

Rob
Los Gallardos

Actually, that is what I do, but Office 365 recognizes my id and inserts my organizational ID.  Everythings says that step works, but I never get an email using this email action.

Hi @RobertPC77 ,

 

Please check if Body of Get items is an empty array. If Body is empty, the action in Apply to each cannot be executed.

 

Even if the Flow display runs successfully, Create an approval (V2) action and Send an email notification are not executed.

54.PNG

 

Best Regards,

Community Support Team _ Barry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hi Barry!

Thanks for noticing that!  I ran it once and it says it succeeded...even though the process did not complete the process.  There is data available to pull, an approval should have been started and a notification should have been sent to notify that there was an action in the approvals to be taken.  

 

Suggestions?

Hi @RobertPC77 ,

 

Please provide a screenshot of Body for Get items action?

If the situation is the same as I described, Approval action and Send notification action will not be executed.

May be the condition you configured in Filter Query, resulting in no eligible items being obtained.

You could try to not configure Filter Query and see if similar suitation still exists.

 

Best Regards,

Community Support Team _ Barry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

OK...here it is....

5.20.19.JPG

Hi @RobertPC77 ,

 

It seems that the reason for the problem is found. It seems that the filter conditions you configured in Filter Query exclude all items.

 

So the body of Get items is empty.

 

You can click Show more to view the contents of Filter Query and check if there are eligible items.

 

Best Regards,

Community Support Team _ Barry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

I'm sorry I've been out...wife was in hospital and I have been unable to correspond.  I am attaching a pic that shows what the value grabbed in the UTCnow.  The purpose was for the Flow to grab a particular date every day if it matched that date and send the info for approval.

 5.23.19a.JPG

 

Perhaps I need to edit the Formula?

 

Thanks!

Hi @RobertPC77 ,

 

Sorry for my late reply.

Please run Flow and view the specific details in Filter Query.

Then check if there are any eligible items in the list.

 

If you want to filter whether the specified date field value is the current date, please note the following:

  • Check whether the field name configured in Filter Query is correct. Sometimes, the field name in Odata Query and the field name displayed in the list will be inconsistent. You could configure Get items action without Filter query first, then observe the name of this field in Body.
  • It seems that you need to change gt to eq.
  • If the date field contains time, you don't need to format utcNow() as ‘MM-dd-yyyy’.

 

Hope it helps.

 

Best Regards,

Community Support Team _ Barry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

OK...I changed the gt to eq...as you can see it did indeed produce a value.....

 

5.30.19a.JPG

 

However, the Flow stalled when it pass through to the next module where it was to Apply to Each Start and get an Approval (v2).

 

5.30.19b.JPG

Hi @RobertPC77 that screenshot would suggest to me that it is now waiting for an approval. Are you still not seeing anything appear in the Approval Centre?

 

If you have found this post useful, please give it a thumbs up. If it has answered your question, please accept it as the solution so others can benefit.

@MattWeston365

That solved it!  I believe this Flow is now working as desired!  THANK YOU!

Well...almost solved.

 

This morning, the Flow ran and sent me an alert.  However, there was nothing in the column with today's date in it.  In this situation, my hope is that there is no alert sent.

 

How can I modify to take no action if there is nothing to get?

 

Thanks in advance!

Hi @RobertPC77 ,

 

What  do you mean “However, there was nothing in the column with today's date in it.”?

Please provide more details with screenshoot to clarify your  needs.

 

Best Regards,

Community Support Team _ Barry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Solution Authors
Users online (3,614)