I have customized a few SharePoint list forms with Power Apps and I keep noticing the same problems.
For all of them, I need to get the current user's email, use it in a lookup, and have fields auto-populate. It seems to always work fine for me, but when I look at what other people are entering, I can see that the lookups aren't pulling anything (they're pulling info that is there for everybody, so I've ruled out the possibility that the data is empty for them). It just seems like for random users it's not working and I cannot pinpoint a cause. I'll explain one example in detail here:
In the Default property of a text box named EmailText inside a datacard: User().Email
In the Default property of a text box named HoursText inside a datacard: LookUp('DataSource', Email = EmailText.Text && Week = WeekDropdown.Selected.Result, wHours)
On saving the form, the Hours column appears empty for some people. I have also tried using the OnVisible property of the form to set a variable with the email of the current user, then use that variable in a lookup with the same results. I've tried putting the lookup in the Update property of the datacards with the same result. I just need this to be consistent, so if there's a best practice way of doing this, I would love to know!
