3 table request and show in gallery

[Anonymous]

Hello,

I'm tring to build an app for managing the workshop of my company

I have a home screen where i want to show the session to wich people are registered, in a Gallery

This app is based on Sharepoint Online lists

I have a table "T_Session"  of all workshop available for people :

When people register, they create a new record in a list called "t_personne"

Then, it creates a new record in a list named "t_inscritption"  where we can find .

• The ID of the session (FK_session)
• The ID of the entry of the people as seen before (FK_Personne)
• The status of their registration(not important here)

What i can do now :

Now, i can lookup for the last macthing ID of "t_personne"

What i need now :

I need help to get some command lines who catch the entry who has been created by the user when they register, then find in "T_inscription" the record where the ID i used and take the "FK_session" content and then show in the gallery only the record that matches with the ID

If someone need more informations, i will answer you.

Many thank for taking some times to help me 🙂 !

[Drrickryp]

Hi @Anonymous 

I am not sure how to address your specific requirements but a thorough understanding of database principles and how they apply to PowerApps would possibly help.  See my blog posts on this topic starting with https://powerusers.microsoft.com/t5/News-Announcements/Database-Design-Fundamentals-and-PowerApps-An-Overview/ba-p/184485 the overview.  The third part specifically addresses how to construct the app using SharePoint lists.