Hi,
We use the User() function in Powerapps to identify users, and then lookup on the Primary Email to get the User ID.
This is great and works well, allowing us to retrieve per-user information in our app.
Unfortunately, if a user changes their email in the Users entity, that linkage is broken. Example:
Primary email at creation firstname.lastname@company.onmicrosoft.com
Primary Email is changed in Users to firstname.lastname@company.com
However, this change is not reflected in the User() function in Powerapps - which I understand to be associated with the O365 Account.
How do I account for this? We absolutely need to tie records to the User ID as it is used in a number of LookUps and changing these is not an option.
Thank you