Skip to main content

Notifications

Power Automate - Using Connectors
Unanswered

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

(0) ShareShare
ReportReport
Posted on by 69

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!

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

    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.....

  • Eric6 Profile Picture
    Eric6 114 on at
    Re: Having Problems with Single Quotes or Apostrophes inside Flow to Sharepoint List

    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

     

  • rys Profile Picture
    rys 69 on at
    Re: Having Problems with Single Quotes or Apostrophes inside Flow to Sharepoint List

    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.

    Flow

    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.

  • v-yuazh-msft Profile Picture
    v-yuazh-msft on at
    Re: Having Problems with Single Quotes or Apostrophes inside Flow to Sharepoint List

    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:

    Capture.PNG

     

    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:

    Capture.PNG

     

    Best regards,

    Alice

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,691

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 65,019

Leaderboard

Featured topics