Check if an email exist on Office365User

(0) Share

Report

Posted on by FGRODRIGUEZ

129

I have a SharePoint list with people, on this list I have an email column named "correo_electronico" I'm trying to check if an email on that list exist on my Office 365 users, right now I'm using a label to check if the formula is correct, but I can't get it to work

This is the formula I'm using:

If(Office365Users.SearchUserV2({searchTerm:Text(ThisItem.correo_electronico),top: 1,isSearchTermRequired: false, skipToken:"token?"}),true, false)

Categories:

Building Power Apps

I have the same question (0)

All responses (1)

Answers (1)

Verified answer

SpongYe 5,909 Super User 2026 Season 2 on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @FGRODRIGUEZ

This worked for me:
If( CountRows( Office365Users.SearchUserV2( { searchTerm:ThisItem.correo_electronico, top: 1, isSearchTermRequired: false } ).value ) > 0, true, false )

-----------------------
PowerYsa Power Platform Enthusiast [LinkedIn] | [Youtube]

I love to share my knowledge and learn from others. If you find my posts helpful, please give them a thumbs up 👍 or mark them as a solution ✔️. You can also check out my [@PowerYSA] for some cool solutions and insights. Feel free to connect with me on any of the platforms above. Cheers! 🍻

Was this reply helpful? Yes No