I am still fairly new to Power Apps and need some guidance.
I am creating a canvas application that takes a user's address inputs and creates a collection. This collection allows me to utilize the Bing Maps "Get Route" function and calculate the distance between the collection address and the gallery's vendor locations (data set is 20k+ rows so I have to avoid delegation). The vendor gallery should be filtered by the product gallery first and then by the distance <= radius. I also need the gallery to be sorted by the distance (smallest to largest). I am utilizing a dropdown for the radius values outside of the vendor gallery and the distance is calculated and shown within the gallery for each vendor with no ties to a table. The vendor data is connected to a Dataverse table. the current formula for the vendor gallery items is as follows:
Gallery Items Formula
User | Count |
---|---|
209 | |
94 | |
84 | |
49 | |
39 |
User | Count |
---|---|
264 | |
104 | |
104 | |
61 | |
59 |