web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Pages / Dynamics 365 portal Li...
Power Pages
Unanswered

Dynamics 365 portal List search

(0) ShareShare
ReportReport
Posted on by Microsoft Employee

Hi all, 

I've been looking at this function for a while now (and even posted a question a bit ago without success) and I'm surprised there aren't more questions posted about it, which makes me think I'm doing something wrong! However, I think I can articulate the issue a bit better now, so I'm going to ask the community again...

 

I have a portal, with a list and a number of metadatafilters. I want to be able to search the view using Lucene parameters, but not by using Global Search as I want the results to be from my List view (for format and content reasons). The List search functionality provides a wildcard function (*), which is essential for any text fields. However, it will only allow me to search a single string. The parameters that make it to the URL are /?search=term1+term2, but this does not provide results unless term1 and term 2 form a contiguous string in a single field. The same is true for /?search=*term1+*term2 and adding Lucene criteria just extends the string (e.g. /?search=*term1+AND+*term2). So I cannot search for 'term1 in field 1' AND/OR 'term2 in field 2'.

 

Somewhat bizarrely, if you change the + in the URL for an ampersand (so /?search=*term1&*term2) the search works exactly as you would expect for a lucene AND search (although from what I can gather, this behaviour is in itself anomalous). However, I can't find a way to make it do an OR, otherwise I would just change the way the query string parameters are generated.

 

Please - does anybody have any ideas about how I do this to allow *, AND, and OR searches of a List across multiple fields?

 

Many thanks

Ralph

Categories:
I have the same question (0)
  • oliver.rodrigues Profile Picture
    9,471 Most Valuable Professional on at

    @Anonymous not exactly what you are looking for, but could be helpful somehow: http://oliverrodrigues365.com/2021/03/02/power-apps-portals-loading-large-data-in-entity-lists/

    on that article I am showing how to load a list with pre-filtering data

     

    with regards the wildcard *, what I have done in the past is via JS, inject a * during the search.. I should write an article about that .. let me know if this is something you would find useful

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the March Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Pages

#1
rezarizvii Profile Picture

rezarizvii 55

#2
11manish Profile Picture

11manish 48

#3
Valantis Profile Picture

Valantis 46

Last 30 days Overall leaderboard