Power Platform Community Forum Thread Details

Get 1 item from a column array of 17 items where the 1 item matches the value of another list's field value

Hello! I'm hoping for help on this topic as I have not been successful in finding a solution. I have been searching for a solution for more than 2 months.

Overall what I'm trying to do is match a single value from a SharePoint column array in a list called “LU_Business Segment” (columns: Business Segment, Contact, ID) to a value in a second list called “Members.” The column 'Business Segment' array contains 17 items. Once matched, the flow should write the ID and Contact for the matching Business Segment to the Members list – as well as several other lists and actions that this process uses as it creates logs, time tracking tasks and sends emails.

This flow triggers when an item is created or modified in the 'Members' list. The Members list item contains a text column called Business Segment that has a manually inputted value supplied by a user (choice column).

Source: LU_BusinessSegment list
Business Segment: Implementation
Contact: Fran Lyons
ID: 2

Destination: Members list
Business Segment: Implementation
Contact: <null>

BSgmtID: <null>

I can get the array and select down to just the list of business segments, and I was able to use a Filter array to target the correct match, but I can't figure out how to only return the Source business segment that matches the Destination business segment field in the new/updated Members item. Using the above example, I need to have the automate choose only the Implementation business segment from the Source > Business Segment column.

Before lookups are suggested, the contact value will eventually be written to other lists and forms as this is just part of a large and complex time tracking process, and other flows will trigger from the data being copied. This logic will be reused throughout the series of flows.

I have tried dozens of offered solutions, but they don't fit with this scenario. I have not found a solution that addresses choosing 1 item from an array that can be compared with a second item. My Automate flow is show below, and what you see does work, but it is incomplete.

Thank you in advance for looking at my request!!