Flow Get items Filter Query Error

(0) Share

Report

Posted on by Phineas

5,325 Super User 2025 Season 2

I am getting a error on my 'Flow' Get items filter query.

The SP List have a column titled Course_Name.

The Power Apps trigger shows text_2 with the title of 'Course_Name'.

I have written the following fitler query -

The error message is -
The expression "'Course_Name' eq 'Driver's Permit Practice Test'" is not valid. Creating query failed.

What am I missing?

Categories:

Using flows

I have the same question (0)

All responses (1)

Answers (1)

Verified answer

Ellis Karim 11,695 Super User 2025 Season 2 on at

Like (0)

Report
The query text contains a single quote: Driver's Permit Practice Test

and it gets interpreted as Course_Name eq 'Driver'. The remainder of the text is causing the error.

Single quotes need to be escaped by doubling them:

Course_Name eq 'Driver''s Permit Practice Test'

replace(variables('queryText'),'''', '''''')

Ellis Karim
Blog | LinkedIn | Bluesky
If this solved your issue, please mark it as ✅ Accepted Answer. If it helped, feel free to give it a 🩷 Like!

Was this reply helpful? Yes No