Unanswered

Having Problems with Single Quotes or Apostrophes inside Flow to Sharepoint List

(0) Share

Report

Posted on by rys

Hey All,

So I have a bunch of flows running that transfer people from one sharepoint list to another. I'm using an ODATA query to figure out if the user exists on the list already.

First_x0020_Name eq 'DYNAMIC CONTENT FIRST NAME' and Last_x0020_Name eq 'DYNAMIC CONTENT LAST NAME'

So far I'm having great success except for one thing. For last names such as O'Brien and O'Reilly it's having issues with the apostrophe in the name. Anyone have any brilliant ideas on how I can make this work?

Thanks!

Categories:

Using connectors

I have the same question (0)

All responses (4)

Answers (0)

v-yuazh-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

Hi @rys,

I have made a test on my side and the issue is confirmed on my side.

Please take a try to create the flow with a "Filter array" action as below:

When an item is created with the First Name is equal to O'Brien, the Last Name is equal to O'Reilly,

The flow would run successfully as below:

Best regards,

Alice

Was this reply helpful? Yes No
rys 69 on at

Like (0)

Report
Copy link

Link copied!

Hey Alice,

Thank you for this, however, I don't know how to make this work with what I'm doing. (sorry, newbie!)

I have the flow running on a recurrence, once per hour.
The ODATA query is in Get items 2 to see if the user exists, and then I use the following true/false condition to decide what to do with them:
@equals(length(body('Get_items_2')?['value']), 0)

I tried to drop in the filter array between the Get items 2 and the condition and then play with the condition statement, but I couldn't get it to work.

Was this reply helpful? Yes No
Eric6 118 on at

Like (0)

Report
Copy link

Link copied!

This works. Thanks a lot.
The issue is real in the built-in filter of "Get items", but it does not occur when using the array filter. For beginners, it is also possible to use the array filter with dynamic content, not only in the "advanced mode". This will then require a chain of multiple array filters, but it does not necessarily have to look pretty to work.
Best regards,
Eric

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

I know this is an old thread, but I had this issue and I found it easier to do this
How to use string with apostrophe (') in Power Automate filter query (tomriha.com)

Hope it helps.....

Was this reply helpful? Yes No