
Hi, I want to combine below two function into one. Can anyone advice on this?
Filter(
Search(
'PBI Usage Log',
txtSearchTitle_3.Text,
"Title"
),
UserId = User().Email
)Sort(
'PBI Usage Log',
Switch(varSortColumn,
"Report Name", ReportName,
"WorkSpaceName", WorkSpaceName,
"Report ID", ReportId,
"Creation Time", CreatedTime,
ID
),
varSortDirection
)
Hi @MrKoh ,
Please try:
Sort(
Filter(
Search(
'PBI Usage Log',
txtSearchTitle_3.Text,
"Title"
),
UserId = User().Email
),
Switch(varSortColumn,
"Report Name", ReportName,
"WorkSpaceName", WorkSpaceName,
"Report ID", ReportId,
"Creation Time", CreatedTime,
ID
),
varSortDirection
)
Best Regards,
Bof