cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
AndrewValenzuel
Advocate II
Advocate II

(SOLVED) Gallery & Sharepoint: Search by ID | Filter by ID | Multiple search options & Search by ID

Here is how to search a SharePoint list by ID, and how to have multiple search options.  Without any delegation problems.

 

Here is the code to search via ID only:  Filter(SharePointList , ID=Value(textInputbox.Text)

 

Here is the code to search via ID OR other search parameters:  If(IsBlank(textInputbox) , /*enter your search options here like: */ SortByColumns(Filter(SharePointList , StartsWith(ColumnName,textInputbox2.Text)))  , Filter(SharePointList,ID=Value(textInputbox.Text))

 

The reason its not possible to search an ID field using StartsWith or Search is because in SharePoint the ID field is a number field.  Searching for a number is not a delegable operation in SharePoint.  However it is possible to delegate operators suchas "=,<,>,etc...".  But, the ID column is special in that the only delegable operator that works with it is "=".  

 

Here's the overview of the SharePoint Connector.  You can see what is and isn't possible:  SharePoint - Connectors | Microsoft Docs 

 

 

1 REPLY 1
v-jefferni
Community Support
Community Support

Hi @AndrewValenzuel 

 

Thank you for sharing this.

 

Best regards,

Community Support Team _ Jeffer Ni

Helpful resources

Announcements
PA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Top Solution Authors
Top Kudoed Authors
Users online (2,343)