
Hi, I have a gallery that shows me the items from the excel file. In excel there is a column "Group" which determines the affiliation of the assortment. filters are placed on the gallery:
With({asmt:Filter(
asortyment;StartsWith(
'Nazwa asortymentu';TextInput5.Text
)
)
};
If(
filtr.Selected.Result = "Pokazuj wszystko"; asmt;
Filter(
asmt;Grupa=filtr.Selected.Result
)
)
)
Filters present on the page onVisible
ClearCollect(kolekcja_filtr;{Result:"Pokazuj wszystko"});;
Collect(kolekcja_filtr;Distinct(asortyment;Grupa))
The problem is that in excel I have 7 groups and in powerapps I see only 5
powerapps has a limit of 500 records, when i set limit to 1000 I have an error cannot insert a new column to store identifiers