Answered

Search input does not pull Sharepoint column data

(0) Share

Report

Posted on by punksterz626

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:

Building Power Apps

All responses (4)

Answers (1)

Sort by

Drrickryp Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@punksterz626

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

v-liwei-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @punksterz626

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

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

Best Regards,

Levi
punksterz626 on at

Like
a
(0)

Report
Copy link

Link copied!

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.
v-liwei-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

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