Power Community

Power Community

Power apps search function with example

In this Power Apps Tutorial, we will discuss what is the Power Apps Search function, it’s syntax, how to use the Power Apps search function in a canvas app. We will see how to apply a search box in Power Apps.

We will also see how to search for items from the Data Vase Account Entity using the Power Apps search function.

Also, We will see how to use the Search function in a Vertical Gallery Control and how can you do multiple searches.

Please fellow below screens.

Click on Create app à Give app name based on your requirement and click on Create

Rahman1005_0-1707453047679.png
 

Rename first screen as main screen it will be easy to understand.

Rahman1005_1-1707453047686.png

Step-1:

First of all, on your Power Apps Screen, Add a Blank Vertical Gallery Control (Insert -> Gallery -> Vertical). Then connect a Data Source as Account (As my records are present in Account Entity) as shown below.

Rahman1005_2-1707453047690.png

Rahman1005_3-1707453047694.png

Step-3:

In the below screenshot, you can see all the records are retrieved from the Account entity. Here, your Item property should be your Account Entity name (‘Account ‘).

Select the Gallery and go to the Properties pane. Select the Layout as “Name, Address “. Edit the fields and add the columns as per your choice.

Rahman1005_4-1707453047696.png

Rahman1005_5-1707453047699.png

Step-4:

Now to search the fields from the PowerApps vertical gallery, we need to add a search bar on the top of the Gallery. For that, go to Insert -> Text -> Add Text Input as shown below.

The Text input control will insert and it will show the default value as Text. Just remove the Default value and in Hint Text give as “Search by Account” as shown in below screen.

Rename Text input as Search Box for added text box. 

Rahman1005_6-1707453047702.png

Step-6:

Select the Vertical Gallery control and apply the below Search function formula on its Items property as:

Items = Search (‘Event Registration Details’, SearchBox.Text, “Title”)

Rahman1005_7-1707453047705.png

Rahman1005_8-1707453047707.png

Thank you..!

This post was originally published on this site

- Advertisement -spot_img

LEAVE A REPLY

Please enter your comment!
Please enter your name here

- Advertisement - Advertisement

Latest News

July 2024 update of Power Automate for desktop

We are happy to announce that the July 2024 update of Power Automate for desktop (version 2.46) has been...

More Articles Like This

- Advertisement -spot_img