If you are looking out to implement filter in SharePoint list items in an Apps in PowerApps, then check out the article. Here we will see a PowerApps filter SharePoint list example. Specially, we will see how to filter items based on ID column in PowerApps in the SharePoint Online list.
Like in the below pics, you can see the apps having a textbox and a search button.
PowerApps filter SharePoint list
In PowerApps, there is no direct approach to filter datatable. So we will see how to customize using PowerApps function or formula.
The Filter function in PowerApps allows you to query a table of data and which could come from your custom collection or data source.
Here I just connect my DataTable with my SharePoint list through a connector. Then I used Filter to get the item based on Item ID.
Step 1: Open the PowerApps -> Create a Canvas app from blank -> Create a app with Mobile or Tablet view.
Step 2: Next Drag and drop the below controls like Label, Button and Datatable to make this view.
Step 3: This is my SharePoint list which I have connected through connector to get the data.
Step 4: Once you done with your connection setting, the Data Source name will appear over here.
Step 5: Next click on the button and go to OnSelect property on button and the below formula.
ClearCollect(Quoteclient,Filter(BlogDetails,ID=Value(TextInput1.Text)));
Here I have created a collection called Quoteclient and filter the data from data source BlogDetails based on ID. When I filter any ID, the item will save in the collection and we will bind this collection in DataTable to show the result.
Step 6: In this step, I will bind my collection with DataTable Items property. It will show the result based on Item ID.
Step 7: Next save the PowerApps App and click on F5 to see the result. Or you can click on the Preview button.
You can enter any number and click on the Search button. The item will be displayed below.
You may like following PowerApps tutorials:
- Display COVID-19 Power bi report in PowerApps
- How to embed Power bi report in PowerApps portal
- Display Office 365 User Profile Properties in PowerApps
- How to display Power bi google analytics in PowerApps
- PowerApps Combobox SharePoint List Example
- PowerApps twitter connector example
- How to show RSS feed in PowerApps
- How to create a custom calendar in PowerApps
- Create Login Page in PowerApps using SharePoint List
- SharePoint PowerApps Example – Get bank branch details based on State
- PowerApps nested gallery control example
In this tutorial, we learned how to filter list items by item id in PowerApps in SharePoint Online. This way, we can filter list column in PowerApps.
Rajkiran is currently working as a SharePoint Consultant in India . Rajkiran having 7+ years of experience in Microsoft Technologies such as SharePoint 2019/2016/2013/2010, MOSS 2007,WSS 3.0, Migration, Asp.Net, C#.Net, Sql Server, Ajax, jQuery etc.He is C#Corner MVP (2 Times).