web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Help for reptile husba...
Power Apps
Answered

Help for reptile husbandry

(0) ShareShare
ReportReport
Posted on by 18

Hi all, 

 

New user here trying to create a PowerApp to record details of my snakes.

 

I need the app to be able to go from

List of reptiles > service records (history) > View/Edit/New record

 

I've got the app showing a list of my data records as they're input but it is simple a list of all records as I've been inputting them. I'm wanting to be able to view my snakes (example Snake 1, snake 2, snake 3), click on the title (snake 1), and it take me to a list of records only relating to that particular snake. 

How do I go about doing this or is there a similar app template for record management (i.e. equipment service records)?

Categories:
I have the same question (0)
  • Verified answer
    iAm_ManCat Profile Picture
    18,256 Most Valuable Professional on at

    Heya @MattGCDT 

     

    Ok, so firstly, I hope you have a column that references the relationship between the tables - this could be something like ReptileID in your list of Reptiles, and then ReptileID in your list of service records - that will enable us to filter between the two when one is chosen.

     

    So you've said you have a list showing your list of reptiles, and you want that when you select it, it then goes to another screen to show a list of records relating to that reptile.

     

    Ok so our first screen we have a gallery listing all of the reptiles. the OnSelect of the Title object within the gallery is likely set to Select(Parent) at present as that is the default - we can leave that as it is, and then edit the OnSelect property of the gallery itself (click on the gallery in the left-hand-pane, then above that, choose OnSelect from the properties dropdown).

    Now we can change this OnSelect property to:

    Navigate(YourRecordDetailsScreenNameGoesHere)

     

    Then in your Record details screen, we have another gallery, its Item should be set to the Service Records list. We will then edit the Items property to filter that gallery by what you have chosen in the first gallery (we will call this gallery1 as that is what Power Apps will likely call it by default).

    Items property for this second gallery then becomes:

    Filter(ServiceRecordsListNameGoesHere, ReptileID = gallery1.Selected.ReptileID)

     

    This should now show a filtered list of Service Records based on what reptile you chose in the first gallery.

     

    Cheers,

    Sancho

  • MattGCDT Profile Picture
    18 on at

    Awesome - Thanks Sancho sorry for the delay but that has worked perfectly! And it's now ready to go and working great 🙂 

     

  • MattGCDT Profile Picture
    18 on at

    All good Answered my own follow up question 🙂 thanks again!

  • MattGCDT Profile Picture
    18 on at

    Okay @iAm_ManCat sorry I did have another question if you don't mind! My current Gallery showing my Reptile List shows "ThisItem.Modified", however this refers to the ReptileID List, and not my ServiceList. Is there a way I can get this to show the most recent date an entry was made in the ServiceList for that particular snake? 

     

    In the example below, I'd like to show that Snake 1 had a service record input on May 15, rather than the ReptileID list was updated on 23rd May

    Thanks so much! 

    MattGCDT_0-1684821938111.png

    MattGCDT_1-1684821964022.png

     

     

  • Verified answer
    iAm_ManCat Profile Picture
    18,256 Most Valuable Professional on at

    No worries!

     

    Ok, so I'm thinking that instead of ThisItem.Modified for that label, we can use this on the label:

    Last(Filter(ServiceList, ReptiIeD=ThisItem.ReptileID)).Created

     

    and what we are doing there, is we are filtering to the service items that relate to that particular item in the gallery, then we are getting the Last item in that filtered list which should be filtered by ID by default so Last will show the newest item, then we are getting the property of that record for created, so you should see the most recent service date when using this 🙂

  • MattGCDT Profile Picture
    18 on at

    Amazing! worked perfectly 🙂 Thanks so much! Legend 😄

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Apps

#1
wolenberg_ Profile Picture

wolenberg_ 119 Super User 2026 Season 1

#2
WarrenBelz Profile Picture

WarrenBelz 107 Most Valuable Professional

#3
Haque Profile Picture

Haque 103

Last 30 days Overall leaderboard