Match current user's email to a column in SharePoint list

(0) Share

Report

Posted on by biancadevera

I have created a list with the following columns:

Title: email address (Single text line)
Name: preferred name (Single text line)

I would like to match it with my User().Email. Is this possible?

Would like to filter my data based on the current user signed in (User().Email) with the data I have on my list. I've used the 'Created by'.Email = User().Email before but this will only work if it was created by a certain user.

Categories:

Building Power Apps

All responses (8)

Answers (0)

Sort by

Pstork1 69,665 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Use the following in the gallery items

Set(currentEmail, user().Email); Filter(<<datasourcename>>, Title=currentEmail);
biancadevera on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Pstork1 I had this error:
Pstork1 69,665 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Put the Set() in the onVisible property for the screen.
biancadevera on at

Like
a
(0)

Report
Copy link

Link copied!
Tried to add the code in my Screen's OnVisible property:

Set(currentEmail, user().Email);

No errors but results are not showing.
Pstork1 69,665 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Did you check to see that the currentEmail variable was set after a run and what the value was?
biancadevera on at

Like
a
(0)

Report
Copy link

Link copied!

@Pstork1 how can I check that?
Pstork1 69,665 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

After running the app in the Preview function of the editor check what is in the variables list.
biancadevera on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Pstork1 just an update about this. I found a workaround for this issue. I created another column in my SP list and list down the email addresses. Was able to achieve my goal. Thanks for the help.