cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper II
Helper II

excel odata filter error

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

My filter is 出工數 eq '10'

20190926-5.JPG

3 REPLIES 3
Highlighted
Dual Super User III
Dual Super User III

Re: excel odata filter error

Hey @JACK_LAI 

 

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!

Highlighted
Helper II
Helper II

Re: excel odata filter error

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 

Highlighted
Helper II
Helper II

Re: excel odata filter error

@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

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Power Platform ISV Studio

Power Platform ISV Studio

ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.

Tech Marathon

Maratón de Soluciones de Negocio Microsoft

Una semana de contenido con +100 sesiones educativas, consultorios, +10 workshops Premium, Hackaton, EXPO, Networking Hall y mucho más!

Users online (6,491)