Answered

Filter OnSelcet Status Value

(0) Share

Report

Posted on by 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

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

Sort by

eka24 20,925 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
v-yutliu-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
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,

Was this reply helpful? Yes No
metrology 2 on at

Like (0)

Report
Copy link

Link copied!

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)
));

Was this reply helpful? Yes No
Verified answer

v-yutliu-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
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,

Was this reply helpful? Yes No
v-yutliu-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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,

Was this reply helpful? Yes No