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
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)