cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Kudo Kingpin
Kudo Kingpin

Invalid-usage-of-the-option-NEXT-in-the-FETCH-stat in powerapps filter

Invalid-usage-of-the-option-NEXT-in-the-FETCH-statement, in correct syntax near <

 

I am getting above error in powerapps filter gallery, the same filter is working fine when done on button click.

4 REPLIES 4
Highlighted
Community Support
Community Support

Re: Invalid-usage-of-the-option-NEXT-in-the-FETCH-stat in powerapps filter

Hi AmitLoh,

 

Could you provide more details?
1. What’s the data source?
2. How did you configure the function to filter the Gallery? Could you show me the codes?

 

Please check this document about Filter function to see more details about Filter:
https://powerapps.microsoft.com/en-us/tutorials/function-filter-lookup/


Best regards,
Mabel Mao

Community Support Team _ Mabel Mao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
Kudo Kingpin
Kudo Kingpin

Re: Invalid-usage-of-the-option-NEXT-in-the-FETCH-stat in powerapps filter

Filter(Sort(ourdatasource, RecordId, Ascending),  (ProductGroup=TextInputsearch.Text || LocalProductName=TextInputsearch.Text || GenericName=TextInputsearch.Text || Region1=TextInputsearch.Text || WHOATCCode=TextInputsearch.Text || TherapeuticAreas=TextInputsearch.Text || Indication=TextInputsearch.Text || Description = TextInputsearch.Text || Company = TextInputsearch.Text)))

 

Now same filter works on button click but on gallery Items if I put same filter it gives me this weird error.

Highlighted
Community Support
Community Support

Re: Invalid-usage-of-the-option-NEXT-in-the-FETCH-stat in powerapps filter

Hi AmitLoh,

 

What are the column types?


I guess there might be some column types that are not supported in the filter function.
Please try to enter Formula1 [,Formula2,…] one by one to see which one is invalid.
Filter( Table, Formula1 [, Formula2, ... ] )

 

I tried with the similar filter function on my side, it can filter with no error. I set the Items property of the Gallery looks like below:
Filter(Sort(listF,ID,Ascending),(Title=TextSearchBox1.Text || q7kf=TextSearchBox1.Text ||g87p=TextSearchBox1.Text))


Best regards,
Mabel Mao

Community Support Team _ Mabel Mao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
Microsoft
Microsoft

Re: Invalid-usage-of-the-option-NEXT-in-the-FETCH-stat in powerapps filter

 am getting the same error. Any update on this?

Helpful resources

Announcements
Ignite

Microsoft Ignite

This will be a conference that you do not want to miss!

secondImage

New Return to Workplace

Reopen responsibly, monitor intelligently, and protect continuously with solutions for a safer work environment.

August 2020 CYST Challenge

Check out the winners of the recent 'Can You Solve These?' community challenge!

Experience what’s next for Power Apps

Join us for an in-depth look at the new Power Apps features and capabilities at the free Microsoft Business Applications Launch Event.

Check this Out

Helpful information

Featuring samples like Return to the Workplace and Emergency Response Applications

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (3,191)