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)

Expiscornovus 33,195 Most Valuable Professional on at

Like (0)

Report
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 (1)

Report

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 (0)

Report
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,195 Most Valuable Professional on at

Like (1)

Report

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 (0)

Report

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