Power Platform Community Forum Thread Details

I am hoping someone can help me. I have tried everything and cannot get this to work. I have a Form where I have a ComboBox called DivRWA. This field is from a sharepoint list called RWA Request Form. In the same Form, I have a Combo Box called cbBUContractsMGR that is pulling from another sharepoint list called RWA Approver Matrix. The Divsion Field of this sharepoint list Contains the data from the DIVRWA field in my form.

When someone selects "TEST" in the Division Field in my form. I need the BU Contracts Manager dropdown to list the name of the BU Contracts Manager for that Division in the field. Any ideas?

Hi @Brook0131

To filter the cbBUContractsMGR ComboBox in your form based on the selected value in the DivRWA ComboBox, follow these steps:

Set the Items property for the DivRWA ComboBox to list distinct values from the Division field of the RWA Request Form SharePoint list:

Distinct(RWARequestForm, Division)

Set the Items property for the cbBUContractsMGR ComboBox to filter based on the selected value in DivRWA and display the relevant BU Contracts Manager from the RWA Approver Matrix SharePoint list:

Filter(RWAApproverMatrix, Division = DivRWA.Selected.Value).BUContractsManager

This configuration will ensure that when someone selects a division in the DivRWA ComboBox, the cbBUContractsMGR ComboBox will list the names of the BU Contracts Manager for that selected division.

If my response resolved your issue, please feel free to mark it as the solution by clicking "Accept as solution." This helps others find the answer more easily. If you found the content helpful in any other way, a "Thumbs Up" would be greatly appreciated. Thank you!