Unanswered

Unable to Properly Parse "&&" (ampersand) within odata Filter Query

(0) Share

Report

Posted on by Community Power Pla...

Hello,

I am retrieve an Outlook event which has the Subject of "P&G: CaaS 1.5 NA - Deployments - Brantford - Go/No-go." My Filter Query is: Subject eq 'P%26G: CaaS 1.5 NA - Deployments - Brantford - Go/No-go'

The "&" (ampersand) was breaking the query, so I replaced it with the %26. However, no results are returned.

I created another event with the name: PG: CaaS 1.5 NA - Deployments - Brantford - Go/No-go

This time everything worked normally.

Does anyone know how best to build the Filter Query within Flow for this situation? (Subject is random, sometimes containing the "&" and other times not.)

All help is appreciated.

Thank you.

Categories:

Using flows

I have the same question (0)

All responses (7)

Answers (1)

efialttes 14,756 on at

Like (0)

Report

@Anonymous

Have yo tried with a "Filter Array" action block instead of an ODATA Filter Query? It is less efficient, but sometimes more powerful

Hope this helps

Was this reply helpful? Yes No

Brad_Groux

4,556 on at

Like (1)

Report

These are the characters that need to be converted for an ODATA filter query:

/	Separates directories and subdirectories.	%2F
?	Separates the actual URL and the parameters.	%3F
%	Specifies special characters.	%25
#	Indicates bookmarks.	%23
&	Separator between parameters specified in the URL	%26

You need to also converted the / in Go/No-go, like so:

Subject eq 'P%26G: CaaS 1.5 NA - Deployments - Brantford - Go%2FNo-go'

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

Was this reply helpful? Yes No

Community Power Pla... on at

Like (0)

Report

Thank you for the insight. The Filter Query is still not finding the match. I have replaced the special characters, including the ':' with hex-equivelants. Here's the new string:

Subject eq 'P%26G%3a CaaS 1.5 NA - Deployments - Brantford - Go%2fNo-go'

The method isn't complaining; it simply does not return a result.

More insight?

Cheers.

Was this reply helpful? Yes No
v-yamao-msft on at

Like (2)

Report

Hi @Anonymous ,

The issue could be reproduced by me.

I am trying to figure out a solution for it.

As an alternative way, please use Filter array instead, which will filter out the expected result for you as well.

Best regards,

Mabel

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

Like (0)

Report

Thank you for the concept. I must be doing something worng because I am still getting every event on my calendar and not just the one unique event.

When I examine the Filter Array, I see Body [ ] as the output. Is this the single event ID I am seeking so that I can act upon it with a Send email?

Your insight is appreciated and anticipate.

Cheers.

Was this reply helpful? Yes No
Verified answer

Community Power Pla... on at

Like (1)

Report

Problem has been resolved using the original odata Filter Query. The '&' (ampersand) had to be substituted with '%26' but none of the other characters required substituition.

Other than the '&' (ampersand) issue, the other thing that I discovered was that the event was not being found because it was part of a series with a different Subject. I changed one meeting within the series to a different Subject, and that Subject was what I was trying to find with the Filter Query.

Thanks everyone for the clues that helped me reach a fix.

Cheers.

Was this reply helpful? Yes No
v-yamao-msft on at

Like (0)

Report

Hi @Anonymous ,

Thanks for updating and sharing.

I am glad to hear that the issue has been resolved.

Best regards,

Mabel

Was this reply helpful? Yes No