How to Alphabetize new Form Records in Gallery View and SP List

(1) Share

Report

Posted on by nevik1

Hi. I'm working with a Gallery and Form that uses an SP List as Data Source. When the user uses the form's "save" button with OnSelect = fx SubmitForm(FormName) to upload the new info, the new record in the Gallery and the SP List is added to the bottom of the list. I'd like it to be alphabetized using the firs column "name" field as and example please. Thanks!

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (0)

Sort by

Suggested answer

Michael E. Gernaey 53,963 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!

Hi

You would wrap your stuff in

SortByColumns(InsertYourCurrentItemsValueHere, "NameOfColumnInQuotes", SortOrder.Ascending)

Or use SortOrder.Descending

And done.

Please Mark as Answer if this helps and maybe a like.

Was this reply helpful? Yes No
nevik1 6 on at

Like
a
(0)

Report
Copy link

Link copied!

Tnx for the response. So as a newbie "wrap your stuff in..." sadly isn't specific enough.

I have SubmitForm(frmNew_2) w/o the Sort control. How does one wrap SortByColumns('IDTC Survey', FirstName) control?

Don't understand the logic. I think I'd need to SubmitForm first to add new fields\a record, and then sort all in the same code statement.

Thanks!

Was this reply helpful? Yes No
timl 37,212 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi CU17091535-0

You would apply the formula to the Items property of your gallery control. The formula in the OnSelect of your button would stay exactly as it is.

The formula you would use to set the Items property of the gallery looks like this:
SortByColumns(YourSharePointList, "NameColumn",SortOrder.Ascending)

To sort the data that you see directly in SharePoint, you would need to modify the view. Here's a link to how to do this.

https://support.microsoft.com/en-us/office/use-sorting-to-modify-a-sharepoint-view-1e85d6e7-bdb3-4176-b1cb-62c5fbd3ef98

Was this reply helpful? Yes No
nevik1 6 on at

Like
a
(0)

Report
Copy link

Link copied!

Ok. My Gallery Items = fx already includes Filtering so the App users only see the records where their email is listed, so i'd need to use it with SortByColumn together. Not sure of the syntax b/c what I tried below does not work.

e.g.,

SortByColumns(

Filter('My Survey',email1 = User().Email || email2= User().Email || email3 = User().Email

),"FirstName",SortOrder.Ascending)

Thanks!

Was this reply helpful? Yes No