cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Slowpoke
Resolver II
Resolver II

Handling ' in Sharepoint Get Items Filter Query

Hi everyone,

I'm trying to use a Query Filter on a SharePoint - Get Items.

The query is: Title eq 'items(Apply_to_each)?[Title]'.

But every time the title includes an apostrophe ( ' ), it creates an error.

Do you know how to handle this type of error to make it work?

Thanks by advance.

1 REPLY 1
Caspar_Rubin
Solution Supplier
Solution Supplier

Hey,

 

add a Compose action before the Get items action with the following Expression:

 

replace(items(Apply_to_each)?[Title]), '''', '''''')
 
After that, use the Dynamic content from that Compose action inside your Filter Query.
 
Caspar_Rubin_0-1663863565836.png

 

In my Example, the Expression uses the value from the Compose Title action, but for you, it should be the Dynamic content items(Apply_to_each)?[Title] inside the Replace() function.

 

You could also simply use the Expression inside your Filter Query but I like to keep it clean with Compose actions... up to you.

 

that should work,

cheers

 
 

Helpful resources

Announcements
Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Users online (1,291)