How to get the list of ticket number stored in sysapproval field in Approval table via flow designer
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎01-31-2025 02:18 AM
Hi All,
I have a requirement where in when a user becomes inactive, I want to submit a catalog item request where in the ritm of the new request, I need to fetch the list of pending ticket numbers(sysapproval field) from Approval table assigned to the user who became inactive and need to print these ticket numbers in the ritm description.
I created a flow and did following configurations-
Trigger- user becomes inactive
1. Look up record- table- sysapproval_approver and approver is-> Trigger->user record
2. Look up records- table- sysapproval_approver, approver is-> Step1-> approval record->approver and state is requested
3. Foreach activity-> Step2->Approval Record
4. Added a custom action GetPendingApprovalTickets and gave input as-> step3 foreach->approval
5. Create a string flow variable and set the variable as the output of the custom action -> Step4- ticket number
Below is the custom action script-
The issue now is although I am having 2 approval records in lookup records activity, but from foreach only 1 record is sent in custom action input due to which I am not able to get the list of ticket numbers.
I am getting only 1 ticket number at at time
Can any help me to get all the ticket numbers once at a time and set it in the flow variable OR directly in the ritm description?
Any help will be appreciated.
Thank you!