Unanswered

Syntax Issues with using Filter/Search function

(0) Share

Report

Posted on by MF-22041659-0

I am attempting to set up a bar chart in my PowerApps application, which is connected to an excel table. The table contains a column named 'Project Type', which contains a list of values including 'Admin Review'. I've tried a few approaches to setting up a filter to only include admin review items, but keep running into errors.

I have tried the following:

Filter(Table5,'Project Type'="Admin Review")
Filter(Table5; 'Project Type'="Admin Review")
Search(Table5, "Admin Review", 'Project Type')

All of these return errors, but the first one returns this error in particular. From what I can tell, the syntax seems correct. Is there something here that I am missing? I've looked through some of the other similar questions posted here but haven't figured out a solution.

Error when trying to retrieve data from the network: Syntax error at position 12 in 'Project Type eq 'Admin Review''. inner exception: Syntax error at position 12 in 'Project Type eq 'Admin Review''. clientRequestId: 9a0a14f3-4585-41fc-890b-50d6350a9ce8

Filter Table Erro...

Your file is currently under scan for potential threats. Please wait while we review it for any viruses or malicious content.

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

Sort by

WarrenBelz 155,838 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @MF-22041659-0,

Where are you based ?

Also when you start typing Filter( does Table5 come up as an option ? If so, when you continue Filter(Table5, does 'Project Type' come as an option ?

Your problem here may also be the space in the field name (not a good practice when using Excel - which is the "data source of last resort" - SharePoint is far better), so you can also try
Filter( Table5, Project_x0020_Type = "Admin Review" )

Please ✅ Does this answer your question if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider answering Yes to Was this reply helpful? or give it a Like ♥
Visit my blog Practical Power Apps LinkedIn

Was this reply helpful? Yes No
timl 37,214 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @MF-22041659-0

Just to expand on what Warren says, the space in the field name is a very likely cause.

In addition to the space between "Project" and "Type", it's easy to accidently add a trailing space to an Excel column name (eg, "Project Type " instead of "Project Type"). This mistake won't particularly be noticeable in Excel, but it'll matter in Power Apps.

If it's possible to change your column "ProjectType" without a space, you'll probably have more success. If you do change the column name, you'll need to make sure to refresh the Excel datasource in the data panel.

Was this reply helpful? Yes No
WarrenBelz 155,838 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @MF-22041659-0,

A quick follow-up to see if you received the answer you were looking for. Happy to assist further if not.

Please ✅ Does this answer your question if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider answering Yes to Was this reply helpful? or give it a Like ♥
Visit my blog Practical Power Apps LinkedIn

Was this reply helpful? Yes No