Skip to main content

Notifications

Power Apps - Building Power Apps
Answered

Search input does not pull Sharepoint column data

Posted on by 111

I'm trying to create a search box that search for Employee name from a SP List with the column name "Employee"; however, when I type in a name it does not pull in the result from the gallery. The gallery becomes blank.  The name is there. 

 

syntax used on the gallery Item property    Filter('Org Chart',StartsWith("Employee",SearchBox.Text)) 

 

The column type is a single line of text in SP list and the Employee name is in full ex. " John Smith" if that helps.

Categories:
  • v-liwei-msft Profile Picture
    v-liwei-msft on at
    Re: Search input does not pull Sharepoint column data

    Hi @punksterz626 

      

    We really understand that you have more than one issue need to be solved today and we are surely happy to help you with those, but to better focus on the new problem and ensure the service quality, we would advise you to create another ticket on the issue.

    It can also help us to get the case better recorded and let Microsoft know what you have been through clearly. Thank you so much for your understanding. 

     

    Best Regards,

    Levi

  • punksterz626 Profile Picture
    punksterz626 111 on at
    Re: Search input does not pull Sharepoint column data

    This was the issue. Once i removed the double quotation mark it work. By any chance would you know how to set a default to a specific employee? Once i clear the value, it stays blank on the gallery. I want to set it back to the top of the hierarchy since this is a department org chart. Any suggestions?

     

    Much appreciated.

  • Verified answer
    v-liwei-msft Profile Picture
    v-liwei-msft on at
    Re: Search input does not pull Sharepoint column data

    Hi @punksterz626 

     

    Please try removing the double quotes around the column name(Employee).

    Filter('Org Chart',StartsWith(Employee,SearchBox.Text))

     

    Best Regards,

    Levi

  • Drrickryp Profile Picture
    Drrickryp 30,510 on at
    Re: Search input does not pull Sharepoint column data

    @punksterz626

    Your formula looks correct. Did you repurpose a different column as the employee column?

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.

Helpful resources

Quick Links

October 2024 Newsletter…

October 2024 Community Newsletter…

Community Update Oct 28…

Power Platform Community Update…

Tuesday Tip #4 How to Conntact Support…

Welcome to a brand new series, Tuesday Tips…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 142,733

#2
RandyHayes Profile Picture

RandyHayes 76,308

#3
Pstork1 Profile Picture

Pstork1 63,750

Leaderboard