Child list records in sharepoint parent list

(0) Share

Report

Posted on by javierz

186

Dear
your great help

thanks to the videos of Shane, I have created in my app, ticket request the option to insert several lines for (cities)

now
I'm just looking to join the parent list with the records in the child list
in the video the galleries show all the records, but in my case I try to show only the children records, to avoid confusion in the purchase of the tickets

I have tried in various ways but without success
Is this possible?

Thank you

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Verified answer

Drrickryp Super User 2024 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Hi @javierz,

You can filter a second gallery or datatable with the DataSource YourChildList by setting the Items property to Filter(YourChildList,ParentID=Gallery1.Selected.ID) where ParentID is the Foreign key in the Child list.

You can Edit a form for a single item in the child list by setting the Datasource property to YourChildList and the Item property to Lookup(YourChildList,ID=Gallery2.Selected.ID). Check out the thread add-values-in-a-one-to-many-connection for an example and some suggestions.

Was this reply helpful? Yes No
javierz 186 on at

Like (0)

Report
Copy link

Link copied!

Thanks for the help
finally managed to see only the records that I need
now I continue with the option to edit them the children parents in the same window

thank you

Was this reply helpful? Yes No
Drrickryp Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi @javierz,

If this answered your question please mark the thread as solved.

Was this reply helpful? Yes No