@Tom_By yes you can do this using an array variable as shown in the screenshots below. In my Documents library there are 4 documents that are due for review in the next 7 days:
The flow runs at 13.00 every day and the first action is to initialize an array variable. When doing date comparisons you need to have the date format as yyyy-MM-dd. So next we add 2 compose controls, one for today's date and one for the date 7 days ahead and format them a shown:
Next, add a get files (properties only) action. But we only want to bring those items back from the library where the NextReview date is greater than or equal to the ComposeToday and less than or equal to the Compose7Days. So in the Filter Query field add NextReview ge '{output of the ComposeToday}' and NextReview le '{output of the Compose7days}'
So that we can have them in order in the email we add NextReview into the Order By field:
Next, add an Apply to each and select value from the dynamic content. I want to convert the NextReview date back to UK format but you might not need these next steps: inside the apply to each add a compose control and add the NextReview column. Then add another compose and format it as shown.
Next add an append to array variable and add the name and review date - I've used the output from the ComposeFormatDate compose for this:
Next, - outside the apply to each - if you want to you can add a create html table action and add the array.
Finally send the email and use the output from the create html table action.
The email looks as shown below. It is possible to add another compose action to add formatting to the table but I've not done that on this occasion.
Rob
Los Gallardos
Microsoft Power Automate Community Super User
@oroberts55 you can format the html table by adding the following CSS inside a compose action, changing it to taste:
You can copy the CSS from the spoiler below:
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>
@{body('Create_HTML_table')}
Then use the outputs of that compose in your email. Becauase I've also included a company logo in the email I have turned on the code view </> button and added html tags to the email
Rob
Los Gallardos
Intranet, SharePoint and Power Platform Manager (and classic 1967 Morris Traveller driver)
Worked a treat, thanks! I'm only testing at the moment, I get this:
Is there a way to format the dates so that they show as dd/mm/yyyy?
And how do I change the font?
Thanks again 🙂
Accepted Solutions
@Tom_By yes you can do this using an array variable as shown in the screenshots below. In my Documents library there are 4 documents that are due for review in the next 7 days:
The flow runs at 13.00 every day and the first action is to initialize an array variable. When doing date comparisons you need to have the date format as yyyy-MM-dd. So next we add 2 compose controls, one for today's date and one for the date 7 days ahead and format them a shown:
Next, add a get files (properties only) action. But we only want to bring those items back from the library where the NextReview date is greater than or equal to the ComposeToday and less than or equal to the Compose7Days. So in the Filter Query field add NextReview ge '{output of the ComposeToday}' and NextReview le '{output of the Compose7days}'
So that we can have them in order in the email we add NextReview into the Order By field:
Next, add an Apply to each and select value from the dynamic content. I want to convert the NextReview date back to UK format but you might not need these next steps: inside the apply to each add a compose control and add the NextReview column. Then add another compose and format it as shown.
Next add an append to array variable and add the name and review date - I've used the output from the ComposeFormatDate compose for this:
Next, - outside the apply to each - if you want to you can add a create html table action and add the array.
Finally send the email and use the output from the create html table action.
The email looks as shown below. It is possible to add another compose action to add formatting to the table but I've not done that on this occasion.
Rob
Los Gallardos
Microsoft Power Automate Community Super User