filter by sharepoint id column

(0) Share

Report

Posted on by AshishJaiswal

776

Hi Experts,

How to add filter for sharepoint ID column

User should be able to search the gallery using sharepoint ID number

SortByColumns(Filter('DWP Exceptions Tracker',StartsWith('Customer Name',InputSearchID.Text)),"Created",Ascending)

Categories:

Building Power Apps

I have the same question (0)

All responses (9)

Answers (1)

v-jefferni on at

Like (0)

Report
Hi @AshishJaiswal ,

SharePoint list ID column is number type, so the formula could be:

SortByColumns( Filter( 'DWP Exceptions Tracker', StartsWith('Customer Name',InputSearchID.Text) || ID = Value(nputSearchID.Text) ), "Created", Ascending )

Hope this helps.

Best regards,

Community Support Team _ Jeffer Ni
If this post helps, then please consider Accept it as the solution to help the other members find it.

Was this reply helpful? Yes No
AshishJaiswal 776 on at

Like (0)

Report

@v-jefferni

Thank you for replying

I have already tried the above formula

When i use above formula the startswith function stops working - filter only works on ID column and completely ignores startswith

Was this reply helpful? Yes No
v-jefferni on at

Like (0)

Report

Hi @AshishJaiswal ,

I have tested from my end on Title and ID columns and it worked fine. What type is your Customer Name column?

Best regards,

Community Support Team _ Jeffer Ni
If this post helps, then please consider Accept it as the solution to help the other members find it.

Was this reply helpful? Yes No
AshishJaiswal 776 on at

Like (0)

Report

@v-jefferni

I am using the same formula it doesn't work for customer column

When enter a text in InputSearchID (InputText Control) it does not filter items gallery, it only works from ID column.

My customer column is a single line of text column

Was this reply helpful? Yes No
Verified answer

v-jefferni on at

Like (1)

Report
Hi @AshishJaiswal ,

Please first make sure the single StartsWith part is working for the current search text:

SortByColumns( Filter( 'DWP Exceptions Tracker', StartsWith('Customer Name',InputSearchID.Text) ), "Created", Ascending )

If it works, try below formula instead:

SortByColumns( Filter( 'DWP Exceptions Tracker', Or( StartsWith('Customer Name',InputSearchID.Text), ID = Value(InputSearchID.Text) ) ), "Created", Ascending )

I'm wondering about one thing. As you said it works for the ID column, the search text you have entered must be a number. So, are the customer names all begin with numbers as well? This seems a bit strange. Below is my test result screenshot:

Hope this helps.

Best regards,

Community Support Team _ Jeffer Ni
If this post helps, then please consider Accept it as the solution to help the other members find it.

Was this reply helpful? Yes No
AshishJaiswal 776 on at

Like (0)

Report
@v-jefferni

Hello, the formula does not work, it only works for ID column. My Customer column does not have numbers it has text.

Works for ID column

BTW this one works for customer column

SortByColumns( Filter( 'DWP Exceptions Tracker', StartsWith('Customer Name',InputSearchID.Text) ), "Created", Ascending )

Was this reply helpful? Yes No
v-jefferni on at

Like (0)

Report

Hi @AshishJaiswal ,

May I have a look at the customer name that begins with "test" in your list?

Best regards,

Community Support Team _ Jeffer Ni
If this post helps, then please consider Accept it as the solution to help the other members find it.

Was this reply helpful? Yes No
AshishJaiswal 776 on at

Like (0)

Report

@v-jefferni

Here you go

Was this reply helpful? Yes No
v-jefferni on at

Like (0)

Report

Hi @AshishJaiswal ,

I cannot find the reason and am totally losing the direction. Maybe it's the delegation issue? But there's no delegation warning in that formula...

Please try and:

1. Check data row limit in settings, change the number to 2000:

2. Raise a ticket for more help.

Best regards,

Community Support Team _ Jeffer Ni
If this post helps, then please consider Accept it as the solution to help the other members find it.

Was this reply helpful? Yes No