cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
neethup
Level: Powered On

undefined

Hi.. i want to show the searched record in datatable when i press a search button.. how can i do that?

 

2 ACCEPTED SOLUTIONS

Accepted Solutions
Community Support Team
Community Support Team

Re: undefined

Hi @neethup 

 

Do you test with @Pstork1 's suggestion?

You can try the following workaround:

 

Example:

Button1.OnSelect=Set(vF,Filter('2019test',Title=TextInput1.Text))

Button2.OnSelect=Set(vF,'2019test')

DataTable1.Items=vF

(you can use other controls and functions to test on your side)

Research1.PNG

 

Check:

ButtonResearch.gif

 

More information:

working-with-variables

function-filter-lookup

 

Hope this could be helpful.

 

Best Regards.

Yumia 

neethup
Level: Powered On

Re: undefined

ok i will try this.. thank you so much

16 REPLIES 16
Super User
Super User

Re: undefined

Set the datatable Items property to Filter or Lookup based on a value you store in a Variable.  Then set your button to update the value of the variable when pressed.



-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.
neethup
Level: Powered On

Re: undefined

i am new to powerapps so i dono much about this.. i have set filter to form item but dono what do with search button.. can you show me some example? actually i want to search with some sccount no, first name and last name

Community Support Team
Community Support Team

Re: undefined

Hi @neethup 

 

Do you test with @Pstork1 's suggestion?

You can try the following workaround:

 

Example:

Button1.OnSelect=Set(vF,Filter('2019test',Title=TextInput1.Text))

Button2.OnSelect=Set(vF,'2019test')

DataTable1.Items=vF

(you can use other controls and functions to test on your side)

Research1.PNG

 

Check:

ButtonResearch.gif

 

More information:

working-with-variables

function-filter-lookup

 

Hope this could be helpful.

 

Best Regards.

Yumia 

neethup
Level: Powered On

Re: undefined

ok i will try this.. thank you so much

neethup
Level: Powered On

Re: undefined

what is vF here? is it datasource?

Community Support Team
Community Support Team

Re: undefined

Hi @neethup 

 

vF is the name of the variable, you can change it to other names to instead.

 

More information:

working-with-variables

 

Best Regards.

Yumia

neethup
Level: Powered On

Re: undefined

ok.. thanks a lot

neethup
Level: Powered On

Re: undefined

hi. its working but the prpblem is its showing every record instead of what i have searched

Community Support Team
Community Support Team

Re: undefined

Hi @neethup 

 

Could you please share your formula expression on your side?

 

Best Regards.

Yumia

Helpful resources

Announcements
firstImage

Watch Sessions On Demand!

Continue your learning in our online communities.

SecondImage

PowerApps Monthly Community Call

Tomorrow, September 18th at 8am PDT

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

FirstImage

Power Platform World Tour

Coming to a city near you

thirdimage

PowerApps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

FourthImage

Join PowerApps User Group!!

Connect, share, and learn with your peers year-round

SecondImage

Power Platform Summit North America

Register by September 5 to save $200

Users Online
Currently online: 120 members 3,850 guests
Please welcome our newest community members: