how to display the top 2 records today - Sort Gallery ?

[bbsin]

Hi

I like to display top 2 today's upcomingrecords.. what did I do wrong.  Thanks 

Date field in SP is Date and Time.

[v-jefferni]

Hi @bbsin ,

Could you please tell:

1\ What is the Control and property you are applying the formula on?

2\ The whole formula?

Best regards,

Community Support Team _ Jeffer Ni
If this post helps, then please consider Accept it as the solution to help the other members find it.

[bbsin]

hi @v-jefferni 

I want to the items that are happening today top 2 base on the start time and date, title and status confirmed and items that are blocked by the current user not other info.

Status and title are text field

Start Date - is set as date and time

thanks

will this help??

[v-jefferni]

Hi @bbsin ,

The formula is with wrong syntax, an extra coma as well as a closing parenthesis.

Best regards,

Community Support Team _ Jeffer Ni
If this post helps, then please consider Accept it as the solution to help the other members find it.

[bbsin]

Hi @v-jefferni 

Thanks for pointing it out.. but why no data showing.. am I missing something?  Thanks

[v-jefferni]

Hi @bbsin ,

Not sure, please check the values of varUser.Email and EmployeeEmail, maybe it is the capitalization issue. If so, add Lower() to both EmployeeEmail and varUser.Email

Best regards,

Community Support Team _ Jeffer Ni
If this post helps, then please consider Accept it as the solution to help the other members find it.

[bbsin]

@v-jefferni 

it's still not showing??

Thanks

[v-jefferni]

Hi @bbsin ,

Please try in the filter function:

Lower(ReservedBy.Email) = Lower(varUserEmail)

The point of checking gallery filtered items is restrict conditions from one to more, first check the whole data table without any condition(remove the filter function but leave the data source), then add filter function and try all conditions one by one.

On your end, try Lower(ReservedBy.Email) = Lower(varUserEmail) condition then DateBooked >= Today() one by one.

Best regards,

Community Support Team _ Jeffer Ni
If this post helps, then please consider Accept it as the solution to help the other members find it.

[bbsin]

Hi @v-jefferni 

Great!! it's appears now, but there's delegation warning?  How get around it?  Thanks.

[v-jefferni]

Hi @bbsin ,

There's no perfect way the work around it. I just wonder why there is capitalization issue for Email addresses. Could you please consider adjust all Emails to lower case? Then the Lower() function is not needed.

Best regards,

Community Support Team _ Jeffer Ni
If this post helps, then please consider Accept it as the solution to help the other members find it.