Answered

How to get Office365Users.SearchUser({searchTerm: }).Mail to display ONLY text NOT table?

(0) Share

Report

Posted on by Community Power Pla...

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

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

Jeff_Thorpe 6,085 Super User 2024 Season 1 on at

Like (0)

Report

Have you tried a List Box?

Was this reply helpful? Yes No
Verified answer

timl 36,391 Super User 2025 Season 2 on at

Like (5)

Report
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 & ", ")

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report
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?

Thanks

Was this reply helpful? Yes No
timl 36,391 Super User 2025 Season 2 on at

Like (0)

Report

Hi @ericonline

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.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report
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)

Was this reply helpful? Yes No