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
Solved! Go to Solution.
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
Also...I do not yet have access to Office 365 Outlook. It is coming though...
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
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.
Best Regards,
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,
OK...here it is....
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,
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!
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:
Hope it helps.
Best Regards,
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).
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,
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.
At the monthly call, connect with other leaders and find out how community makes your experience even better.
User | Count |
---|---|
25 | |
24 | |
24 | |
21 | |
17 |
User | Count |
---|---|
56 | |
39 | |
38 | |
30 | |
30 |