This is so easy, but I am such a beginner... Free ice cream emojis if you help me!

[PieterJansen]

So, teacher from Netherlands here, actually a Teams-consultant starting to learn Power Automate. In this Covid-crisis my Teams-team suddenly became quite important 😉

I want to start the day for my students with a "Good morning, today you can reach {name}, {name} and {name}. And, don't forget: {message}" 

I have a Excel like this:

	Name	Name	Mess
Mond	James	John	Think about the lecture!
Tues	Mary	Joe	🙂
Wed	John	Tina	Almost weekend!

I can make a automation that runs everyday and kinda understand the Post a message in Teams block, but who can help me how to create the automation in the middle? How to design my Excel-file? Or has another way of doing this any smart way? 

Hope to hear from you!

Pieter

[abm]

Hi @PieterJansen 

You can use the trigger as scheduled trigger , set that as a daily run. Also you could use the excel connector to read your file and get the message. The  workout which day it is using UTCNow() function and filter the record from your excel sheet. Finally use the post message of team connector to send the message.

Thanks

[PieterJansen]

Should I use 'get row'? I am struggling with key-column and key-value?

[abm]

Hi @PieterJansen 

In your case I believe you have an excel sheet with 7 days of message . So you need Get Items filtered by 'Monday' or 'Tuesday' etc.

If you looking for Get item then it will only get that particular row which you mentioned in Key and Row.

Please see my blog about how to filter excel rows.

https://mydevexperience.wordpress.com/2019/09/25/microsoft-flow-excel-list-rows-present-in-a-table/

[abm]

Hi @PieterJansen 

This might be useful for you. To find which day it is you need to use the expression

Above will return Monday, Tuesday, etc. Next you can pass the above output to your excel filter against your column name to retrieve the correct message for each day.