Answered

Help with Combo Box - Filtered and multiple select Person field

(1) Share

Report

Posted on by Zholland

I am working on an app and need help with a Combo Box. I have a list of Legal Entities and approvers for that entity. When the entity is selected in the app, I need the next combo box to show me the selected person(s) in the Approver column. Example information below.

Data Source: SharePoint List
Column-Legal Entity: Choice
Column-Legal Entity Approver: Person / Multiple Select

SharePoint

Canvas App

Items Property

Categories:

General Questions

Using Apps Using Formulas

All responses (2)

Answers (1)

Zholland 13 on at

Like (0)

Report

Help with Combo Box - Filtered and multiple select Person field

Hi @WarrenBelz - That worked perfectly. Thanks!
Verified answer

WarrenBelz 146,668 Most Valuable Professional on at

Like (1)

Report
Help with Combo Box - Filtered and multiple select Person field

Hi Zholland

Based on the data source image you posted, try
Ungroup( Filter( SPList, 'Legal Entity'.Value = Drop_LegalEntity.Selected.Value ), 'Legal Entity Approver' )

Please click Does this answer your question if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it a Like.
MVP (Business Applications) Visit my blog Practical Power Apps Buy me a coffee