Answered

Data in Browse gallery

(0) Share

Report

Posted on by haziqrahim

Hi,

I'm having a problem on function to be used to display data in browse gallery. Im trying to display item that follows certain conditions. Data is from my sharepoint list. What i want to do is to filter data that satisfy column 'confirmed 1' as confirmed or pending, column 'confirmed 2' as confirmed or pending and column 'Approved' as pending.

My working function right now as below

Filter('Jig Order','Approved'="Pending",StartsWith(Requestor, TextSearchBox1.Text))

The function above does not work to filter other column that contain value "rejected" as in the picture.

Really appreciate if anyone could help

Thanks a lot

Categories:

Power Apps Pro Dev & ISV

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

Static 118 on at

Like (0)

Report

Hi @haziqrahim
Well ,based on your requirements, you want to filter items where 'Confirmed 1' is either 'Confirmed' or 'Pending', 'Confirmed 2' is either 'Confirmed' or 'Pending', and 'Approved' is 'Pending'. You can got this using the And and Or operators. Here's how you can modify your formula:

Filter('Jig Order', 'Approved' = "Pending" && (StartsWith(Requestor, TextSearchBox1.Text) || IsBlank(TextSearchBox1.Text)) && ('Confirmed 1' = "Confirmed" || 'Confirmed 1' = "Pending") && ('Confirmed 2' = "Confirmed" || 'Confirmed 2' = "Pending") )

Here dete4ail i think expalnation what I show above.
'Approved' = "Pending": Ensures that the 'Approved' column is equal to "Pending".
StartsWith(Requestor, TextSearchBox1.Text) || IsBlank(TextSearchBox1.Text): Filters based on the 'Requestor' column matching the text in TextSearchBox1, or if TextSearchBox1 is blank, it skips this condition.
('Confirmed 1' = "Confirmed" || 'Confirmed 1' = "Pending"): Checks if 'Confirmed 1' is either "Confirmed" or "Pending".
('Confirmed 2' = "Confirmed" || 'Confirmed 2' = "Pending"): Checks if 'Confirmed 2' is either "Confirmed" or "Pending".

I hope this will help to you.

Best regards
Anton N.

Was this reply helpful? Yes No
haziqrahim 34 on at

Like (0)

Report

Great solution.

Also I found the solution by using an 'Or' instead of '||' function.

Thanks a lot

Was this reply helpful? Yes No