Sort a report table by user

[Tritonos_Gruppe]

Hi

I am trying to send a report with a table with data between 2 dates and what only data entered by logged in user to be sendt so I added to the beginning.

User is logged as USERMAIL() in Initial value so should be good.

<<Start:SORT(USERMAIL()=[User], [TimeLog]>>

<<[Date]>>

I thought this would be the right place to insert my expression. Advice is appreciated.

[Aleksi]

You need to specify the table and key column as well. So it could be something like…
<<Start: ORDERBY(SELECT(TableName[KeyColumnName],[User]=USEREMAIL()),[TimeLog],TRUE)>>

[Tritonos_Gruppe]

Hi
Still struggling with this topic here.

I have an timesheet app and all users are linked with (USERMAIL)
I have created a send report workflow, but I am not able to sort the table by the user, it will also show other users. I think ORDERBY is not ment to be but not sure what to use instead?
This is my code:

<<Start: ORDERBY(SELECT(Timesheet[Timestamp],[User]=USEREMAIL()),[TimeLog],TRUE)>>

<<[Date]>>

My table

Send report UX

[Steve]

Instead of this:

<<Start: ORDERBY(SELECT(Timesheet[Timestamp],[User]=USEREMAIL()),[TimeLog],TRUE)>>

Try this:

<<Start: ORDERBY(FILTER("Timesheet", (USEREMAIL() = [User])), [TimeLog], TRUE)>>

[Tritonos_Gruppe]

Hi Steve

It still will not give me the list that gets sorted from my send report table, I keep getting all rows not the ones that are between the dates I choose.

On that page it will show me the correct dates but not on my final report.

As you see here it sorts out the right dates.