Filtering data in Combobox based on User Email

[freshyshreya]

Hi,

In the below pic,

The Items Value shown is for a ComboBox.  I want to filter the values based on User Email.

For Example-

If User Email= shreya@abc.com then United States and Canada should get filtered as Country Values from the list and so on..

The formula which I am trying to put is not working correctly.Please help!

[JR-BejeweledOne]

Your problem is in the Country.Value.   What type of column is Country?

[freshyshreya]

Hi @JR-BejeweledOne ,

Country Value is a Single Line of Text in the SharePoint List.

[JR-BejeweledOne]

Try changing your formula.  Because Country is a single line of text field, you don't need .Value after it.

If(User().Email = "shreya@abc.com", Filter('Zenith Test3', Country = "United States"), User().Email = "aguilar@abc.com", Filter('Zenith Test3', Country = "Qatar"))

[freshyshreya]

Hi @JR-BejeweledOne ,

I removed .Value,still there is no value coming up in the ComboBox,though the formula does not show any error.

Please help!

[JR-BejeweledOne]

Please share your items property for the ComboBox

[freshyshreya]

Hi @JR-BejeweledOne ,

Sharing the items property for the ComboBox below,

Thanks!

[freshyshreya]

Hi @JR-BejeweledOne ,

I tried the below formula as well,still nothing is appearing in the ComboBox.

Please help!

[JR-BejeweledOne]

Two things, you will want to add a default setting and you need to check the DataPane for the Combobox and make sure it's displaying the column you want displayed.   See the image below.  Make sure you have selected the country field.

If(User().Email = "shreya@abc.com", Filter('Zenith Test3', Country = "United States"), User().Email = "aguilar@abc.com", Filter('Zenith Test3', Country = "Qatar"), Country)

[freshyshreya]

Hi @JR-BejeweledOne ,

The formula is working perfectly fine now.

Just need one more clarification from you.In the pic below(marked as 1,2,3,4)

I want to show activity ID status value(2) for the selected country(1) only. I have put the formula and changed the values accordingly in 3 & 4,but the value is not appearing.

Activity ID is a lookup column in SharePoint.Please help me in putting the right formula!