cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

using with filter

im 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..

norazimah_0-1632790117785.png

 

 

 

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)

norazimah_1-1632790117798.png

 

 

result :

norazimah_2-1632790117629.png

 

 

0 REPLIES 0

Helpful resources

Announcements
Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Top Solution Authors
Top Kudoed Authors
Users online (4,075)