I was having problems with one user (shared the doc with them at their yahoo.com address) who was having trouble with some functionality that does a lookup based on User().Email.
I was able to narrow this down to a problem in how eMail addresses are sync’d via a crossdoc table.
In my remote doc A, I have a table of person information with a column (let’s call it PersonEmail) that represents the eMail address of that person. I sync this table with Crossdoc to doc B where I want to do a lookup of User().Email against that crossdoc table (let’s call it SyncPersonTable). There is no issue with the User() not being in the sync’d table, but there is an issue with trying to Filter( SyncPersonTable, PersonEmail = User().Email).
The problem is because for some reason when the data was sync’d, eMail’s got changed into the person’s name and treated like a Person column instead of a Text column. I could hover over the name and see their profile image and an Email attribute with their email address.
All of my typing of the columns was correct, nothing fancy there. I’m not sure why this change in format is happening or what’s triggering it. It seems to have resolved itself now after I edited the email address in doc A and resync’d but I don’t know why it happened and why it only happened for a few rows in that table vs. all of them.
Any ideas here?