Hello everyone, I hope you are well. This is my first post on this site and I would first like to thank you for sharing your knowledge and your availability to help newfite like me. My question is the following: I am developing an application on Power Apps that allows technicians in the field to display the interventions to be carried out on a residence. each residence has its own Excel file hosted on a SharePoint site.In all I have 95 Excel files for 95 residences. My home screen is a gallery that displays the list of residences. when we click on the name of a residence it brings us back to a screen that lists all the interventions to be treated in the residence in question... (I'll give more details if you need it). My problem is that for each residence I finally find myself with 3 screens. So if I continue like this I will have 95*3 screens so not great.
Can you please tell me how I can proceed so that this application is dynamic, so that only the database changes (by changing the residence clicked). I will provide further information if you find it useful. Thank you