excel odata filter error

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

After I use filter odata function in my excel file , it showed this error message .

My filter is 出工數 eq '10'

Categories:

Using flows

I have the same question (0)

All responses (3)

Answers (0)

Sort by

yashag2255 24,769 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hey @Anonymous

I think special characters are not supported in filter queries. Can you change the column name to english and without any spaces/special characters and check if it works?

Hope this Helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

I neet to test if the column name change to "english" ,because this excel data is come from microsoft form

thank you very much for your reply
@yashag2255

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

@yashag2255

Later I change the method to compare excel datetime , it works , before change the process need over 15 mins now it only need 10 secs .

first time , I use condiction in excel ............now I put excel data to array , then use array to filter what I need data

1--> I use one excel and the file in my onedrive
2-->put today string in one cell
3-->get my imporant excel content
4-->put excel data to my array and filter excel data
5-->put filtered data to my string
finally put the string to my teams channel

then I saw the speed up my flow

Was this reply helpful? Yes No