+ Reply to Thread
Results 1 to 3 of 3

PowerApps filter data table by textbox value then return all matches to textboxes

  1. #1
    Registered User
    Join Date
    05-31-2019
    Location
    Shelbyville, IN
    MS-Off Ver
    2016
    Posts
    24

    Smile PowerApps filter data table by textbox value then return all matches to textboxes

    Hello,

    I need to enter "Search" text into a textbox in Powerapps. Then I want to filter my data table for all matches to that textbox, then return the adjacent cell values in textboxes on my PowerApps canvas. For example my data table looks like this:

    tableExample.PNG

    I want to enter text into a textbox on my PowerApps canvas, find all matching values in the data table, then return the adjacent values in textboxes on my PowerApps canvas. In this example it should return "H00071" in 1st textbox, "H85468" in 2nd textbox, etc. Is this possible?

    powerAppsForm.PNG

  2. #2
    Forum Expert romperstomper's Avatar
    Join Date
    08-13-2008
    Location
    East Sussex, UK
    MS-Off Ver
    365, varying versions/builds
    Posts
    21,265

    Re: PowerApps filter data table by textbox value then return all matches to textboxes

    Normally you would use something like a gallery control which allows you to display multiple records from a data source.
    Remember what the dormouse said
    Feed your head

  3. #3
    Registered User
    Join Date
    05-31-2019
    Location
    Shelbyville, IN
    MS-Off Ver
    2016
    Posts
    24

    Re: PowerApps filter data table by textbox value then return all matches to textboxes

    Rorya,

    After some research I was able to use the gallery control to get what I needed. At first I was hoping to use textboxes but once I figure out how to customize the gallery control and add dropdowns to them I think it will be sufficient. Thank you for your response.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Unique textbox reference from sheet;Table -> Userform;Textboxes
    By Kaizan in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-26-2020, 09:20 AM
  2. Return all matches in a database table
    By msalawi in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-04-2018, 11:08 AM
  3. Return value from sheet to textboxes based on value on another textbox
    By impresxy in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-04-2017, 08:55 AM
  4. Combobox find multiple matches and return to textboxes
    By Sennabenna in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-16-2017, 09:50 PM
  5. Return text from table if it matches another table
    By Eck-sell in forum Excel - New Users/Basics
    Replies: 4
    Last Post: 05-13-2017, 12:26 PM
  6. [SOLVED] How to filter a table using textbox and show filtered data in listbox (userform)
    By HaroonSid in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 02-01-2017, 10:31 AM
  7. [SOLVED] Filter Table from a userform with TextBoxes
    By yachrishere in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-05-2016, 04:33 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1