Approval Workflow - Separate Approvals by Field Data

[sbranum]

I am working to create an approval workflow based on data populated into a spreadsheet/table.  Ideally, I would be able to present the data in a user-friendly format (sort of a "roster" type of format) in Power Automate for the assigned individual to approve.  Sounds simple; however, I want to present multiple rows from the table for approval, and, I want to create separate approvals based on a value in one of the columns.  That is, if Joe Smith works in two departments, but has several customers in each department, I want all of the customers for department one in an approval and all the customers for department two in another approval.

Here is a visual example using a table I created with fake names, data, etc.  In the table below, I would like to send an approval to JSMITH23 for the Acquisitions department which displays all of the customers (and any other field data I want) for that department.  I would like to also send a different approval for JSMITH23 for the Accounts Payable which displays any customers and other field data I would like.  We need each approval to only display customers in those respective departments - and only for the Approval ID we designate (for security purposes). 

User ID	Department	Approval ID	Customer Name
JSMITH23	Acquisitions	JSMITH23!ACQ	Daniel Rodriguez
JSMITH23	Acquisitions	JSMITH23!ACQ	Robin Nguyen
JSMITH23	Accounts Payable	JSMITH23!APY	Sherry Wilson
RDAVIS7	Accounts Payable	RDAVIS7!APY	Andrew Barnes
JJOHNSON1	Maintenance	JJOHNSON1!MNT	Celina Edwards

In this specific example, all the customers for JSMITH23!ACQ would be on one approval, JSMITH23!APY on another approval, etc.

Is this possible?  Thank you for any help you can offer.

[Krishna92]

@sbranum 

If this is stored over a Share point list, then you can make use of GET ITEMS action to retrieve information present in the list.

Once you get the required information you can use FILTER ARRAY action and specify condition that you want the array to be filtered.

This will show the filtered output value and from here you can exact specific field value using PARSE JSON action and pass it to approval step.

If this information helps you with resolution, please consider giving a thumbs up and mark the solution as resolved.