Showing results for 
Search instead for 
Did you mean: 
Not applicable

3 table request and show in gallery


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 🙂 !



Super User
Super User

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 the overview.  The third part specifically addresses how to construct the app using SharePoint lists. 

Helpful resources

Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Community Call Conversations

Introducing the Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (4,503)