cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ericonline
Level 10

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

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

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: How to get Office365Users.SearchUser({searchTerm: <text_box>}).Mail to display ONLY text N

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 & ", ")
5 REPLIES 5
Super User
Super User

Re: How to get Office365Users.SearchUser({searchTerm: <text_box>}).Mail to display ONLY text N

Have you tried a List Box?

Super User
Super User

Re: How to get Office365Users.SearchUser({searchTerm: <text_box>}).Mail to display ONLY text N

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 & ", ")
ericonline
Level 10

Re: How to get Office365Users.SearchUser({searchTerm: <text_box>}).Mail to display ONLY text N

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

Super User
Super User

Re: How to get Office365Users.SearchUser({searchTerm: <text_box>}).Mail to display ONLY text N

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.

Highlighted
ericonline
Level 10

Re: How to get Office365Users.SearchUser({searchTerm: <text_box>}).Mail to display ONLY text N

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)