Announcements
Hi @cyberco01
If(If(!IsBlank(ThisItem.Author.Email),Office365Users.Manager(ThisItem.Author.Email).Mail = User().Email,true) || User().Email = "abc@xyz.com" || User().Email = "mno@xyz.com",Edit,View)
Where are you applying the formula? I put essentially the same formula in the DisplayMode property on an EditForm Data Card and it worked fine. It did give me an error before I ran it, but that was because the properties were empty prior to the first run. Here's the formula I used.
If(Office365Users.ManagerV2(ThisItem.'Created By'.Email).mail=User().Email||User().Email="xyz@company.com",DisplayMode.Edit,DisplayMode.Disabled)
Note that I used 'Created By' rather than Author. My list doesn't have an Author Field
Hi @cyberco01 how are you progressing with this? Were the above replies helpful?
@Anonymous
Hi @Anonymous ,
I applied the formula suggested by @Pstork1, I am yet to test it to confirm the same. I will surely close this once I am confirmed testing.
@Pstork1 ,
I tried below formula in the visible property of my datacard but it does not work. I need to display the data card only for the manager of the List Item created user.
If(User().Email=(Office365Users.Manager(ThisItem.'Created By'.Email).Mail),true, false)
@Pstork1 , Below is my error
Office365Users.ManagerV2 failed: The method 'ManagerV2' has an invalid value for parameter 'id'
Two suggestions.
1) I would save the email address of the current user in the App OnStart. That will make the formulas more efficient
Set(currentUser, User().Email)
2) I would use this for the comparison in the visible property
StartsWith(Office365Users.Manager(currentUser).Mail,currentUser)
In my scenario i need to store the email address of Author/Created By user of the list item(record) and not the logged in user. I am stuck with syntax at that place.
Sorry, I made a mistake in the function I gave you. It should be
StartsWith(Office365Users.Manager(ThisItem.'Created By'.Email).Mail,currentUser)
No luck. I am getting same message as before.
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 333 Most Valuable Professional
11manish 184
MS.Ragavendar 86 Super User 2026 Season 1
