Announcements
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!
Your problem is in the Country.Value. What type of column is Country?
Hi @JR-BejeweledOne ,
Country Value is a Single Line of Text in the SharePoint List.
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"))
I removed .Value,still there is no value coming up in the ComboBox,though the formula does not show any error.
Please help!
Please share your items property for the ComboBox
Sharing the items property for the ComboBox below,
Thanks!
I tried the below formula as well,still nothing is appearing in the ComboBox.
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)
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!
Did you check your data pane and make sure you have selected the right column to display in the 'Edit field' section?
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
11manish 393 Super User 2026 Season 2
Mohsin Ali 328
WarrenBelz 278 Most Valuable Professional
