Announcements
Hello,
I'd like to use a textbox to search for an O365User then show ONLY the Email Addresss of that person in another textbox. I get the error "The property expects text values but this rule produces incompatible table values". I don't want to use a Gallery in this case. What are the options?
Thanks
Have you tried a List Box?
Hi @ericonline
The SearchUser function can return multiple results depending on the search term that you provide. That's the reason behind the 'incompatible table values' error.There are a few ways to display the result in a textbox. To display the first result, you can use the following formula:
First(Office365Users.SearchUser({searchTerm:<text_box>})).Mail
If you want to display a coma separated list of email addresses, you can use the Concat function like so:
Concat(Office365Users.SearchUser({searchTerm:<text_box>}), Mail & ", ")
Thank you Jeff and timl for your responses.
I ended up using timl's...
First(Office365Users.SearchUser({searchTerm:<text_box>.Selected.DisplayName})).MailNickname
... but changed it a bit because the search <text_box> is actually a Sharepoint Person column.
The weird thing about this though is that when there is no search term in the search <text_box>, the results textbox shows "0151E132". What is this value?
When you enter no search term into the textbox, I suspect that the SearchUser function will return all users in your organisation. I imagine that '0151E132' relates to the first item in this list, and this might relate to some sort of service account.
Interesting. I was able to suppress it using:
If(IsBlank(<text_box>.Selected),"_", (<--This is the default value of the <text_box> search)First(Office365Users.SearchUser({searchTerm:<text_box>.Selected.DisplayName})).Mail)
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 2026 Super Users!
Congratulations to our 2025 community superstars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Vish WR 1,074
Valantis 639
11manish 606
