Hi,
I have a sharepoint list in wich I have data of my aircraft fleet. I need my app to do these:
1. A main screen in which I select my location (attached: main screen1)
2. I want a second screen with all the aircrafts located in that place sorted by registration plate (main screen1 style)
3. Also I want a third screen with a browse gallery already sorted by the choice I made in screen 1 and screen 2 (attached: browse screen)
My question is: Is there any way to previously filter a screen with my selection in the prior screen?
Thank you very much
Solved! Go to Solution.
Hi @Anonymous
Filter(AircraftRegistration, Location = SelectedLocation)
Filter(AircraftDetails,Location = SelectedLocation && AircraftRegistrationNumber = Gallery1.Selected.RegistrationNumber)
Hi @Anonymous ,
Try using the Distinct() Function:
In your case:
Distinct(Filter(AircraftRegistration, Location = SelectedLocation), PlateColumnName)
This will give the distinct values of Plate that fits the condition in the filter.
----------------------------------------------------------------------------
Thanks,
K-A-R-L
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If you thought this post was helpful, please give it a Thumbs Up.
Hi @Anonymous
Hi @Anonymous
Filter(AircraftRegistration, Location = SelectedLocation)
Filter(AircraftDetails,Location = SelectedLocation && AircraftRegistrationNumber = Gallery1.Selected.RegistrationNumber)
Hi @yashag2255,
Thank you very much for your answer, is perfect 🙂
But I have a problem with the second screen:
The registration plates appear sometimes several times and I would like to have each plate only once. Is there a way to eliminate duplicate values?
Hi @Anonymous ,
Try using the Distinct() Function:
In your case:
Distinct(Filter(AircraftRegistration, Location = SelectedLocation), PlateColumnName)
This will give the distinct values of Plate that fits the condition in the filter.
----------------------------------------------------------------------------
Thanks,
K-A-R-L
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If you thought this post was helpful, please give it a Thumbs Up.
Hi @Anonymous
Hi,
Many thanks! @yashag2255 It works perfectly 🙂
Salamat Po @K-A-R-L pinaka solusyon! 🙂
Best regards,
Javier
User | Count |
---|---|
254 | |
112 | |
92 | |
48 | |
38 |