Hi
I like to display top 2 today's upcomingrecords.. what did I do wrong. Thanks
Date field in SP is Date and Time.
Solved! Go to Solution.
Hi @bbsin ,
Use below formula since I believe there would not be many filtered records that DateBooked later than today, so although delegation issue would still be there, you could ignore it.
With({Filtered: Filter('data source',DateBooked >= Today())},Filter(Filtered,Lower(ReservedBy.Email) = Lower(varUser)))
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.
Community Support Team _ Jeffer Ni
If this post helps, then please consider Accept it as the solution to help the other members find it.
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.
Community Support Team _ Jeffer Ni
If this post helps, then please consider Accept it as the solution to help the other members find it.
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??
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.
Community Support Team _ Jeffer Ni
If this post helps, then please consider Accept it as the solution to help the other members find it.
Hi @v-jefferni
Thanks for pointing it out.. but why no data showing.. am I missing something? Thanks
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.
Community Support Team _ Jeffer Ni
If this post helps, then please consider Accept it as the solution to help the other members find it.
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.
Community Support Team _ Jeffer Ni
If this post helps, then please consider Accept it as the solution to help the other members find it.
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.
Community Support Team _ Jeffer Ni
If this post helps, then please consider Accept it as the solution to help the other members find it.
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Power Platform release plan for the 2022 release wave 2 describes all new features releasing from October 2022 through March 2023.
User | Count |
---|---|
199 | |
97 | |
56 | |
51 | |
41 |
User | Count |
---|---|
266 | |
156 | |
83 | |
81 | |
56 |