filter rows with apostrophe

(1) Share

Report

Posted on by Marianoz0503

Hi,

I have this behavior when try to filter rows from dataverse.

I got this error

the value is PEP'S DIPLOMATIC CAREER and in the Dataverse exist whit that name

Any idea to fix that ?

Thanks for your help

Categories:

Building flows

I have the same question (0)

All responses (7)

Answers (1)

trice602 15,404 Super User 2025 Season 2 on at

Like (1)

Report

Hi @MarianoZuniga05 ,

I think you are going to need to refer to the column name, not the Display name. Here's an example:

How to find column name? Go into your table at Power Apps, click into relevant table and then find your column.

Was this reply helpful? Yes No
Marianoz0503 93 on at

Like (1)

Report

Hi @trice602 the column name is correct

I am trying to get the specific row in that table and I used that filter column.
I need the row when the 'Nombre t24' is equals 'PEP'S DIPLOMATIC'

Was this reply helpful? Yes No
trice602 15,404 Super User 2025 Season 2 on at

Like (1)

Report

Hi @MarianoZuniga05 ,

Please add an extra apostrophe, my test was successful.

Was this reply helpful? Yes No
Marianoz0503 93 on at

Like (1)

Report

But I can't modified the value in that way with hardcoded because the value is from other DataSource and in sometime the value has apostrophe or not

Was this reply helpful? Yes No
trice602 15,404 Super User 2025 Season 2 on at

Like (1)

Report

Or???

Was this reply helpful? Yes No
Marianoz0503 93 on at

Like (1)

Report

But the problem is I need that action works for any value from this table. So I can't put in that way because it is able to receive any value from this list.

For example:

in this case the expression works fine

The issue is when the value is 'PEP'S DIPLOMATIC'

Was this reply helpful? Yes No
Verified answer

Marianoz0503 93 on at

Like (1)

Report

I fixed the issue with this function

rs_nombret24 eq 'replace(items('Apply_to_each')?['ib_profesion'],'''','''''')'

Refer to this

https://tomriha.com/how-to-use-string-with-apostrophe-in-power-automate-filter-query/

Was this reply helpful? Yes No