Unanswered

View Details screen and gallery data

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi All,

I have a requirement from one of the business process that we are trying to automate.

Where we are getting stuck is to show the records of data.

Submitting the data: We have one form and one gallery. We input the data in the form and then input the data in gallery. The form data is stored in List A with a random number generated. Gallery data is stored in List B with the same random generated number.

Now, we want to view the data. We can successfully view the form data from gallery selected item. But how do we show the List B data as List A and List B are connected through the random generated number so we would want to show the form details and gallery details once the user clicks the arrow button from the browse gallery screen.

Categories:

Building Power Apps

All responses (3)

Answers (0)

Sort by

Drrickryp Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@Anonymous

I cannot figure out why you are going through such a complicated process to do this. A gallery displays many or all of the records in a list, it can be filtered and sorted on the columns in the list to only show selected records and/or sort them.

A single form is used to submit a new record into that list or modify a record already in the list that is selected in the gallery. The same form can also be used to show all the data in a single record as read-only by setting its display mode.

Once the record is entered or modified, the gallery will automatically show it. From your description, you have duplicated the functions and unnecessarily complicated the process. Since you describe lists, I am assuming you are using SharePoint. If so, SharePoint already assigns an ID to every record in the list that is unique, sequential and not reused. Thus, I don't understand the need for the random numbers.

Please enlighten me if I am wrong about what you are doing here and the relationship between the lists ie. one-to-many or one-to-one? What business process are you trying to duplicate in PowerApps?
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

@Drrickryp the relationship between list a and list b is one to many: list a has one record matching many records in list b.
I have achieved the above requirement.
i used a gallery to display records many list b records pertaining to list a and also used a form to display list a record.
Florian_Kleinz 227 on at

Like
a
(0)

Report
Copy link

Link copied!
Hello,

If I understand you correctly you have to Tables which are "connected" with a random ID.
Let me assume that each List is represented by a collection.
colA for List A and colB for List B.
For the OnSelect of the gallery you can implement

Set(_curID;gal_A.Selected.ID); Navigate(DetailScreen)
On your Detail Screen you can Filter your Deteilas (List B)
Filter(colFB;ID=_curID)
Hope I got you right.

Best regards
Florian