Power Platform Community Forum Thread Details

Hello PowerApps Community!
We have two departments maintaining two separate SharePoint Lists. My app is trying to use information from each.

I have the following things built:

SharePoint List: "SPOUs" (2 columns: "Title" and "OUs")

SharePoint List: "SPMDs" (2 columns: "Title" and "MDs") The "Title" column contains records of only three letters.

ComboBox: "Combo_OUs"

> OnSelect: ClearCollect( Collection_OUs, GroupBy( Filter( 'SPOUs',Title <> "LSA" ),"OU","OU"))

> Items: Collection_OUs

ComboBox: Combo_MDs

> OnSelect: ???

> Items: ???

The user uses Combo_OUs to select the OUs they want.
I now want that the following to happen:
1. Concat the list of selected OUs (again, these originally reside in SharePoint List "SPOUs"), but only the first three letters of each selection.
2. Query the SharePoint List "SPMDs" to find records where the "Title" column matches any of the first-three-letter-values from (a).
3. Create a collection of the corresponding "MDs." I also want this list to have distinct (non-repeating) values.

PLEASE let me know if I need to clarify. In essence, creating a collection of OUs from one SharePoint list should create a collection of MDs from a different SharePoint List. The first three letters of the selected OUs are matched to the Title column of the second SharePoint List to find the corresponding, distinct MDs.

Thank you all in advance for your assistance. This is probably the most complex piece of PowerFx I've tried to tackle and have gotten stuck many times.

Categories:

Building Power Apps