web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Filter by column and u...

Power Apps

Answered

Filter by column and use a textinput

(0) Share

Report

Report

Posted on by Community Power Pla... Microsoft Employee

Hello

I have a galley with 7 columns and in each column have diferent data

I need a formula where I can filter for the column that I will select and search about the data that I will write in the textinput

I hope understand me and give your help.

Thanks

Categories:

Building Power Apps

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

Verified answer

mdevaney 29,993 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
@Anonymous

Put code like this in the Items property of drpdown_FilterColumn

["Column1","Column2","Column3"]

I would suggest some code like this in the Items property of your gallery.

Filter( your_datasource_name, (drpdwn_FilterColumn.Selected.Value="Column1" And StartsWith(Column1, TextInput1.Text)) Or (drpdwn_FilterColumn.Selected.Value="Column2" And StartsWith(Column2, TextInput1.Text)) Or (drpdwn_FilterColumn.Selected.Value="Column3" And StartsWith(Column3, TextInput1.Text)) )

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hello
I don´t know what is my mistake

This is my formula

Join the conversation