Please guide me with a solution that will work with large data
Let have two Table in dataverse (Join tables)
1) Requests
***eTRRequestID
PatientInfoHospitalNo
PatientInfoGender
PatientInfoName
PatientInfoDoB
2)ExamRequestsDetails
***eTRRequestID (LookUp)
eTRRequestIDLineItem
eTRRequestStatus
Examination
I want to display in Power Apps Galley (perform > Filter, Search, Sort)
sample data
< eTRRequestID_eTRRequestIDLineItem | eTRRequestStatus | Examination | PatientInfoHospitalNo | PatientInfoGender | PatientInfoName | PatientInfoDoB >
10002_101 | Open | Exam01 |P00019| M|PNam01 | 12/03/2001
10002_102 | Open | Exam04 |P00019| M|PNam01 | 12/03/2001
10002_103 | Done | Exam10 |P00019| M|PNam01 | 12/03/2001
10002_104 | Open | Exam22 |P00019| M|PNam01 | 12/03/2001
10001_101 | Open | Exam01 |P00078| M|PNam79 | 09/07/1978
10001_102 | Close| Exam04 |P00078| M|PNam79 | 09/07/1978
10001_103 | Open | Exam10 |P00078| M|PNam79 | 09/07/1978
@VTandon , I am assuming that the Requests is related to ExamRequestsDetails in a One-to_Many Relationship.
You can have two galleries: First one is to show the Requests:
GalleryRequests Datasource Property = Requests
Second Gallery, GalleryExamRequestsDetails Datasource Propoerty =GalleryRequests.Selected.ExamRequestsDetails
For the search through the Requests Gallery, add a text input control and use similar formula in the
GalleryRequests Datasource Property = Search(Requests, TextBox.Text, ColumnName,ColumnName,...)
To sort, you can sutomatically sort the by adding SortByColumns(Search(Requests, TextBox.Text, ColumnName,ColumnName,...),SortColumn, SortOrder)