I have a gallery in which I am showing data from a dropdown, when selecting an item from the dropdown the gallery is loaded with the corresponding data.
To display the data in the gallery I make use of the Items property in which I make use of the following formula:
Filter(
'Warehouse';
'RecordAssigment'.Id_record = Dropdown1.Selected.Result;
StartsWith(
'Description ';
TextInput1.Text
)
)
Description: "United Kingdom",
Description: "Germany",
Description: "Spain",
Description: "Germany",
Description: "Spain",
Description: "Germany"
Distinct('Warehouse';'RecordAssigment'.Id_record)
Solved! Go to Solution.
Hi @sebastianslz ,
This is "almost" Delegable as the top filter needs to return less records than your Delegation limit (it can query any number of records)
With(
{
wList:
Filter(
'Warehouse';
'RecordAssigment'.Id_record = Dropdown1.Selected.Result &&
StartsWith(
'Description ';
TextInput1.Text
)
)
},
With(
{
wGroups:
AddColumns(
GroupBy(
wList;
"Description ";
"Data"
),
"gID";
First(Data).ID
)
},
Filter(
wList;
ID in wGroups.gID
)
)
Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.
Visit my blog Practical Power Apps
Hi @sebastianslz ,
This is "almost" Delegable as the top filter needs to return less records than your Delegation limit (it can query any number of records)
With(
{
wList:
Filter(
'Warehouse';
'RecordAssigment'.Id_record = Dropdown1.Selected.Result &&
StartsWith(
'Description ';
TextInput1.Text
)
)
},
With(
{
wGroups:
AddColumns(
GroupBy(
wList;
"Description ";
"Data"
),
"gID";
First(Data).ID
)
},
Filter(
wList;
ID in wGroups.gID
)
)
Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.
Visit my blog Practical Power Apps
I have a blog on the With function that may assist, but essentially it is setting a Table Variable (call it a Collection) of your filtered data - it has a limit in output governed by Delegation, but I suspect yours will be well within it. I then use GroupBy() to get the unique Description records, but this returns only one field (Description), so I also capture the ID of those records and further filter the Record Variable (at the top) by the ID, getting your entire records back for the gallery.
User | Count |
---|---|
257 | |
127 | |
104 | |
49 | |
49 |