You’re offline. This is a read only version of the page.
43
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.
Here is my table.
@v-xiaochen-msft Thank you for your support!.
However, it's still not working either with quote mark nor without it. The value is still empty! And I have changed the column name. The value in the column must be number so I cannot change it. I think it's a bug so could you please report it.
Hi @HaiNguyen202 ,
Please do not use numbers as column names of excel table.
This causes many problems .
So, please try these steps:
1\ Rename your column name.
2\ Delete the parameters in this option and reselect the same excel file.
3\ Save the flow.
4\ Clear the browser cache and retest
Best Regards,
Wearsky
Hi @Mira_Ghaly ,
I think MS power automate has been updated something new and this is the bug, as last time I still used it smoothly. Do you know how to call out the MS support team?
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.
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:
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).
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!
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?
#1
WarrenBelz
146,658
Most Valuable Professional
#2
RandyHayes
76,287
Super User 2024 Season 1
#3
Pstork1
65,999
Most Valuable Professional
Share
Report
All responses (
Answers (
