Is it possible to create a trigger that let's me create an event on outlook calendar based on an email information?

[mip09]

I was asked to do a flow that let's me create an event on outlook based on the info inside the email. The info is about the deadline of an construction, its name, date and hour. It also has attachments that should be on the event calendar as well. I have tried a lot of actions however since this is my first time with Power Automate it is giving me a lot of errors on the execution of it. Could you please help me?

[v-yetonggu-msft]

Hi @mip09 ，

Unfortunately not, in the Body section you can add a link for we are not able to add an attachment yet.

Best Regards,

Sunshine Gu

[NicholasNg]

How consistent is the email that contains all these details and attachments? Are they computer generated or manually sent by people?

There's a trigger that is based on receipt of an email, you can filter the trigger based on phrases within the subject. You could parse details from the body section for the deadline details and name. 

[mip09]

Hello, first of all, thank you for your answer!

These emails come every day more than 1 time. They are generated by people.

"You could parse details from the body section for the deadline details and name. ". Could you help me on how to do it?

[VictorIvanidze]

Hi @mip09,

could you show the initial email and the resulting event you have done manually? 

[mip09]

Here it is the initial email:

Work Permit Nº: 896/2023/DFT

Referring to: Light instalation

Deadline: 24-11-23 to 30-11-23

Schedule: 10H00M - 04H00M

[VictorIvanidze]

And what about the resulting  event?

[mip09]

Not really understood what you want with that. The event should be scheduled with the exact dates presented in "Deadline: 24-11-23 to 30-11-23" . However, I could not proceed to do anything because I don't know how to extract that exact information out of the body of the email to schedule it all alone.

[VictorIvanidze]

Wait a minute. You're going to do something automatically using a flow. My question was: can you show how to do that manually?

You see an initial email in Outlook Inbox. Can you create an event in Outlook calendar based on this email?

[mip09]

By doing it manually you just press the days you want and create the event you need. 

See here:

[VictorIvanidze]

How this recurrent appointment is linked with the 

initial email:

Work Permit Nº: 896/2023/DFT

Referring to: Light instalation

Deadline: 24-11-23 to 30-11-23

Schedule: 10H00M - 04H00M

[mip09]

It is not. But I want to make that email info appear on the calendar of outlook like an event so we can see it more easily.

[VictorIvanidze]

But I want you to show me how will it look like (i.e. how you are going produce an event from an email)!

[mip09]

I was precisely asking for that because I don't know how to do it. I was thinking about doing:

however it is not working the way I wanted to

[VictorIvanidze]

If you do not want (or you cannot) show how to create an event manually, then you cannot create a flow and I cannot help you, sorry.

[mip09]

I have showed you previously. You just need to go to outlook, press the day/days you want it to be, set the time and done. Don't actually understand what you want me to show you more.

[VictorIvanidze]

I still don't understand what do you mean saying "press the day/days you want it to be". Create a video!

[mip09]

The email contains dates. I want those dates to be inserted in an outlook calendar as an event. 

[VictorIvanidze]

Great! To be inserted _where_? Show me finally.

[NicholasNg]

Since people are generating the email, is the format of the email consistent between each person? Does everyone use this format:

Work Permit Nº: 896/2023/DFT

Referring to: Light instalation

Deadline: 24-11-23 to 30-11-23

Schedule: 10H00M - 04H00M

Parsing only really works if Deadline is always before Schedule and always after Referring to. 

What you need to do is to split the body of your text by definable sections. For example: If you want the deadline, then you'd want to

1. split by "Deadline:" (which gives you "(everything before this too) Work Permit Nº: 896/2023/DFT Referring to: Light instalation" and "24-11-23 to 30-11-23 Schedule: 10H00M - 04H00M")
2. Take the last section "24-11-23 to 30-11-23 Schedule: 10H00M - 04H00M" and split by "Schedule:" to get (24-11-23 to 30-11-23) and (10H00 - 04H00M)
3. Take the first of these within the array, which is (24-11-23 to 30-11-23)
4. So the expression for this would be something like first(split(last(split(dynamic email body from Power Automate,'Deadline: ')),'Schedule: '))

Now my formula needs to be updated to have the correct expression for the body of the email inside. Also the 'Deadline: ' and 'Schedule: ' could be wrong if you start seeing HTML formatting come out. Update it to include what you see from the outputs and experiment around. 

I suggest you create a compose for each of the portions you need and you can use the compose to populate the create event task after that.