web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Filter query issue whi...
Power Automate
Unanswered

Filter query issue while using / (slash) in Column Name

(0) ShareShare
ReportReport
Posted on by 17

Filter query in "list row present in a table" doesn't support when we use a slash in the column name. It throws an error. Is there a way to solve this issue?

Riyas_0-1704806398990.png

 

Categories:
  • srduval Profile Picture
    1,796 Moderator on at

    Maybe you can try encoding the column name to uri standards.

     

    abc/def

    encoded becomes 

    abc%2Fdef

  • srduval Profile Picture
    1,796 Moderator on at

    you can look up the various sharepoint APIs and run them via power automate, or look at the raw output of a get items, there is an API that will return the columns (maybe with data, can't remember), basically you are looking to see what a column is called behind the scenes, as what is displayed is not always what the system calls the column, happens a lot with columns renamed after being created. 

  • Riyas Profile Picture
    17 on at

    Hi srduval,

     

    Still, the error continues.

    Riyas_0-1704807842594.png

     

  • srduval Profile Picture
    1,796 Moderator on at

    Looks like I might have the right idea, but wrong syntax, try this instead:

    EIN_x002F_UIN

     

    How to Encode SharePoint Column Display Names to Internal names (tachytelic.net)

  • Riyas Profile Picture
    17 on at

    Hi srduval,

     

    I tried your solution. The error still shows

    Riyas_0-1704810529997.png

     

  • srduval Profile Picture
    1,796 Moderator on at

    That suggests the name you see is not the name of the field behind the scenes, navigate in your browser to the document library that you are trying to use in the flow, and then replace everything after the site name with this:

    /_api/web/lists/GetByTitle('Enter Document Library Name Here')/fields

     

    so you would have 

    abc.sharepoint.com/SiteName/_api/web/lists/GetByTitle('Enter Document Library Name Here')/fields

     

    then search the output for the field name you are wanting to filter on, once you find it, look at the text that follows for the internal name. That is what you need to put into your filter expression in power automate. 

     

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Leaderboard > Power Automate

#1
Mohsin Ali Profile Picture

Mohsin Ali 289

#2
11manish Profile Picture

11manish 282 Super User 2026 Season 2

#3
Henil Profile Picture

Henil 119

Last 30 days Overall leaderboard