Power Platform Community Forum Thread Details

Hi ,

, I've shared my power app form in the below image

Email is a default column where user email Id is autopopulated when the user tries to login

Default of email : User().Email

Entity is the Combobox where I want to display data on the Basis of the domain of user mailid

item property : Distinct(Table2,'Entity Name')

default selected items of the combobox1 : Table({Result: Parent.Default})

update property of the combobox datacard : ComboBox1.Selected.'Entity'

And the rest of the combobox are dependent combobox on the basis of combobox1 results

I've tried formula in my combobox 1 (Entity), but it displaying data same as from the combox 2 (Company code)

If(Last(FirstN(Split(User().Email,"."),2)).Result="logixhealth",Filter(Table2,"EOP" in Entity),Filter(Table2,!("EOP" in Entity)))

The below image shows the table

if my user email contains the word Logix Health in the mail domain, i want the combobox to display only the data that start with EOP

eg : dannyarcher.logixhealth.com

and if the email doesn't contain the word logixhealth, i want the combobox should displays all the data without EOP

please help me on this

Categories:

Sorting of combobox