Answered

'Filter by' option for column isn't selectable

(1) Share

Report

Posted on 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!

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (1)

Sort by

anandm08 1,936 Super User 2024 Season 2 on at

Like (1)

Report
Copy link

Link copied!
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 )

Was this reply helpful? Yes No
ege 29 on at

Like (1)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
bob_taylor_pp 203 on at

Like (1)

Report
Copy link

Link copied!

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...

Was this reply helpful? Yes No
ege 29 on at

Like (1)

Report
Copy link

Link copied!

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'

Was this reply helpful? Yes No
Verified answer

bob_taylor_pp 203 on at

Like (2)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
ege 29 on at

Like (1)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No