Yes @karan15 This can be done.
Navigate to > Notifications> open your notification that is attached in flow designer.
Under "what it will contain" section inside Message HTML add this
Please approve ${sysapproval.URI_REF}
FYI- ${sysapproval.URI_REF} will have a link which takes them to RITM.
Please mark as helpful and correct so that, it would reach out to people who are looking for this same query. Also, if you are happy with the solution, can you please mark it as solved?
Happy to help 🙂
Hello @karan15
You can run the flow everyday at 5 am or whichever the time required for the trigger condition. Add a "Lookup record" action to Approvals[sysapproval_approver] table and give the condition required. Please refer to the screenshot I attached, for reference on how exactly I tried to apply the filter for your requirement.
After adding Lookup action, add a "for-each item" flow logic and drag and drop "Approval Record" from the right panel under "Lookup record" and inside "for-each" logic, add "Send notification" action and in the record field drag and drop "Approval Record" from the right panel under "Lookup record" and select the notification you need to send. Also, while configuring notification give table as Approvals[sysapproval_approver] " and, in "when to send" section select triggerd and "who will receive" section select Approver in users/groups in field.
FYI- The condition applies to every RITM. You can also select for specific catalog as well in the flow.
Please mark my answer as helpful, if you did find it helpful. Happy to help 🙂
