You’re offline. This is a read only version of the page.
After I use filter odata function in my excel file , it showed this error message .
My filter is 出工數 eq '10'
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
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
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!
#1
WarrenBelz
146,524
Most Valuable Professional
#2
RandyHayes
76,287
Super User 2024 Season 1
#3
Pstork1
65,906
Most Valuable Professional
Share
Report
All responses (
Answers (
