I currently have a 'data table' (not gallery) in my Canvas App that displays my dataverse table, with all of it's columns (100 columns) and data (5000 rows). My issue is that I'm unable to filter/multi-filter, sort or search for columns. I have this set up for 3 columns separately, but I am wondering what the most efficient way would be to add a search, multi-filter and sort function for every single column header in the datatable. In this specific screen, I don't need the ability to edit any of the data just view and search for it (almost like a dataverse table in read-only mode).
Keep in mind, my dataverse table contains text, choice, formula, multiline, date and number fields. I understand that this will require a lot of customization (most likely), but I am willing to put the time in to make it work.
Any tips would be appreciated.


Report
All responses (
Answers (