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

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Graph Api - Invalid fi...
Power Automate
Answered

Graph Api - Invalid filter clause: There is an unterminated string literal Error

(0) ShareShare
ReportReport
Posted on by 11

Hi I'm trying to use the graph API to get the email form the outlook using the subject filter. The subject filter is having an "#" (hashtag)  in it eg. "[CMS Case ID: #1040] Case Created Successfully". but the graph API is showing error for "#"  like Invalid filter clause: There is an unterminated string literal at position 25 in 'subject eq '[CMS Case ID:'. Please help me with this issue how can i use the "#" in subject filter.

 

YugesRaj001_0-1714628099960.png

YugesRaj001_1-1714628202579.png

 

Thanks regards,

Yugesraj

 

 

Categories:
I have the same question (0)
  • Verified answer
    v-yueyun-msft Profile Picture
    on at

    Hi , @YugesRaj001 

    Please replace the # to  %23 in your side:

    vyueyunmsft_0-1714629308376.png

     

     

    vyueyunmsft_1-1714629329241.png

     

    If this reply can help you , you can click mark this reply as solution (Accept solution) which can help more people, thanks in advance! 

     

    Best Regards,

    Yueyun Zhang

     

     

  • YugesRaj001 Profile Picture
    11 on at

    Hi @v-yueyun-msft  Thank you for your response , I have tried the same but the API is not fetching any emails that is the output is empty , it is  considering "%23" as a string. Can you help me in this.

    YugesRaj001_1-1714630689495.png

     

  • Verified answer
    v-yueyun-msft Profile Picture
    on at

    Hi , @YugesRaj001 

    I test it in my side , it can work like this, can you check if you input the correct subject and it contains in your raw return?

    vyueyunmsft_0-1714631000915.png

    If this reply can help you , you can click mark this reply as solution (Accept solution) which can help more people, thanks in advance! 

     

    Best Regards,

    Yueyun Zhang

     

     

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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 519 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 296 Moderator

#3
abm abm Profile Picture

abm abm 232 Most Valuable Professional

Last 30 days Overall leaderboard