Answered

Search Functionality

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

I'm creating a database app and just looking to improve the search functionality.

I have a sharepoint list of organisations and they have three fields, 'Organisation Name' 'Organisation Type' and 'Organisation Focus.'

I want my powerapps database to be able to have a screen where I can search for records that match a particular field, eg. Some organisations may have their type listed as 'charity'. If I wanted to search for all charities I would be able to enter 'charity' into the search box and it will pull up a screen with a gallery showing all charities.

I seem to have been able to get it to filter names by using Filter('Organisation List', StartsWith ('Organisation Name', textinput1.Text)) but this then doesn't seem to allow me to replicate this formula to filter out 'Type' or 'Focus'.

Is there a better way I'm missing?

Many Thanks

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

JayMagness 1,663 on at

Like (0)

Report
Copy link

Link copied!

Hi,

I think you wan to add a Search statement, then a filter statement

Filter, Search, and LookUp functions - Power Apps | Microsoft Docs

Was this reply helpful? Yes No
Verified answer

v-qiaqi@microsoft.com Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @Anonymous,

Based on the issue that you mentioned, do you want to search based on what your type in the Text input for 'Organisation Type' and 'Organisation Focus'?

Could you please tell me that if all the columns are Text type?

The formula you provided could only filter based on key word in the 'Organisation Name' column which should be a Text type column.

If you have a Choice column, you should modify your formula as below:

Filter('Organisation List', StartsWith ('Organisation Type'.Value, textinput1.Text))

Check if it could help.

Regards,

Qi

Was this reply helpful? Yes No