Unanswered

[Urgent case!!!!!!] How to use Filter Query for List rows present in a table.

(0) Share

Report

Posted on by HaiNguyen202

Hi,

I would like to ask about my flow within using Filter query. You can see if I don't apply any filter the value box would contain 3 values. However, when I apply the filter query the value is unavailable. Please find the pictures attached.

this pic indicates there are 3 values if I don't apply any filter query.

this pic indicates there is no any value when I apply the filter, but it should be 1 because there is a value having the same value in the table (please check the Excel table on the last pic).

Basically, I would like to apply a condition that if the number of value within filter query applied is 1 then do next step, and think that when I apply the filter query the value should be 1, but the value is 0.

length(outputs('List_rows_present_in_a_table_2')?['body/value'])

Here is my table.

Categories:

Using flows

I have the same question (0)

All responses (13)

Answers (1)

Mira Ghaly 11,413 Moderator on at

Like (1)

Report

@HaiNguyen202

Try removing the single quotes

Was this reply helpful? Yes No
HaiNguyen202 43 on at

Like (0)

Report

Hi @Mira_Ghaly,

Thanks for your response. I have tried and didn't work. btw, do you know which the format in excel table is appropriate to the filter query?

Was this reply helpful? Yes No
HaiNguyen202 43 on at

Like (0)

Report

the value is still empty

Was this reply helpful? Yes No
Mira Ghaly 11,413 Moderator on at

Like (1)

Report

@HaiNguyen202

Actually your filter query looks ok.. there is no specific format required, what is the format of your column so I can try to reproduce at my side?

Was this reply helpful? Yes No
HaiNguyen202 43 on at

Like (0)

Report

Hi @Mira_Ghaly ,
I have deleted the format and tried again, and it's still not working. Now my format is General.
I have created another table, another excel file, new flow and set the filter query: ID eq 1 and ID eq '1' (the picture below), the value is still empty. BUT when I filter the Name column Name eq 'Hai nguyen', the value is 2 (so it's working). THEN I applied this method to the previous table, filter the Name column but the value is still empty. Please help me out!

Was this reply helpful? Yes No
Mira Ghaly 11,413 Moderator on at

Like (1)

Report

@HaiNguyen202

Can you try with number format?

Is there is any other tables on your excel sheet?

Was this reply helpful? Yes No
HaiNguyen202 43 on at

Like (0)

Report

Hi @Mira_Ghaly ,
I have tried every format for 4 hours. and there is the only table in my sheet (but I think it's not the issue).

Was this reply helpful? Yes No
Mira Ghaly 11,413 Moderator on at

Like (1)

Report

@HaiNguyen202

I have tried on the excel sheet you shared but no matter what I experienced the same behaviour you are experiencing , i could only work using the Filter array as below:

Was this reply helpful? Yes No
HaiNguyen202 43 on at

Like (0)

Report

Thanks @Mira_Ghaly
The reason I want to use filter query as I need to work on the dedicated row. Yesterday, I worked normally on this filter but today the issue starts.

Was this reply helpful? Yes No
Mira Ghaly 11,413 Moderator on at

Like (0)

Report

@HaiNguyen202

Let me know if this has worked for you!

Was this reply helpful? Yes No