cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Yannick_C
New Member

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 @Yannick_C 

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

Helpful resources

Announcements
PA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.

PA.JPG

New Release Planning Portal (Preview)

Check out our new release planning portal, an interactive way to plan and prepare for upcoming features in Power Platform.

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