The gallery I inserted does not have the same order of the items in excel as my data source. Instead, it sorted them alphabetically which I do not want, How to reorder the item to match the excel table?
You can use sorting in Gallery
Click on Gallery then items
Sort( Table, Formula [SortOrder ] )
You can refer this site to get clear understanding about Sorting
Please Mark as Answer if it's helpful
What is the formula in the Items property of your gallery? If you don't have an ID column for the Excel table, you should add one and you can sort your gallery based on that column.
The formula is:
SortByColumns(Search([@var], TextSearchBox1.Text, "Variables","status"), "Variables", If(SortDescending1, Descending, Ascending))
I do not have ID column. There are only two columns with list of variables not including names or ID.
This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.
Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.
At the monthly call, connect with other leaders and find out how community makes your experience even better.