web

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

Power Platform CommunityForums Power Apps - Building Power Apps Filtering datatable

Power Apps - Building 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:

General Questions

Using Apps Using Formulas

Connecting to Data

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (1)

Verified answer

v-bofeng-msft on at

Like (0)

Report
Re: Filtering datatable

HI @Mclean2023 ,

Please try:

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

Best Regards,

Bof

Was this reply helpful? Yes No
Mclean2023 79 on at

Like (0)

Report

Re: Filtering datatable

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)

Was this reply helpful? Yes No

Join the conversation