Gallery Expect "Done" Status and only required Process Status should listed

(0) Share

Report

Posted on by Jawaharprem

286

Hi Team,

I Have Created a Edit Gallery Form my Query is Under header Check_Status "Done" should not list and Other Header Batch_Process "Batch Management" only should list

it is working for Check_Status but if i add the Batch_Process its getting error

Iam getting error in "Value" for Batch_Process

Pls help on same

Enclosed the code with error for your reference..

With( { wData: Filter( Batch_Management_Tracker, StartsWith( MEL, TextInput3.Text ) 
) }, 
ClearCollect( colGridDataBMM, Filter( wData, Check_Status.Value <> "Done", Batch_Process.Value="Batch Management")))

Thanks

Jawahar

Categories:

Building Power Apps

I have the same question (0)

All responses (1)

Answers (0)

narayan225 2,547 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
@Jawaharprem

Assuming that Check_Status and Batch_Porcess both are choice column, you can use or/and filter to get data.
Instead of applying two filters, you can complete it in one step. I am not sure what you are doing with StartsWith function though, its result is true/false.
ClearCollect(colGridDataBMM, Filter(Batch_Management_Tracker, Check_Status.Value <> "Done" && Batch_Process.Value="Batch Management"))
Hope this helps.

Cheers!

Was this reply helpful? Yes No