Here is another SharePoint PowerApps example, we will see how to get bank branch detailed based on a State.
The PowerApps branch details App will appear like below, where the user will select a State from a dropdown list and corresponding branch details will appear.
PowerApps Example – Get bank branch details App
In this app we will discuss how to get bank branch details based on state.
Here, I have created a SharePoint list to store all details of branch details. Below is how the SharePoint list looks like:
Lets start the implementation how to achieve this.
Step 1: Log in to your PowerApps site -> Create a canvas app -> Open your new screen where you have to design this page.
Step 2: Next login to the SharePoint Online site and create a SharePoint List called Money Transaction history List with the below column.
- State Name (lookup from State List)
- Branch Name
- IFSC Code
- MICR Code
Step 3: Next go to the Data Source in PowerApps and connect your SharePoint list with PowerApps.
Step 4: Next drag and drop a blank Vertical gallery control in your from.
Step 5: In this step, I have added a label with the count, how many items are showing in the gallery control. So here I have already created a collection called SearchUser and I am counting the item based on gallery control items.
If(IsEmpty(SearchUser), "SEARCH", "RESULTS " & "(" & CountRows(GallerySearchUser.AllItems) & ")")
Step 6: Next i have a Textbox where I am entering the state name and we will get the item which is related to those text which we have entered in the TextBox. So we have to set the default property of the Textbox.
Step 7: Next we have to set the formula in Search icon OnSelect property.
If(Len(TextInputSearchUser.Text) > 0, ClearCollect(SearchUser, TextInputSearchUser.Text), Clear(SearchUser))
Step 8: Next we have to connect the data Source which we have connected recently. So we have to use that list in the item property of gallery control and add the below formula.
If(!IsEmpty(SearchUser),Sort(Filter('Bank Branches',StartsWith('State Name'.Value,First(SearchUser).Value)),'Branch Name',Ascending))
Step 9: Next add the labels inside the gallery control and set the formula like below.
Step 10: Next save the app and enter any text in the Textbox and click on Search icon and see the output.
You may like the following PowerApps tutorials:
- Power Apps Navigate Function + 16 Examples
- PowerApps Example – Create a Bank Account Statement
- Create Login Page in PowerApps using SharePoint List
- How to create a custom calendar in PowerApps
- PowerApps Chart Control – How to Use
- How to build multilingual apps in PowerApps
- Automatically scroll Gallery control in PowerApps
- PowerApps notify function- How to use
- Share PowerApps to external users or guest users
- PowerApps tips and tricks
In this PowerApps tutorial, we learned, how to display bank branch details based on State in a PowerApps. I hope this SharePoint PowerApps example help to you.
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).