Summary of Birthdays for the Week Flow

[rodamalco]

I am trying to create a flow that sends a weekly email for birthdays that in the next 7 days. The birthdays are all in a List that I am connecting to in the flow. 

Things I'm having trouble with:

1) I want a summary email and not an "apply to each" because I do not want an individual email for each of the birthdays 

2) I keep getting an error message for the action that looks for the birthday: InvalidTemplate. Unable to process template language expressions in action 'Birthday' inputs at line '0' and column '0': 'The template language expression 'formatDateTime(item()['Birthday'],'MM-dd')' cannot be evaluated because property 'Birthday' cannot be selected. Please see https://aka.ms/logicexpressions for usage details.'.

[Sundeep_Malik]

Hey @rodamalco 

Can you give the json data of the above. Remove names with abc, def something. I might be able to help you then.

[rodamalco]

I built a test list. This is all the data it has:

Here is the input expression I used for birthdays:

formatDateTime(item()['Birthday'],'MM-dd')

and this is input expression I used for "this week"

formatDateTime(utcNow(),'MM-dd')

[Sundeep_Malik]

@rodamalco 

Can you try

item().Birthday

If this works, next we will see how we can send just one mail for all.

[rodamalco]

InvalidTemplate. Unable to process template language expressions in action 'Birthday' inputs at line '0' and column '0': 'The template language expression 'formatDateTime(item().Birthday,'MM-dd')' cannot be evaluated because property 'Birthday' cannot be selected. Please see https://aka.ms/logicexpressions for usage details.'.

[RobElliott · Accepted solution]

Not wishing to step on @Sundeep_Malik 's toes, but we do this every Monday morning at my company and so I have the flow already prepared. 

In this example we only want the first 2 people, Chris Rea and David Paton, to be listed in the table in the email.

To avoid the apply to each you need to use a Select action:

The table is formatted as follows:

Spoiler

<style>
table {
  border: 1px solid #1C6EA4;
  background-color: #EEEEEE;
  width: 80%;
  text-align: left;
  border-collapse: collapse;
}
table td, table th {
  border: 1px solid #AAAAAA;
  padding: 3px 2px;
}
table tbody td {
  font-size: 13px;
}
table thead {
  background: #1C6EA4;
  border-bottom: 2px solid #444444;
}
table thead th {
  font-size: 15px;
  font-weight: bold;
  color: #FFFFFF;
  border-left: 2px solid #D0E4F5;
}
table thead th:first-child {
  border-left: none;
}
</style>
{outputs of the create html table action}

Rob
Los Gallardos
If I've answered your question or solved your problem, please mark this question as answered. This helps others who have the same question find a solution quickly via the forum search. If you liked my response, please consider giving it a thumbs up. Thanks.

[Sundeep_Malik]

@RobElliott 

No Problem Man. You already have the flow created that would definitely help him. I was also gonna suggest the select method. I was thinking to create a similar database, atleast your post saved me from doing that. Hehe.

@rodamalcoHis answer is correct, you should follow it.

[rodamalco]

This is super helpful. I will try it now. Is there a way to just use the day and month and not have to update the year to show the "next" birthday?

[RobElliott]

You should use the year in the compose actions because otherwise you will have a problem with the filter query. But you'll see that the email just uses the day, date and month without the year.

Rob
Los Gallardos

[rodamalco]

Got it. 

Do you know why it keeps telling me this expressions is not valid:

formatDateTime(addDays(outputs('Today')6)'yyyy-MM-dd')

[RobElliott]

You've missed out the commas before the 6 and after the 6), it should be:
formatDateTime(addDays(outputs('Today'),6),'yyyy-MM-dd')

Rob
Los Gallardos

[rodamalco]

Thank you! What I meant was avoiding having to update the list every year with by changing the year. It would be nice if I could just leave the DOB as DOB, but the "today" and "today+6" only look at day and month. 

[RobElliott]

We just have another flow that runs a couple of hours after the first one that updates those items that are less than or equal that day's date by adding 1 to the year using the expression 

addToTime(outputs('CurrentBirthday'),1,'Year', 'yyyy-MM-dd')

Rob
Los Gallardos
If I've answered your question or solved your problem, please mark this question as answered. This helps others who have the same question find a solution quickly via the forum search. If you liked my response, please consider giving it a thumbs up. Thanks.

[rodamalco]

Thank you so much!

[bebefin]

In case no birthdays for the week, how to stop the flow to send email?

 

[bebefin]

solved - @length(outputs('Get_items')?['body/value']) greater than 0