Power Platform Community Forum Thread Details

I have a combobox that currently looks to an SP list and populates with names from that list, and then based on who is selected, it populates 3 other combo boxes with the delegates for that person like below:

Combobox 1 (cmb_viewrequest_selectapprover) Items:

Filter(col_PSAPApprovals, Role = "Approver")

Comboxboxes 2-5 (all the same):

DefaultSelectedItem: LookUp(col_PSAPApprovals, Title = Parent.Default)

Items: Filter(col_PSAPApprovals, Approver = cmb_viewrequest_selectapprover.Selected.Approver && Role = "Delegate")

Update: cmb_view_firstae.Selected.Title (firstae is the first combo box)

The issue I now have is if cmb_viewrequest_selectapprover is blank, then I want all 3 of the combo boxes to use the phonebook to select a person instead of Filter(col_PSAPApprovals, Approver = cmb_viewrequest_selectapprover.Selected.Approver && Role = "Delegate"), however this causes lots of errors at different times due to the properties of the fields etc.

Is there a way around this? Let me know if you need any more info, thanks

Categories:

Building Power Apps