filter by sharepoint id column

Like (0) Share

Report

Posted on 11 Apr 2022 15:14:01 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:

Using Apps Using Formulas

I have the same question (0)

All responses (9)

Answers (1)

v-jefferni on 13 Apr 2022 at 08:57:13

Like (0)

Report
Re: filter by sharepoint id column

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 13 Apr 2022 at 10:37:28

Like (0)

Report

Re: filter by sharepoint id column

@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 14 Apr 2022 at 03:07:59

Like (0)

Report

Re: filter by sharepoint id column

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 19 Apr 2022 at 06:32:18

Like (0)

Report

Re: filter by sharepoint id column

@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 19 Apr 2022 at 07:07:16

Like (1)

Report
Re: filter by sharepoint id column

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 19 Apr 2022 at 07:58:45

Like (0)

Report
Re: filter by sharepoint id column

@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 19 Apr 2022 at 08:16:29

Like (0)

Report

Re: filter by sharepoint id column

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 19 Apr 2022 at 08:57:29

Like (0)

Report

Re: filter by sharepoint id column

@v-jefferni

Here you go

Was this reply helpful? Yes No
v-jefferni on 19 Apr 2022 at 09:27:32

Like (0)

Report

Re: filter by sharepoint id column

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