- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-13-2025 04:20 AM
Hi everyone,
I'm working on a catalog item flow ("New Hire") that includes two approval steps. I need to implement a reminder notification if the first approver does not respond within 3 days.
Here's what I'm trying to achieve:
After sending the first approval, wait up to 3 days.
If the approval is still in "requested" state after 3 days (i.e., no action taken), send an email reminder to the approver.
If the approval is completed earlier, the flow should continue without waiting the full 3 days or sending a reminder.
What I’ve done so far:
Used a Wait for Condition with a 72h timeout.
Then added a Lookup Record on sysapproval_approver to retrieve the relevant approval record using document_id, approver, and state = requested.
Followed by an If condition and Send Notification action.
My challenge:
In Flow Designer, I had difficulty finding the document_id field in the sysapproval_approver table. I had to type it manually.
Is this the recommended approach?
Would you suggest a better way to reliably identify the pending approval and check its state after timeout?
I add some photos of my Flow (I deleted what i did here to start a "clean" solution)
Thanks in advance!
Itay.
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-15-2025 06:35 AM
Finally I realized that I could use another FLOW,
I executed it on the authorization table and now everything works.
Thank you very much everyone for the help and effort.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-14-2025 05:47 AM
as you can see the flow not working well becouse the flow is waiting for the approve of the first manager before the look up records and before wait for condition..
maybe you can help me with another option that can solution this issue ?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-14-2025 06:09 AM - edited 07-14-2025 06:15 AM
Hi @ItayB
For this, Use Do the following in parallel condition, use 1st approval, wait condition and fire event under that action. Event will be fired after desired wait.
If your question is answered, accept it as solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-14-2025 06:18 AM
Like this
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-15-2025 05:10 AM
Hi @ItayB Did you try this?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-14-2025 05:57 AM
Add a new reminder flow on sysapproval_approver table. Ask for approval will remain in pending until it is approved skipped or cancelled.