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:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

WarrenBelz 153,051 Most Valuable Professional on at

Like (1)

Report
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

Was this reply helpful? Yes No
Zholland 13 on at

Like (0)

Report

Hi @WarrenBelz - That worked perfectly. Thanks!

Was this reply helpful? Yes No