cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
tommyrihu
Level: Powered On

Sort by date Sharepoint list

Hi 

 igot problem with sorting in powerapps a sharepoint list "Helpdesk" by Column " created

In sharepoint it looks good,but in Powerapps all tickets are Random  then users create a new ticket 

 

 i have this in the app  (columns)

Kommentar

Status 

Skapad

 2018-09-21 15_28_35-Helpdesk.png

 

just dont get  how to fix it

please i fo some know how ti fic this

 

Best Regards

Tommy

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: Sort by date Sharepoint list

Hi @tommyrihu,

 

Nothing to be ashamed of.  You could have used "Created" instead.  Sharepoint automatically assigns a date and time and several other system columns when a new record is created.  From a standpoint of Sorting, either one will work.  If you want to see them, Put a label in your Gallery and in the text property, type ThisItem.  Powerapps will then show you all the different columns including the system ones that are created automatically. If this answers your question, please accept the reply as Solved.  Thanks Tommy, good luck.

View solution in original post

6 REPLIES 6
Super User
Super User

Re: Sort by date Sharepoint list

Hi Tommy,

Please post the Items property of your gallery.

tommyrihu
Level: Powered On

Re: Sort by date Sharepoint list

Hi drrickkryp

 

thanks for taking time to help me out

 

 

SortByColumns(Filter(Helpdesk; StartsWith(Title; TextSearchBox1.Text)); "Title";
If(SortDescending1; Descending; Ascending))

 

/tommy

Super User
Super User

Re: Sort by date Sharepoint list

Change the "Title" to "ID"  between the ; ; 

tommyrihu
Level: Powered On

Re: Sort by date Sharepoint list

Awesome! Drrickryp 🙂 

but i will a little bit shame  that is was just the ID

 

SortByColumns(Filter(Helpdesk; StartsWith(Title; TextSearchBox1.Text)); "ID";
If(SortDescending1; Ascending; Descending))

 

but cant understand how it sort i by date on ID and as i thought it would pick iy up on Created?

and can i and moree stuff  under this  SortByColumns(Filter(Helpdesk; StartsWith(Title; TextSearchBox1.Text)); "ID";
If(SortDescending1; Ascending; Descending))

 

Big thanks Drrickryp

 

/Tommy

Super User
Super User

Re: Sort by date Sharepoint list

Hi @tommyrihu,

 

Nothing to be ashamed of.  You could have used "Created" instead.  Sharepoint automatically assigns a date and time and several other system columns when a new record is created.  From a standpoint of Sorting, either one will work.  If you want to see them, Put a label in your Gallery and in the text property, type ThisItem.  Powerapps will then show you all the different columns including the system ones that are created automatically. If this answers your question, please accept the reply as Solved.  Thanks Tommy, good luck.

View solution in original post

Highlighted
tommyrihu
Level: Powered On

Re: Sort by date Sharepoint list

Case Solved Drrickryp 

 

have a nice weekend 🙂

best regard 

Tommy

Helpful resources

Announcements
thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

Top Kudoed Authors
Users Online
Currently online: 256 members 6,511 guests
Please welcome our newest community members: