Unanswered

search a Trigger Condition to recognize that the EMAIL is a calendar entry

(0) Share

Report

Posted on by fraenkers

I have a trigger that detects whether a new email has arrived in a shared mailbox. However, this trigger should only activate if the email is not an invitation to an appointment.

I have already tried the following two approaches,

not(contains(triggerOutputs()?['body'], 'BEGIN:VCALENDAR'))
and
not(contains(triggerOutputs()?['headers']['Content-Type'], 'text/calendar'))

but I get an error when saving:

The power flow's logic app flow template was invalid. The template condition expression 'not(contains(triggerOutputs()?['body'], 'BEGIN:VCALENDAR'))' at line '1' and column '3557' is not valid template language expression.

same by Using Content-Type

How can i solve my problem?
Thank you for your help.

Categories:

Building flows

I have the same question (0)

All responses (5)

Answers (0)

Sort by

Expiscornovus 33,876 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @fraenkers,

A couple of things to double check.

1. Did you use an '@' at the beginning of your trigger condition? A trigger condition always starts with the '@' character.

2. You want to check if the body of the message contains BEGIN:VCALENDER, correct? In that case use the body/body instead.

Can you try this expression instead?

I also changed the format of the and function, I placed it at the beginning.

@and(not(contains(triggerOutputs()?['body/body'], 'BEGIN:VCALENDAR')), not(contains(triggerOutputs()?['headers']['Content-Type'], 'text/calendar')))

Was this reply helpful? Yes No
fraenkers 13 on at

Like
a
(1)

Report
Copy link

Link copied!

G - I'M so stupid 😄 sorry - perhaps this is the problem - i will check this later

Was this reply helpful? Yes No
fraenkers 13 on at

Like
a
(0)

Report
Copy link

Link copied!
Hello,
Thank you very much for your comments.
The mistake was indeed just eliminated by adding the @.
However, it's not working as it should, and I don't know why.
Even the example from @Expiscornovus doesn't work as desired.
So, as correctly identified, the Flow should send an autoresponder for every incoming EMAIL in a group mailbox, except if it's a calendar entry.
In the meantime, I've also tried this:

@not(or(contains(triggerOutputs()?['headers']['Content-Type'], 'text/calendar'), contains(triggerOutputs()?['body'], 'Content-Type: text/calendar')))
and
@not(or(contains(triggerOutputs()?['headers'],'Content-Type: text/calendar'), contains(triggerOutputs()?['body'], 'Content-Type: text/calendar')))
But that also doesn't work - the sender recived an autorespnse for a Invitation.
But, the text phrase "Content-Type: text/calendar" is so clearly in a calendar entry. Do you have any other ideas on how I can solve this?
Many thanks.

Was this reply helpful? Yes No
Expiscornovus 33,876 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @fraenkers,

Can you share the outputs of the trigger action from one of the flow instances which was triggered by one of the appointment e-mails which you want to ignore? This will help determine the trigger condition we need.

Btw, did the example I shared give an error. Or do you mean it does not work in the sense that some e-mails still trigger the flow, which should not?

Was this reply helpful? Yes No
fraenkers 13 on at

Like
a
(0)

Report
Copy link

Link copied!

Hello @Expiscornovus

I apologize for the long gap in communication. I had replied to you, but the message seems to have disappeared. I'm not sure what happened there.
Attached are the details you requested. I believe I've identified the issue: the trigger conditions "@and(not(contains(triggerOutputs()?['body/body'], 'BEGIN:VCALENDAR')), not(contains(triggerOutputs()?['headers']['Content-Type'], 'text/calendar')))" are not applicable here because neither condition is met, even though I'm not sure why that is the case. It looks like I'll have to explore alternative solutions.
On a positive note, your approach was correct; there are no longer any errors. The only issue is that it's not producing the outcome I had hoped for
Best regards
Frank

Code.docx

Was this reply helpful? Yes No