web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / excel odata filter error
Power Automate
Unanswered

excel odata filter error

(0) ShareShare
ReportReport
Posted on by

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

My filter is 出工數 eq '10'

20190926-5.JPG

Categories:
I have the same question (0)
  • yashag2255 Profile Picture
    24,769 Super User 2024 Season 1 on at

    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!

  • Community Power Platform Member Profile Picture
    on at

    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 

  • Community Power Platform Member Profile Picture
    on at

    @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 

     

    20190930-1.JPG

     

    1--> I use one excel and the file in my onedrive

    2-->put today string in one cell

    20190930-2.JPG

    3-->get my imporant excel content

    4-->put excel data to my array and filter excel data

    20190930-3.JPG

    5-->put filtered data to my string 

    20190930-4.JPG

    finally put the string to my teams channel

    20190930-5.JPG

     

     

    then  I saw the speed up my flow 

    20190930-6.JPG

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 538 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 405 Moderator

#3
abm abm Profile Picture

abm abm 252 Most Valuable Professional

Last 30 days Overall leaderboard