You’re offline. This is a read only version of the page.
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
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)
HI @Mclean2023 ,
Please try:
Share
Report
All responses (
Answers (
Filter('SharePoint List', 'SharePoint Column' = Filter_1.Text || IsBlank(Filter_1.Text))
Best Regards,
Bof
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
