cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

3 table request and show in gallery

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 :

Yannick_C_2-1607432186853.png

 


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

Yannick_C_0-1607431369982.png

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)

Yannick_C_1-1607431804862.png

 

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

 

 

1 REPLY 1
Drrickryp
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 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. 

Helpful resources

Announcements
Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Power Apps Ideas

Check out the New Ideas Site

We are excited to announce a new way to share your ideas for Power Apps!

Top Solution Authors
Top Kudoed Authors
Users online (3,719)