Power Apps Exchange

Please login or click SIGN UP FOR FREE to create your PowerAppsUG account to join this user group.
Expand all | Collapse all

Using excel as data source

  • 1.  Using excel as data source

    Posted 21 days ago
    Hi,
    Looking for help. I have used an excel file to create a search engine. Powerapp default shows the list as the first screen. How can I hide the list so first page is only the search bar..

    ------------------------------
    Lenard Wood
    Desktop Support
    ------------------------------


  • 2.  RE: Using excel as data source

    Posted 20 days ago
    I'm not an expert at all, more newbie... so I don't know if my answer make sense...
    what about you set the height of the gallery to 0 and show it only once you start to write something in the search text box with a conditional statement

    ------------------------------
    Roberto Marra
    Bioggio
    ------------------------------



  • 3.  RE: Using excel as data source

    Posted 20 days ago
    Appreciate your time and feedback. I'm new to this as well, no coding experience. I found this to work, Set BrowseGallery1.Visible to Not(IsBlank(TextSearchBox1.Text))

    ------------------------------
    Lenard Wood
    Desktop Support
    ------------------------------



  • 4.  RE: Using excel as data source

    Posted 20 days ago
    Hi Lenard,
    Assuming you use the wizard to build an app from a data source you will have be default three sceens, one called, "BrowseScreen1".
    The list is displayed on BrowseScreen1 as a series of items in BrowseGallery1
    The search bar will be called something like, "TextSearchBox1"
    Most controls on the screen have a property, "Visible".
    Set BrowseGallery1.Visible to Not(IsBlank(TextSearchBox1.Text))
    As soon as you start typing in the search box, IsBlank becomes false so Not(IsBlank) becomes true so the gallery becomes visible.
    Bear in mind it will only display items that match the selection in BrowseGallery1.Items so you might still get nothing displayed.
    The selection statement, by default, only brings back items that start with the text in the search box.  You can change that to contains and look in other fields too but you will then face potential delegation errors
    Guy

    ------------------------------
    Guy Boswell
    Care for the Family
    Newport
    02920810800
    ------------------------------



  • 5.  RE: Using excel as data source

    Posted 20 days ago
    Thank you for your reply, this worked!

    ------------------------------
    Lenard Wood
    Desktop Support
    ------------------------------



  • 6.  RE: Using excel as data source

    Posted 20 days ago
    Edited by Tracy Madison 20 days ago
    Just have the Gallery.Visible property set to !IsBlank(txtSearch) - That returns a Boolean value, so if the search textbox is NOT blank the then the Gallery.Visible will be false and vise versa. Try that.

    Note: the ! represents NOT

    ------------------------------
    Tracy Madison
    Sr. Application Developer
    Fort Worth TX
    ------------------------------



  • 7.  RE: Using excel as data source

    Posted 20 days ago
    Thank you for taking the time to assist, this worked!

    ------------------------------
    Lenard Wood
    Desktop Support
    ------------------------------