'Filter by' option for column isn't selectable

Like (1) Share

Report

Posted on 8 Jul 2024 10:12:26 by ege

Hi everyone,

I have extracted the members of an Office365 Group by using the following command:

Office365Groups.ListGroupMembers()

As a result, I have a table including the members' 'displayName', 'jobTitle', and 'mail' as the columns of the table. I'm able to pre-filter the data using Filter() command, but I also want the end user to be able to filter these columns on this table by searching for a text within the text. Normally this is done by the 'Filter by' option that shows up at the column options (please see the image below), but I'm not able to select this option. How can I enable this option so that the users can filter by text when they're using the app?

Please also look at the image below for better understanding the problem 🙂

Many thanks!

All responses (6)

Answers (1)

ege 29 on 08 Jul 2024 at 12:12:28

Like (1)

Report

Re: 'Filter by' option for column isn't selectable

Thanks a lot, I'll need a workaround method then.
Verified answer

bob_taylor_pp 203 on 08 Jul 2024 at 12:10:24

Like (2)

Report

Re: 'Filter by' option for column isn't selectable

Modern data table is one of the new modern controls that are available for preview. The filter on that table are not working at the moment. Workaround is to use text-input, drop down or combobox controls to filter the data.
ege 29 on 08 Jul 2024 at 12:04:42

Like (1)

Report

Re: 'Filter by' option for column isn't selectable

How do I create a 'modern data table' ? I didn't know my table wasn't modern enough 😄 I created it directly from the screen templates 'headers and table'
bob_taylor_pp 203 on 08 Jul 2024 at 11:59:31

Like (1)

Report

Re: 'Filter by' option for column isn't selectable

End-User can filter the specific Data in the modern data table if you add text-input, drop down or combobox controls in your screen. It depends on the use case and what the end-user wants to filter...
ege 29 on 08 Jul 2024 at 11:46:11

Like (1)

Report

Re: 'Filter by' option for column isn't selectable

Hi @anandm08,

Thanks for replying but my question isn't exactly about that. The filter in the code is already implemented as you mentioned, but I'm asking for the end-user side. Is there a way for the end-user to filter the overall table generated in the app? I looked for an option in the 'Advanced' and 'Properties' tab of the table but couldn't find the option I was looking for.
anandm08 1,936 Super User 2024 Season 2 on 08 Jul 2024 at 10:15:23

Like (1)

Report
Re: 'Filter by' option for column isn't selectable

hi @ege ,
Assuming you have a gallery named GalleryMembers that displays the members, set the Items property of GalleryMembers to:

Filter( Office365Groups.ListGroupMembers(), TextInputSearch.Text in displayName || TextInputSearch.Text in jobTitle || TextInputSearch.Text in mail )