I have created a list with the following columns:
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.
Use the following in the gallery items
Set(currentEmail, user().Email);
Filter(<<datasourcename>>, Title=currentEmail);
Put the Set() in the onVisible property for the screen.
Tried to add the code in my Screen's OnVisible property:
Set(currentEmail, user().Email);
No errors but results are not showing.
Did you check to see that the currentEmail variable was set after a run and what the value was?
After running the app in the Preview function of the editor check what is in the variables list.
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.
User | Count |
---|---|
124 | |
87 | |
86 | |
75 | |
69 |
User | Count |
---|---|
214 | |
181 | |
140 | |
96 | |
83 |