Filter OnSelcet Status Value

[sunilkumar]

I have a status calculation on list of items in the power apps, which added with New, In-progress, On Hold and New request.

Currently it is working fine to calculating the value from SP list. I would like to add a filter when the user click on anyone of the status it should automatically filter the respective status items list in the Gallery,  Since, i am already using a filter formula in the Gallery along with that i want add the above filter option also. can some help me to how to add the formula in powerapps for my above requirement please.

kindly see the attachment for reference.

Thanks 

Sunil

[eka24]

Try this :
1. Insert a combobox, in the items property, put ["New","In-progress","On Hold","New request"]
2. Alternatively, if these are in a table in your sharepoint list ( New, In-progress, On Hold and New request) the put the TableName in the items property of the combobox
3. Finally, expand your formula on the Gallery as follows:
Filter('Your List Name',StartsWith(PartNumber,InputText.Text)&&Combobox.Selected.Value)

If you like this post, give a thumbs up. Where it solved your issue, Mark as a solution

[v-yutliu-msft]

Hi @sunilkumar ,

Do you want to filter the gallery items based on the selected status?

If so, I suggest you use a variable to filter. The variable value will be changed based on which status you select.

I've made a similar test for your reference:

1)set the all request label's OnSelect:

Set(var,"all")

set the new label's OnSelect:

Set(var,"New")

set the in-process label's OnSelect:

Set(var,"In-progress")

set the completed label's OnSelect:

Set(var,"Completed")

set the on-hold label's OnSelect:

Set(var,"On Hold")

2)set the gallery's Items:

Filter('CMM Offline Program List',
       StartsWith(....,....),
       If(IsBlank(var)||var="all",true,Status.Value=var)
       )

Then the gallery will filter based on the label that you choose.

Best regards,

[metrology]

i have applied as suggested but it't not working.

see the formula in below 

1. set all request label's OnSelect:

Set(var,lblAllRequestCir)

Set(var,lblNewRequestCir)

Set(var,'lblin-progressCir')

Set(var,lblCompletedCir)

Set(var,lblOnHoldCir)

2. gallery's Items::

Filter('CMM Inspection Request Form', StartsWith(Part_x0020_Number, TextInput_PartNumber.Text));
Filter('CMM Offline Program List',
StartsWith(....,....),
If(IsBlank(var)||var="lblAllRequestCir",true,Status.Value=var)
));

[v-yutliu-msft · Accepted solution]

Hi @metrology ,

I'm sorry that I left "" in my previous reply.

Try this:

1. set all request label's OnSelect:

Set(var,"lblAllRequestCir")

Set(var,"lblNewRequestCir")

Set(var,"lblin-progressCir")

Set(var,"lblCompletedCir")

Set(var,"lblOnHoldCir")

2.Could you describe more clearly about what are the two filter formulas used?

You could only use one Filter formula in one gallery.

For example, set gallery1's Items:

Filter('CMM Offline Program List',
StartsWith(Part_x0020_Number, TextInput_PartNumber.Text),
If(IsBlank(var)||var="lblAllRequestCir",true,Status.Value=var)
))

Could you tell what is this formula used for ?"Filter('CMM Inspection Request Form', StartsWith(Part_x0020_Number, TextInput_PartNumber.Text))"

Best regards,

[v-yutliu-msft]

Hi @sunilkumar ,

Do you have any other problems now?
I want to know whether your problem has been solved.😀

If it has been solved, could you mark my answer?

Best regards,