Power Platform Community Forum Thread Details

List

Flow

So first filter eg requestor = S2

Result approvers = H1 and H2

capture Mails = P8,9,6

H1, H2 = new filterquery requestor

Result approvers = F2,F1(end)

capture Mail = P2,P4

F2 = new filter requestors

Result approvers = F1 (end)

capture Mail = P1

Uniek result mail-array should be P1,P2,P4,P6,P8,P9

What is here the best solution filter array with a array?

Categories:

Filterquery a list column 'firm requestor' and collect and use the column 'firm approver' results to start a new filterquery 'firm requestor' and collect/append the uniek results of column 'representors mail' to a variable until filter requestor = F1.