Announcements
Hi I have an unusual problem I have two users with same name and surname (email is different one of them have number in name) in forms I use User().FullName,
how to solve this when powerapp get the name of a person who already exists with the same name and surname to add number or email instead?
Hi @nenandi
Please always use email which is unique when comparing or filtering any data in PowerApps
User().Email
In general, We can set the OnStart of the App to
Set(UserInfo, User())
Use Userinfo.Email in your PowerApps for better performance.
We can also use Office365Users.MyProfileV2().mail as well
Thanks,Stalin - Learn To Illuminate
Surely, that it is better to use email, but the situation is currently like this I send data to excel name and surname
also we have some non O365 users (without email), so data in excel should be unique.
Hello @nenandi
to butress what @StalinPonnusamy said, its better to use email as the unique identifier.
However in your own case, if you have an office365users as a connector, you would have a lot of option you can use to filter the records.
I recommend creating some kind of unique Id in excel for existing data and new data for all users since email can't be used here. The reason for creating a unique id for both (O365 & Non-O365) is we can use just a unique id to filter or manipulate instead of email and a unique id.
Unique id can be Sequence(Sequence) number or Random (Rand). And unique id generation can be done in excel or PowerApps. Still, store the email as well for O365 users for later use.
Is it possible to somehow put IF in the field based on user email value , so if that email is instead User().Fullname wrote "Name Surname 1"?
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
11manish 381 Super User 2026 Season 2
Mohsin Ali 340
WarrenBelz 187 Most Valuable Professional
