Skip to main content

Notifications

Power Apps - Microsoft Dataverse
Answered

Dataverse: working with +2 Table (Master, Detail) with large data

(0) ShareShare
ReportReport
Posted on by

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

Categories:
  • Verified answer
    AhmedSalih Profile Picture
    AhmedSalih 6,678 on at
    Re: Dataverse: working with +2 Table (Master, Detail) with large data

    @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)

     

     

     

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,691

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 65,019

Leaderboard

Featured topics