Hello,
I have a primary data source, datasourceA, which stores all submissions from many different users. datasourceA looks something like this:
| Building | Room | Clean | Date |
| Building A | 100 | Daily | 6/23/2021 |
| Building A | 101 | Daily | 6/23/2021 |
| Building A | 100 | Weekly | 6/21/2021 |
| Building A | 101 | Weekly | 6/22/2021 |
In one room (Room 100), there may be multiple different clean types done on different days (shown above as daily or weekly, datasourceA actually has about 6 clean types).
What I need to do is take a distinct list of rooms from datasourceA and display them in Screen A. I want to be able to choose a room from that list, which will take me to Screen B. I want Screen B to display the most recent date of each different clean type (daily, weekly, etc.).
I tried doing the following:
1. I collected the Date, Room, and Clean columns from datasourceA into listA using ClearCollect and GroupBy.
2. I used listA to get a distinct list (listB) based on the Room column so I could create a dropdown menu in Screen A that filtered by Room. The gallery (galleryA) in Screen A uses the result of the drop down menu. I added an icon to navigate to Screen B.
3. Screen B has Gallery B, which I would like to contain the most recent cleans that correspond to the selected room from Screen A. My issue (as you can probably see) is the only item stored in Gallery B is the distinct list of rooms in listB; the clean type and date are not stored in Gallery B. This makes it so I can't use ThisItem.Clean or ThisItem.Date in Gallery B.
How do I create this relationship? Is there a better way of doing this?
Thanks,
Nick
