If(If(!IsBlank(ThisItem.Author.Email),Office365Users.Manager(ThisItem.Author.Email).Mail = User().Email,true) || User().Email = "firstname.lastname@example.org" || User().Email = "email@example.com",Edit,View)Hope this Helps!
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.
Note that I used 'Created By' rather than Author. My list doesn't have an Author Field
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.
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)
1) I would save the email address of the current user in the App OnStart. That will make the formulas more efficient
2) I would use this for the comparison in the visible property
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
Stay up tp date on the latest blogs and activities in the community News & Announcements.
Mark your calendars and join us for the next Power Apps Community Call on January 20th, 8a PST
Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.
Watch Nick Doelman's session from the 2020 Power Platform Community Conference on demand!