Solved: PowerApps Customized Form - Using a Multiselect Choice Column to Power a Lookup to a Multi-Select Person Column

I am attempting to recreate a custom application designed in an archaic software by using a combination of a customized PowerApps form and PowerAutomate (Flow).

The requirement is such that the parent list has two columns (Location, Approvers). Most Locations have only one approver; however, some have multiple (in which case all approvers must sign off on the approval). The child list is a form to collect the sign-off of the approvers for their respective locations for employees. In the child list, I have a lookup column (multi-select) that pulls Location from the parent list. I have a PowerApps set up as certain columns hide or display based on the Status of the request (e.g., Approved by Manager, Approved by Area Approvers, etc.).

In the past when I've used Lookup columns for SharePoint lists, you can display additional information in the parent list just by selecting those columns when you create the Lookup column. However, I'm finding the Approvers column (a multi-select person column) is not one of the options I am able to return when I create a Lookup column in the child list when using Location as the primary item in the Lookup. In order to efficiently send emails to the approvers for their respective locations (and avoid having many parallel branches and if statements, and consequently a large Flow), I need to somehow use the child form/list to return the information from the related list. I am not using a true PowerApp, but rather a customized form within PowerApps.

Does anyone have any ideas of how to get the Approvers names in a column in the child list, pulling from the parent list?

Categories:

General Questions