Get Metadata from a SPO List from a SPO Library Approval FLOW
I have a SPO 2019 Site where there is a Document library and a List.
The List contains names of Approvers per Agency.
When a document is uploaded to the library, name of the Agency to which this document belongs to, is identified and an Approval Flow is triggered.
During each review/Approval step, how can I do a lookup within my Approval FLOW (connected to the SPO library and triggered by the document upload) to a separate SharePoint List to retrieve next Approver's name upon success of the first Approval?