web

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

News and Announcements icon

Power Platform CommunityForums Power Apps Filtering datatable

Power Apps

Answered

Filtering datatable

(0) Share

Report

Report

Posted on by Mclean2023

79

I have the below formula to look up names in a list and this filters my Data Table but if nothing is selected I want to show everything in the list

The below works as is but the data Table remains blank unless you select something

Filter('SharePoint List', 'SharePoint Column' = Filter_1.Text)

The filter_1.Text gets its data from a Combo box "Dropdown1" i thought it would be easier to pull the filter from a text field

Categories:

Building Power Apps

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

Verified answer

v-bofeng-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
HI @Mclean2023 ,

Please try:

Filter('SharePoint List', 'SharePoint Column' = Filter_1.Text || IsBlank(Filter_1.Text))

Best Regards,

Bof
Mclean2023 79 on at

Like
a
(0)

Report
Copy link

Link copied!

Worked perfectly, after i posted i was thinking about how i add multiple filter fields so a user can either filter by one column or the other or both

Filter('SharePoint List', 'SharePoint Column 1' = Filter_1.Text)
Filter('SharePoint List', 'SharePoint Column 2' = Filter_2.Text)

Join the conversation