Announcements
Hi All,
Im looking to hide the selected data card when the users email matches the "Approver Email (E1)" field. Help!
Hi @apirez ,
Put this at App OnStart
Set(varUserMail,User().Email)
then the Visible of the card
ThisItem.'Approver Email (E1)' <> varUserMail
Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.
Hi Warren,
So I tried that and it worked for the first set of datacards where the email in the field is mine. When i went on to the fields where my email is not in the referenced field, its still visible. Am I missing something ?
No (you did not miss anything) - you asked it to be visible as long as the email was not that of the Approver - and a blank email is not the approver. To exclude blank emails you would need
ThisItem.'Approver Email (E1)' <> varUserMail && !IsBlank(ThisItem.'Approver Email (E1)')
My apologies. I just blanked out the email. There is an email there that is not mine. I think I worded my title incorrectly. Basically I am looking to hide the datacards if the email of the user is not the email in that field (whether mine or not). With your formula, it showed the first set (my email was in the box). The second set is not my email and its still showing. I appreciate your help!
I'll also add that there are 9 sets of fields, 3 each, that all have different emails. I want the user, who is an approver, to only see the items that are assigned to them via the email field. Thanks so much !
One more thing that may be a clue. That email field is the result of a formula in the entry app that’s uses the Office365users connection to get the managers name of the nominee. It’s not a straight text entry field. Thank you I’m desperate!
@apirez ,
I must admit I am a little confused here - firstly (and most importantly), exactly what type of field is 'Approver Email (E1)' and how is its contents created?
Also what exactly do you mean when referring to 9 sets of fields?
It is a good idea to post all of this in your initial thread as your post seemed to be a fairly simple question.
My apologies. I had an app launching tomorrow that was mysteriously deleted and I have been frantic.
The email fields are populated at the time of submission by using the Office365Users connection to populate the manager of the nominee automatically.
this is an award form, either team (8 nominees) or individual(1 nominee). Each nominee has an approved, their manager that was automatically brought in as explained above. This means there’s 9 different groups of nominees and their approvers. What I’m trying to accomplish is making it easier on the manager by only showing the nominees that are their direct reports. Their names will be in that email field for the respective nominee.
I really appreciate your help. Thank you!
OK, but my question is exactly what type of field is 'Approver Email (E1)' in your data source (is it a Text field populated by this exercise)?
It’s a single line of text per SharePoint
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 345 Most Valuable Professional
11manish 207 Super User 2026 Season 2
Mohsin Ali 177
