Hello, everyone. This is my first post.
I have a problem with Filter Query.
I'm making flow which triggers on Email receiving.
If it is new message from client it saves in a list information about problem, files and ConversationID from outlook.com connector.
If we receive Email Containing for example "RE:" in its subject. In this case "Get items" Filter Query ConversationID from a list with ConversationID from Email.
But it does not work but same time in outcome I see this "funny picture" :
'AQQkADAwATMwMAItNGQwZS1jYWM5LTAwAi0wMAoAEAA-bBifVGZBMqKVAzvIxvDb'eq'AQQkADAwATMwMAItNGQwZS1jYWM5LTAwAi0wMAoAEAA-bBifVGZBMqKVAzvIxvDb'
Where Conversation ID equal from both sides.
Could it be some kind format mismatch?
Solved! Go to Solution.
Hi @PavelsO,
Great to see it is working. That was actually what I was trying to suggest with my previous reply. Great that you figured it out 🙂
Hi @PavelsO,
Can you remove the single quotes around the Conversation ID field? Can you format your Filter Query like below (with only single quotes around the converID) and try again?
<Conversation ID field> eq '<ConverID variable>'
Thank you for your idea .. but nothing is changed
"body":{"status":400,"message":"The expression \"AQQkADAwATMwMAItNGQwZS1jYWM5LTAwAi0wMAoAEAA-bBifVGZBMqKVAzvIxvDb eq 'AQQkADAwATMwMAItNGQwZS1jYWM5LTAwAi0wMAoAEAA-bBifVGZBMqKVAzvIxvDb'\" is not valid. Creating query failed.\r\nclientRequestId: 8b7ab613-2c4f-4d72-9c29-969ad9d4b1a0\r\nserviceRequestId: 8b7ab613-2c4f-4d72-9c29-969ad9d4b1a0"}}
Finally ))
This one is correct: ConversationID eq '@{variables('ConverID')}'
Hi @PavelsO,
Great to see it is working. That was actually what I was trying to suggest with my previous reply. Great that you figured it out 🙂
User | Count |
---|---|
88 | |
39 | |
23 | |
20 | |
16 |
User | Count |
---|---|
128 | |
47 | |
46 | |
27 | |
25 |