Unanswered

Parent Child Data in powerapps

(0) Share

Report

Posted on by ddhasanrana

01. I have 3 collection list which is "col_Parent_Data", "col_Child_Data" & "temp_Item_Data". // ok

02. I am using gallery (gallery1) to show data and store data at "temp_Item_Data" for temporary add for saving to "col_Child_Data". // ok

03. I am using another gallery (gallery2) to show "col_Parent_Data" // ok

04. select on gallery (gallery2) to modify "col_Parent_Data", & "col_Child_Data". Parent data at different textbox from "col_Parent_Data" selected data, its ok. but i could not load at "temp_Item_Data" from "col_Child_Data" which related with "col_Parent_Data". (parent child relationship data)

Advanced thanks

Categories:

Building Power Apps

I have the same question (0)

All responses (9)

Answers (0)

Sort by

WiZey 3,023 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

Hello @ddhasanrana ,

What have you tried so far to populate "gallery1" with "col_Child_Data"?

Is "Filter()" enough to return a table based on "col_Parent_Data"?

Was this reply helpful? Yes No
ddhasanrana 17 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks for your reply.
Point 1. Add Products, in this scenario, i am using a temporary collection (temp_Item_Data) list which point to at Number 2(its gallery)
Point 2. Gallery 1 ( i added lavel to show temporary collection from temp_Item_Data)
Point 3. Gallery 2 (List of Invoice show from col_Parent_Data.)
Note: Now i am trying to filter from col_Child_Data and load at temp_Item_Data list on select event at Gallery 2 from

Was this reply helpful? Yes No
WiZey 3,023 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
So basically, you could add a "ClearCollect()" in the "OnSelect" of your gallery2 to change the content of your "temp_Item_Data" based on the selected invoice.

ClearCollect( temp_Item_Data, Filter( col_Child_Data, //Select every child item related to the parent ParentID = ThisItem.ID ) )

Would that help you?

Was this reply helpful? Yes No
ddhasanrana 17 on at

Like
a
(0)

Report
Copy link

Link copied!
ClearCollect( temp_Item_Data, // temp_Item_Data, its already created, in this scenario i got error Filter( col_Child_Data, fk_MasterId= gl_Master.Selected.MasterId ) ) // this code make new collection, which not createed in previous time. But i want to move filter list data to my existing collection list (temp_Item_Data) which i created in previous time.

Was this reply helpful? Yes No
WiZey 3,023 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

If you want to add records to a collection without deleting its content, you can use "Collect()" instead of "ClearCollect()".

Was this reply helpful? Yes No
ddhasanrana 17 on at

Like
a
(0)

Report
Copy link

Link copied!

@WiZey Thanks for your reply.

Invoice Entry Ready
01. Form is ready to entry data
ItemNameCollection ,collect data in this list
02. Add Product basically i collect Product List (child data) at ItemNameCollection
ItemNameCollection, this list data point in this gallery
03. ItemNameCollection list data point in this gallery.ItemNameCollection, this list column point at level to show data in this gallery
04. ItemNameCollection list data point at specific column
delete from this list ItemNameCollection
05. remove from ItemNameCollection this list
save data to Order List & Product List
06. save data to Order as Master data, Product as Child data.
07. another gallery Name is InvoiceList_1, show all Order list
08. Note: In this position, i want to show / move filter product data (child data) at ItemNameCollection list. but i got error. But If i add new collection name then copy filter data in this new collection list. Now, how can I load filter data at my existing ItemNameCollection list.
09. selected data show at textbox
Note: I was tried at 8 no position. would you give me a solution. Or if you have another better solution for Invoice Crude operation like this design. please suggest me. thanks a lot.

Was this reply helpful? Yes No
WiZey 3,023 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

Could you show what error you get on 8th screen please? It seems Power Apps reject the whole "Collect()" function even though it appears correct.

Was this reply helpful? Yes No
ddhasanrana 17 on at

Like
a
(0)

Report
Copy link

Link copied!

@WiZey thanks for your reply.
It's existing collection name which already created at 2 no screen by "Add Products"
If I create new collection at 8 no screen then it will okay. But I want to load at previous collection list at 8 no screen. How can I use my existing collection list name at 8 no screen. Would you please give me solution. Thanks

Was this reply helpful? Yes No
WiZey 3,023 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

I would be glad to, but in order to help I need to know what error message Power Apps is returning on your "Collect()"on the 8th screen.

Could you check on the stethoscope in the upper right corner of Power Apps and look for the error message please?

Was this reply helpful? Yes No