Changing logic in Search bar for Employees template

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hello Community,

Is there any way to change the logic of Search bar to show results for campaigns AND idea titles?

Thanks

Categories:

Building Power Apps

All responses (3)

Answers (2)

Sort by

v-qiaqi@microsoft.com Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Anonymous,

Do you want to search two fields Campaigns and 'Idea Titles'?

Could you please make sure that both of them are Text type columns in your data source?

To search two fields, you just need to refer to the search bar as below:

Filter(List, SearchBar.Text in Campaigns ||SearchBar.Text in 'Idea Titles')
Verified answer

Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @v-qiaqi-msft,

Thanks for the reply. I want to see the results for both Campaign names and Idea titles. If in dataverse those columns are named as 'Campaign' and 'Title', should i apply the formula as :?
Filter(List, SearchBar.Text in Campaign ||SearchBar.Text in 'Title')
Also, what is the best way to update formula for the hint text to show 'Search projects and ideas' given the current one is:
With(
{
varDefault: "Search campaigns",
varOOBTextId: "_translateCommon__Searchcampaigns"
},
With(
{
varLocalizedText: LookUp(
colLocalization,
OOBTextId = varOOBTextId,
LocalizedText
)
},
Coalesce(
varLocalizedText,
varDefault
)
)
)
Verified answer

v-qiaqi@microsoft.com Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi ,

Not sure if you want to input Campaign names and Idea titles within the search bar at the same time, the formula I provided just supports to retrieve records based on the key words you input that relates to a single column, which means it displays records related to Campaign names when you input key words from Campaign names, and it will only display records related to Idea titles when you input key words from Idea titles.

I will suggest you use two search bars to filter for two columns at the same time.

We really understand that you have more than one issue need to be solved today and we are surely happy to help you with those, but to better focus on the new problem and ensure the service quality, we would advise you to create another ticket on the issue. It can also help us to get the case better recorded and let Microsoft know what you have been through clearly. Thank you so much for your understanding.