Announcements
Team,
I am trying to enable the field based on the user. However, it is not working as expected. The Status field should have been enabled for me as I am part of the I2EAdmins SP list as an Admin. Attached is the screenshot for your reference. Appreciate your help.
Regards,
Alwin Selvaraj
LookUp returns the first row that matches your formula (Jyoti Batra in this case).
You can try using a Filter instead of LookUp, or modifying your LookUp to something like this:
If(LookUp(I2EAdmins, Admin.Email = User().Email).Title = "Admin", Edit, Disabled)
Free typed based on your LookUp so there might be errors, but you should get the idea.
Thanks, @Aapok . I changed the formula as you suggested, and it works fine.
Alwin
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.
WarrenBelz 358 Most Valuable Professional
11manish 207 Super User 2026 Season 2
MS.Ragavendar 150 Super User 2026 Season 2