I am trying to get the logged in app user’s name provided by authentication providder ( Google in this case) by using USERNAME() expression.
For certain user’s the expression is not returning the user’s name. In all probability, it could be a Google account setting challenge. The user might have turned it off to be shared or might not have set it up.
May I know where in Google account settings, the username and its sharing setting is available. Or alternatively could there be some other issue in USERNAME() not being returned only for certain users?