Dynamics F/SCM Customer Experience (CRM) Dynamics GP Dynamics Business Central (NAV) Dynamics SL Power Platform Fabric Copilot

[Dmitry Zdorovtsov]

Hello colleagues. I have a problem with setting the search field. I have a list with a phone book on the sharepoint page. I can’t understand how to correctly register the function so that the search is carried out by number, display name, by employee, by employee position. At the moment I have the formula:

Search (PhoneBook, TextSearchBox1.Text, “Title”, “OData__x006f_du9”) .

Where “title” is the phone number Where “OData__x006f_du9” is the displayed name .
For some reason, some columns are needed, such as USER, are absent in PowerApps, although they are in the phone book.
I connected the office 365users in the date of the visit, but I still did not understand how to correctly use the function of the Office 365Users.SearchUser()

Maybe i need to use a different formula?
Could you help me please with this question ?
I added the screenshots.

Thanks a lot.

——————————
BR
Dmitry Zdorovtsov
——————————

[Andy Tippin]

As I understand it, the Search function only works on Text fields. Check your SharePoint list and make sure the phone number is formatted as text. Also, I think User is a whole separate data type in SharePoint.

——————————
Andy Tippin
——————————
——————————————-

[Jordan McDonald]

Have you tried using filter instead of search? I have an app that filters using the search box and it works on many different columns but maybe right on it having to be a column that the data type is text. Hope this helps..

Sort(Filter(‘LEED 2.0’, StartsWith(FPE_Location, RegionCode.Text), TextSearchBox1.Text in Condition Or TextSearchBox1.Text in RTS_Number Or TextSearchBox1.Text in ReportNumber, Status.Value = Status_Title.Text), Created,Ascending),Sort

——————————
Jordan McDonald
——————————
——————————————-