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

Announcements

Welcome to the Power Platform Communities
Register Today: Microsoft Business Applications Update- April 15th
Your Invited to Keeping It Real with the Power Platform
News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Search Gallery
Power Apps
Unanswered

Search Gallery

(0) ShareShare
ReportReport
Posted on by Community Power Pla... Microsoft Employee

I am using the built in Screen Selection "List".  My data source is an excel table. 

 

 

 

SortByColumns(Search(Extract, TextSearchBox3.Text, "Order_x0020_Number"), "Order_x0020_Number", If(SortDescending1, SortOrder.Descending, SortOrder.Ascending))

 

 

 

However nothing is being returned.  My screen is blank.  Not entirely sure where I am going wrong.

 

Thank you

Categories:
Building Power Apps
I have the same question (0)
  • SeanHenderson Profile Picture
    SeanHenderson 1,104 on at

    Hi @Anonymous 

    What is this formula being used on? What property of what control? What is your intention?

    Right now the formula reads:

    Take a table called "Extracts" and search for records where the text from TextSearchBox3.Text is found in the column "Order_x0020_Number". Using this filter, sort on the "Order_x0020_Number" - and at this point I don't understand what you are trying to do. What is Sortdescending1? What is the If here supposed to do?

     

  • Community Power Platform Member Profile Picture
    Community Power Pla... Microsoft Employee on at

    This formula is being used on a gallery.

     

    In my App I added a New Screen.  I selected the 'List' Screen from the available selections.  There was a pre-populated formula for an example.  I replaced the source and the field in which the search would be conducted.  The sort descending part was in there and I didn't touch it.  

     

    I'm trying to have an Order Number typed into TextSearchBox3 and have the gallery filter to show only that Order.

  • SeanHenderson Profile Picture
    SeanHenderson 1,104 on at

    Did you change the values in the text boxes within the gallery? They should be called something like Title2 and Subtitle2 in the tree on the left. Make sure to change their text to ThisItem. and then whatever column you want to display.

     

    ---
    Please hit the "Accept as Solution" button if my post answered your question! If my post was helpful please consider giving it a "Thumbs Up."

  • Community Power Platform Member Profile Picture
    Community Power Pla... Microsoft Employee on at

    Yep.  But I still get nothing

     

    I changed them to ThisItem.Order Number and ThisItem.Order Date.

  • SeanHenderson Profile Picture
    SeanHenderson 1,104 on at

    Hmm...

    Do you have anything set for defaults? On the gallery it should be nothing, but the default on your search box should be ""

  • Community Power Platform Member Profile Picture
    Community Power Pla... Microsoft Employee on at

    So when you first select the 'List Screen' you can see sample data populated, the Lorem ipsum text.  However when I change the source I am not seeing anything. I am assuming this is where my issue is stemming from.  Not the formula itself.

     

    If I create a new screen and do the gallery myself and set items = to my Extract table it says 'We didn't find any data".

  • Community Power Platform Member Profile Picture
    Community Power Pla... Microsoft Employee on at

    it is an empty string

  • SeanHenderson Profile Picture
    SeanHenderson 1,104 on at

    Oh, okay this is an issue with your table then. I have been trying to recreate it but I'm unable to. So it is able to pick up the table from the excel file, and read the columns, but doesn't display any records?

    Is it connected directly to the excel file, or is it connecting through something like Onedrive or sharepoint?

  • SeanHenderson Profile Picture
    SeanHenderson 1,104 on at

    @Anonymous 

    Is the spreadsheet open anywhere? Like in OneDrive or Excel? I know sometimes excel locks things down for other programs if you have it open somewhere.

  • Community Power Platform Member Profile Picture
    Community Power Pla... Microsoft Employee on at

    Its OneDrive.  I have everything closed.  But I did connect when it was open.  I will try and reconnect.

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

News and Announcements

Welcome to the Power Platform Communities
Register Today: Microsoft Business Applications Update- April 15th
Your Invited to Keeping It Real with the Power Platform

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 Apps

#1
11manish Profile Picture

11manish 534

#2
WarrenBelz Profile Picture

WarrenBelz 416 Most Valuable Professional

#3
Valantis Profile Picture

Valantis 306

Last 30 days Overall leaderboard

Featured topics

Auto-Populate field Power Pages
Gallery Tabs - Show or Hide Tabs based on Field Value
How to patch multiple records at once
Enable Copilot for end users in model-driven apps
Question for everyone : How are you using Create Text GPT in AI Builder?
Community content - sample components, blogs etc. - Link to this page (http://aka.ms/PCFdemos)
Welcome to the Power Apps forum!

Product updates

Microsoft Power Platform Community release plans