How to display data in the forms in different pages that use different source of sharepoint lists

(0) Share

Report

Posted on by CS-22110215-0

Hi community, I'm currently creating a power app with 4 screens. Three of them are forms which uses data from 3 different SharePoint lists.

Another one contains vertical gallery which will displays all the user input record and here user can create/edit/delete their record. This gallery also uses different SharePoint list which keeps user transactions.

Each record in all 4 SharePoints relate to a column called processID.

Until this step, I have a question regarding how to retrieve and display the data when user click on edit(pencil) button on the gallery screen. The user input data needed to be show in the text input of every forms.

If not using function Lookup() or Filter(), is there any other ways to display data to the form control. Or if using these functions is the only way to display data in the forms

Categories:

Experimental features

I have the same question (0)

All responses (2)

Answers (0)

Sort by

Suggested answer

Inogic 1,297 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
Hi,

One another way to retrieve and display data without using Lookup() or Filter() is by using collections. When a user clicks the Edit button in the gallery, you can store the selected record in a collection, and then bind the form controls to that collection.

Step 1: Store the Selected Record in a Collection
In the OnSelect property of the Edit button inside the gallery, use ClearCollect() to store the selected record in a collection:

OnSelect = ClearCollect(SelectedRecordCollection, ThisItem);
Navigate(DisplayFormScreen);

Step 2: Bind the Form to the Collection
On the DisplayFormScreen, set the Item property of the form to the first item in the SelectedRecordCollection:

Item = First(SelectedRecordCollection)

Step 3: Display Data in Form Controls
The form controls will automatically display the selected record’s data. For example, if you have a TextInput for the Title field, it will be populated with the value from the collection:

Default = First(SelectedRecordCollection).Title

Hope this helps.

Thanks!
Inogic Professional Services: Power Platform/Dynamics 365 CRM
An expert technical extension for your techno-functional business needs
Drop an email at crm@inogic.com
Service: https://www.inogic.com/services/
Tips and Tricks: https://www.inogic.com/blog/

Was this reply helpful? Yes No
WarrenBelz 156,384 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hi CS-22110215-0

The detail here (which you have not posted) is the "key" or common field linking the lists. I generally use a numeric field (I call it IDRef) containing the ID of the "parent" list, although you can link/relate the lists on any common text or numeric field.

There are a couple of options to display these "other list" fields in a gallery including a Lookup on each one in a Text Label in the gallery (processor intensive and a lot of API calls) or if both the reference list/s and the returned data set to your gallery are under your Data Row Limit, you can use AddColumns in the Gallery Items with some "pre defining" of the source (I will get further into this if I am correct in what you are trying to do and you supply some more detail on your data structure and required field names and types).

Was this reply helpful? Yes No