I need automated flow to update the RITM record from 'sysapproval_approver' table

[cp10]

Hello, I have requirement to create new catalog item and automated flow...created below two fields.
1.Request_for (Reference:sys_user)
2.RITM_number (Reference:sc_req_item)

For the flow, 

1) Once the user submits the Form, Approval triggers to Requested_for Manager approval.

2) Once Manager Approved, the RITM state is closed complete and the Flow queries the sysapproval_approver table and queries the Approval for with the RITM_number variable .

2) The related state for the record should be updated to Approved.

I am new to this flow designer and am not able to proceed after manager approval. Could you please guide me how to
query the RITM on flow level.

Thanks.

[SAI VENKATESH]

Hi @cp10 

You can follow the below images:

Thanks and Regards

Sai Venkatesh

[cp10]

Hi @SAI VENKATESH 

Thank you for the reply, that is working perfectly but I need small change on approvals. I want trigger an approval to the RITM (RITM_number) approver manager instead of requestor (Requested_for) manager. Could you please help me on how to achieve this one.

Please find the attached screenshot for reference.

Thanks.

[cp10]

Hi @SAI VENKATESH 

Thank you for the reply, that is working perfectly but I need small change on approvals. I want trigger an approval to the RITM (RITM_number) approver manager instead of requestor (Requested_for) manager. Could you please help me on how to achieve this one.

Please find the attached screenshot for reference.