Share
Reportim using this code for filter
With({lclChoices : Choices(Supplier.'Task Status')},ForAll(Sequence(CountRows(lclChoices)+1),{Value:If(Value=1,"All",Last(FirstN(lclChoices,Value-1)).Value)})) //Choices(Supplier.'Task Status')
but when click on ALL the filter item is not work..
at the gallery i put this code
SortByColumns(Filter(
Supplier,
StartsWith('Supplier Name',textboxsearchinput.Text) && ('Task Status'.Value=StatusFilter.Selected.Value||StatusFilter.Selected.Value=Blank()),
'Created By'.DisplayName=Office365Users.MyProfile().DisplayName),varSortColumn,varSortDirection)
result :
Categories:
All responses (
Answers (
345
