Approval not appearing in Flow

[RobertPC77]

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):

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

[RobertPC77]

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

[RobElliott]

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

[RobertPC77]

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!

[RobElliott]

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

[RobertPC77]

[RobElliott]

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

[RobertPC77]

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.

[v-bacao-msft]

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.

Best Regards,

[RobertPC77]

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?

[v-bacao-msft]

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,

[RobertPC77]

OK...here it is....

[v-bacao-msft]

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,

[RobertPC77]

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.

 

Perhaps I need to edit the Formula?

Thanks!

[v-bacao-msft]

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,

[RobertPC77]

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

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

[MattWeston365]

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

[RobertPC77]

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

[RobertPC77]

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!

[v-bacao-msft]

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,