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
Better Together’ Contest Finalists Announced!

'Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

thirdimage

Power Apps Community User Group Member Badge

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

sixthImage

Join THE global Microsoft Power Platform event series

Attend for two days of expert-led learning and innovation on topics like AI and Analytics, powered by Dynamic Communities

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

thirdimage

Microsoft Business Applications Virtual Launch

Join us for the Microsoft Business Applications Virtual Launch Event on Thursday, April 2, 2020, at 8:00 AM PST.

thirdimage

Community Summit North America

Innovate, Collaborate, Grow - The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors
Top Kudoed Authors
Users online (6,333)