Answered

Filter with SharePoint data source

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hello,

I am working on a simple help ticket search app. I got it to work with the original excel data source, but the plan is to now move to a SharePoint data source. The data still fills in, and I can see and scroll through my gallery, but when I try to search any ticket number it comes up blank.

Here is the code for the SharePoint version:

SortByColumns(Filter([@testtracker], TextInput1.Text in "TicketNumber"),"Title",If(true,Descending,Ascending))

And the Excel version:

SortByColumns(Filter([@Table1],TextInput1.Text in 'Ticket No.'),"Status",If(true,Descending,Ascending))

Any guidance would be greatly appreciated!

Thanks,

Jordan

Categories:

Building Power Apps

All responses (4)

Answers (1)

Sort by

mdevaney 29,993 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
@Anonymous

I would do it like this. The double quotations beside ticket number are deleted because we want to use values in that column not the actual word "TicketNumber. Then I replaced IN with the STARTSWITH function improve searchability.

SortByColumns( Filter([@testtracker], StartsWith(TicketNumber, TextInput1.Text), "Title", Descending )

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @mdevaney,

I tried the updated code, but it does not identify TicketNumber in the SharePoint list, and the gallery comes up blank. I've attached a screen clip of the headers of the SharePoint list as well. Also a screen clip of the code to show where the errors are highlighted.

It just might be something weird with the SharePoint list on my end as well, as I am new to PowerApps and still trying to learn.

Thanks,

Echo1409
Verified answer

v-siky-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Anonymous ,

Did you rename the column from Title to TicketNumber?

In a strange mechanism, power apps can only recognize the initial column name of SharePoint list, even if column has been already renamed it, so please try this code:

SortByColumns( Filter([@testtracker], StartsWith(Title, TextInput1.Text), "Title", Descending )

Hope this helps.
Sik
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

@v-siky-msft,

Thanks! That worked. I'll keep that in mind for the future, and mark this as solved.

-Echo1409